<div>
hi again,<br />
<br />
In VB design mode you should click on the <br />
Project Menu, then click Referances<br />
then scroll to Microsoft Excel 9.0 Object Library<br />
check the box and click OK.<br />
<br />
I have Office 2000 which has 9.0..<br />
You might have a different number.<br />
<br />
leo
</div>


hi again,

In VB design mode you should click on the
Project Menu, then click Referances
then scroll to Microsoft Excel 9.0 Object Library
check the box and click OK.

I have Office 2000 which has 9.0..
You might have a different number.

leo

<div>
Basically, what leojl saids is true, do you need in other way?
</div>


Basically, what leojl saids is true, do you need in other way?

<div>
hi yet again,<br />
<br />
Richie, I would appreciate seeing another approach.<br />
Perhaps more sophisticated to first check if there is<br />
a running Excel and also to deal with possible errors.<br />
<br />
leo
</div>


hi yet again,

Richie, I would appreciate seeing another approach.
Perhaps more sophisticated to first check if there is
a running Excel and also to deal with possible errors.

leo

<div>
Look at this,<br />
<br />
<a href="http://www.freevbcode.com/ShowCode.Asp?ID=1694" rel="ugc">http://www.freevbcode.com/ShowCode.Asp?ID=1694</a><br />
<br />
Narayanan
</div>


Look at this,

http://www.freevbcode.com/ShowCode.Asp?ID=1694 [http://www.freevbcode.com/ShowCode.Asp?ID=1694]

Narayanan

<div>
Thank you for this. Sorry it took so long, I am no longer on the project that needed that. 
</div>


Thank you for this. Sorry it took so long, I am no longer on the project that needed that.

<div>
<div class="content wysiwyg-content">
Is there a way to open an excel document into my app, and record a macro and save the macro like in office? I can increase the points if needed
</div>
</div>


Is there a way to open an excel document into my app, and record a macro and save the macro like in office? I can increase the points if needed

Record an excel macro within vb app

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.