Posted to microsoft.public.excel.programming

external usenet poster

Posts: 165

Automating macro to run macro from Access

Hello,

I have an Excel file with several sheets of data from source in Access
macro. What is the macro code to call the macro named "CreateData" in Access
macro, then run refresh all in Excel to refresh all worksheets?
The manual way I am doing right now is:
1) Open Access file, then run the macro named "CreateData"
2) Open Excel file, then run an Excel macro called "Refresh" to refresh all
worksheets.

Would like to perform all at once in Excel. Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with automating macro	Cam	Excel Programming	17	December 4th 08 09:21 PM
Automating Input during a macro....	Centurius	Excel Programming	1	September 22nd 06 02:08 PM
New to VBA..need help with automating GETSAVEAS Macro in Excel 2003	xphile	Excel Programming	1	January 22nd 06 05:37 AM
automating macro	chris	Excel Programming	2	April 25th 05 05:17 PM
Frequently used macro-automating?	Ben Kingsley	Excel Programming	0	September 17th 03 05:53 PM

All times are GMT +1. The time now is 07:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us