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