About Us

MMM[_2_]

I call Excel from a batch file:
"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft\Microsoft Excel.lnk" "C:\Program Files\Corda50V2\chart_root\examples\data\homeTest_ 1_27_2004_run9.csv"
After it opens the file I want to designate a recorded macro to execute automatically (no clicking by me).
How do I do it?

Regards, MMM.

BrianB

I suggest you point your batch file to open the workbook which contains
a macro in the On_Open event. Put the .csv open code into this macro
too.

---
Message posted from http://www.ExcelForum.com/

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
*** PLEASE HELP ** Send an email from Excel to outlook with an automatic macro	SAM SEBAIHI	Excel Discussion (Misc queries)	0	November 11th 06 08:17 AM
Automatic email by Excel Macro	Anift	Setting up and Configuration of Excel	2	November 11th 06 04:33 AM
Help? start macro automatic in excel	pim_parra	Excel Worksheet Functions	2	April 8th 05 02:03 PM
Automatic Macro	ianripping[_3_]	Excel Programming	3	January 15th 04 05:22 PM
Automatic startup of an excel macro	Quist	Excel Programming	3	October 3rd 03 04:31 PM