Excel: macro running after external data query when opening file

Question

My Excel file needs to have the two things happen automatically whenever someone opens it:

1. Import external data using a query
2. Run a macro to manipulate/move data within the workbook

** In that order.

I know how to create the query so it automatically runs upon startup, and I know how to put run a macro using Workbook_Open().  But doing these causes the macro to run first, and the data query second.  I need to reverse that order as indicated above.

Can anyone tell me how to do that?

Note I'm a total beginner in VB but pretty advanced in most of Excel.

Thanks so much y'all.

Answer 1

Call the Refresh method of your query in Workbook_Open before you call your macro, i.E.:

Sheets("Sheet1").QueryTables(1).Refresh

Andreas.

Answer 2

Hi

Andreas is correct.

It would be best not to update automatically on startup, infact disable it from doing so.  The control the refresh/update in your Workbook_Open macro.

This thread may contain some useful code for how to do the update and have the the macro run after the data refresh has completed.

http://social.technet.microsoft.com/Forums/en-US/excel/thread/ebf70407-6411-485b-a464-5aee1236c61e

Hope this helps