Hi all,
I've got two external tables (linked excel worksheets - call them a and b)
I want them to automatically refresh on workbook open, or before a user does much else
I don't mind if this is a user triggered event, but need to make it very obvious that this must happen before anything else is done
as background, this database links to these two data input forms, and pulls the data into a consolidated data table for subsequent analysis
How can I do this
(I've searched for a VBA/Macro method, but haven't found the right search terms yet )
as an extra twist, I'd like to ensure that the user is forced to select the input data file - (the 'always prompt for new location' option in the linked table manager) - as updates and eofy rollovers may cause the file name to change
many thanks
Werafa