how to add a macro
Hi, all:
Could you tell me how to insert a macro to excel externally, i.e. from an
external language that uses automation from Excel?
I need to run the macro from inside Excel, rather than the External language.
So, from the external language (vb6 or .net) I would call the Application
object and run the macro, which is in Excel.
For instance, I want to have the folowing code inside Excel:
Sub Auto_open()
... Some Code
End Sub
How can I Include it before Excel opens?
Thank you,
Rick.
|