Does Linking to Excel workbooks launch the Workbook_Open event in Excel?

  • Thread starter Thread starter Toby Erkson
  • Start date Start date
T

Toby Erkson

The saga continues...

My PowerPoint file contains many Excel links. The Excel workbooks that
provide the information use the "Workbook_Open" event to update the pivot
tables and charts within.

So, when I have my PowerPoint file Update its links, and it goes to Excel to
pull that data, do the Excel workbooks 'open' and thus execute the code in
the "Workbook_Open" event?
 
In the linked Excel file macros, try using:

Sub Auto_Open()
MsgBox "Link test worked"
End Sub

Then hyperlink to the Excel file from within PowerPoint as normal.


--
Bill Dilworth, Microsoft PPT MVP
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..
 
Back
Top