View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie in hell newbie in hell is offline
external usenet poster
 
Posts: 5
Default 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.