Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Refresh from Access
I have an excel spreadsheet (called "2009info") that is linked to an Access
database and I'm opening this spreadsheet with a macro (this macro is pulling data from various spreadsheets and this is only one of them). Even though the spreadsheet "2009info" is set up to refresh upon opening, it does not refresh unless I manually select the refresh button. So I thought I'd use the following command in my macro to do the refresh: ActiveWorkbook.RefreshAll This command works when I step through the macro but does not work when I simply generate the entire macro. Does anyone know why this would be happening and what can I do to get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refresh data from MS Access DB not picking up changes to criteria | Excel Programming | |||
Error on Refresh Data Import from Access | Excel Discussion (Misc queries) | |||
Refresh MSQuery w/ Access datasource issue | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Web Query Logins and Access Refresh | Excel Programming |