visual Basic and excel

[srv656s]

I posted something on this yesterday, and today the entire forum (Macro forum??) is gone... hmm.....

Well, someone had mentioned that to run an Excel macro from Visual basic I would have to create an 'object'? In visual basic. I was hoping someone could give me a little help on this or perhaps another way of running an excel macro from a visual basic program I'm writing.

Thank you very much for any help.

Shawn

[Russell Hauf]

Try something like this (hope it helps):

Sub RunXLMacro() 



    Dim objXL As Excel.Application 

    Dim objWbk As Excel.Workbook 

    

    Set objXL = New Excel.Application 

    

    Set objWbk = objXL.Workbooks.Open("R:m-zRussellMiscExcelHelpArrayHelpAndMacroCallFromVB.xls") 

    

    objWbk.Application.Run "MacroNameHere" 

    

    objWbk.Close False 

    Set objWbk = Nothing 

    

    objXL.Quit 

    Set objXL = Nothing 



End Sub 

-Russell

[srv656s]

I'll give that a try.

Thanks, I'll let you guys know how it works.

Shawn