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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing argument

Status
Not open for further replies.

chopin33

Programmer
Jun 24, 2002
5
CA
Hi,
How can I pass an argument to a macro from my vb app? I tried ApExcel.Run(macroName, arg)and it doesn't seem to work. Thanks for any help =0)

 
What do you mean that it doesn't seem to work.

That is pretty vague!

What is it doing/not doing? Is it throwing an error?
 
i get an object missing error when the program reaches this line.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top