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):

<pre><font color='#000000'>
<font color='#000080'>Sub</font> RunXLMacro()

<font color='#000080'>Dim</font> objXL <font color='#000080'>As</font> Excel.Application
<font color='#000080'>Dim</font> objWbk <font color='#000080'>As</font> Excel.Workbook

<font color='#000080'>Set</font> objXL = New Excel.Application

<font color='#000080'>Set</font> objWbk = objXL.Workbooks.Open("R:m-zRussellMiscExcelHelpArrayHelpAndMacroCallFromVB.xls")

objWbk.Application.Run "MacroNameHere"

objWbk.Close False
<font color='#000080'>Set</font> objWbk = Nothing

objXL.Quit
<font color='#000080'>Set</font> objXL = Nothing

<font color='#000080'>End</font> <font color='#000080'>Sub</font>

</font></pre>

-Russell

 

[srv656s]

I'll give that a try.

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

Shawn