Macro on startup to refresh linked excel table

scott-atkinson

I'm with the Witch.......
Local time
Today, 11:19
Joined
Aug 31, 2006
Messages
1,621
Guys,

I wonder if you can help me, I have a Access linked table to an Excel sheet that contains an SQL, to ensure that my database has the correct data I have to manually refresh the excel sheet prior to opening Access, is there a way that I could create a Macro on database satrt-up that would refresh the Excel sheet?
 
If you open the Excel sheet and then go to DATA / GET EXTERNAL DATA / DATA RANGE PROPERTIES you should be able to set the check box that says: Refresh Data on File Open which should refresh the data every time someone opens the database.
 
Bob,

Thanks for your help that works a dream.
 

Users who are viewing this thread

Back
Top Bottom