Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

run an excel macro w/ vbscript

Status
Not open for further replies.

briancostea

Programmer
Apr 21, 2005
82
US
i am trying to create a script to start ms excel and run a macro stored in personal.xls. does anyone know how to do this? i know how to start excel, i need help calling the macro. thanks -

bri
 
Hello briancostea!

You can easily search this forumn to find your answer. If you were to search for "excel macro", and come up with results such as...
Code:
objexcel.Application.Run "test"
Good luck!

He who has knowledge spares his words, and a man of understanding is of a calm spirit. Even a fool is counted wise when he holds his peace; when he shuts his lips, he is considered perceptive. - King Solomon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top