<div>
I'm a little fuzzy on this (it has been a while . . .) but I think it goes like this. &nbsp;Declare and instantiate a reference to an Excel object, then invoke the procedure with the .Run method:<br />
<br />
Dim objExcel as object<br />
Set objExcel = GetObject(, &quot;Excel.Application&quot;)<br />
objExcel.Run(&quot;sub as string&quot;, arg1, arg2)<br />
<br />
You need to reference the Excel library.<br />
<br />
Wes<br />
<br />

</div>


I'm a little fuzzy on this (it has been a while . . .) but I think it goes like this.  Declare and instantiate a reference to an Excel object, then invoke the procedure with the .Run method:

Dim objExcel as object
Set objExcel = GetObject(, "Excel.Application")
objExcel.Run("sub as string", arg1, arg2)

You need to reference the Excel library.

Wes



<div>
One thing as mentioned by wesleystewart, you will need to add a reference to the following:<br />
<br />
Microsoft Excel 9.0 Object Library
</div>


One thing as mentioned by wesleystewart, you will need to add a reference to the following:

Microsoft Excel 9.0 Object Library

<div>
<div class="content wysiwyg-content">
Is there a way to kick off a <br />
macro resident in a Excel 2000 spreadsheet (other than the auto ones) from a visual basic .exe?<br />
<br />
Thanks a bunch.<br />

</div>
</div>


Is there a way to kick off a 
macro resident in a Excel 2000 spreadsheet (other than the auto ones) from a visual basic .exe?

Thanks a bunch.


Exec Excel Macro from VB6

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.