Hi Guys,

I need some help with a pretty complex (at least for me) VBA code that should do the following:

I’ve got my “masterfile” which contains 6 sheets each containing a query from another Excel file (via ODBC) and some formulas based on links to “slavefile”.

What I want is to create a macro that runs everytime I open “masterfile” and that does following:

Opens up “slavefile” (not visible to user) and after that refreshes all data while showing a msgbox stating “updating sheet”. After refresh is complete sending out a message to the user that says “update complete”.

Thanks in advance!

Regards
Per