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 derfloh 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
Joined
Jun 24, 2002
Messages
5
Location
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