Hello group; I have been searching for a way to run an external macro on an excel sheet automatically. I have found some code including this local suggestion http://www.daniweb.com/software-development/vbnet/threads/332821/run-excel-macros-with-vb.net# which looks good but I am baffled by the final instruction "just remember that you have to have an excel sheet with a macro named TheNetMacro or any other name you want to give it."
Where is this excel sheet stored so that it may be invoked just by entering its name a a parameter in a function call, as shown here? I would be most grateful for any guidance in this regard... Thanks in advance, -Patrick
patrick.weaver.161
0
Newbie Poster
Recommended Answers
Jump to PostBasically he's telling you the parameters of the sub routine. The path to the excel file and the name of the macro, in the excel sheet in that file , you want to run. Make sure you read his comment about imports in order to run his routine.
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.