<div>
Yes you could use Run (&quot;macroname&quot;) method.
</div>


Yes you could use Run ("macroname") method.

<div>
example:<br />
application.Run &quot;test&quot;<br />

</div>


<div>
mickcoleman: <br />
This old question needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;For information on your options, please click here-&gt; <a href="http:/help/closing.jsp#1" rel="ugc">http:/help/closing.jsp#1</a>&nbsp;<br />
Experts: Post your closing recommendations! &nbsp;Who deserves points here?
</div>


mickcoleman:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 [http:/help/closing.jsp#1] 
Experts: Post your closing recommendations!  Who deserves points here?

<div>
Moderator, my recommended disposition is:<br />
<br />
&nbsp; &nbsp; Accept Richie_Simonetti's comment(s) as an answer.<br />
<br />
DanRollins -- EE database cleanup volunteer
</div>


Moderator, my recommended disposition is:

    Accept Richie_Simonetti's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm importing an Excel chart into a VB OLE box which updates as soon as I run the macro in Excel is there a way in which I can run the Excel macro from a command button on the VB screen.<br />
I'm also having trouble putting scroll bars on my form as when I import the Excel chart I can't few it all, the scroll bars I've inserted and at the sides are Ok but they don't scroll my form.<br />
Appreciate any help,<br />
Thanks Mick
</div>
</div>


Hi,
I'm importing an Excel chart into a VB OLE box which updates as soon as I run the macro in Excel is there a way in which I can run the Excel macro from a command button on the VB screen.
I'm also having trouble putting scroll bars on my form as when I import the Excel chart I can't few it all, the scroll bars I've inserted and at the sides are Ok but they don't scroll my form.
Appreciate any help,
Thanks Mick

Running an Excel VBA macro from a VB screen

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.