Automatic macros in Excel

[cbd]

I have an excel file with 3 sheets and about 40 graphs. The excel file connects to an external database when opened and populates the 3 spreadsheets with data. I have created a macro that automatically plots the graphs using the information in the 3 spreadsheets. My problem is that I want the macro to run automatically when the file is open but only after the spreadsheets have been updated from the database. I tried renaming my Autpen() but this runs the macro before the spreadsheets are updated. Is there any way to automatically run this macro after the file has connected to the external database.

 

[SkipVought]

hi cdb,

First, you ought to use the workbook/worksheet object events. So use the Workbook_Open event rather than Autpen. You can find the objects in the Project Browser and then within each object the event skeletons.

In this specific case, if you can change your links to Manual. Then, in the Workbook_Open event,

    For Each lnk In ActiveWorkbook.LinkSources(xlExcelLinks)
       Workbooks.Open Filename:=lnk, updatelinks:=3
    Next

Hope this helps Skip,