By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,166 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,166 IT Pros & Developers. It's quick & easy.

Access 2000, Excel Pivot Table and OFFICE Service Pack 3 and MACROS

P: n/a
I have a pivot table in an Access form and open the pivot Table (Excel OLE
Object) from within Access. In the Excel Table is a macro (signed) (in teh
open event) running when opening the excel object from within Access.

Since my customer have installed O2K SP3 - the Makro does not run any
longer. The curiosity is: If you open the Excel Object from within Access
and then store it to a local file - then reopen this file - the same Makro
is beeing executed?!

It is important for me to run this makros, because the refresh the
picottable data and do other things with my excel document.


Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.