<div>
The answer given by westbrooknewmedia and myself are valid. &nbsp;This question should not be deleted and the points should not be refunded.<br />
<br />
Leon
</div>


The answer given by westbrooknewmedia and myself are valid.  This question should not be deleted and the points should not be refunded.

Leon

<div>
<div class="content wysiwyg-content">
I have a blank excel and a vba that attached to the spreadsheet. What the vba does is to populate the spreadsheet via ms query. Now I have to hit &quot;run&quot; to execute the vba to populate the spreadsheet. how can I have the vba execute as soon as someone open the spreadsheet?
</div>
</div>


I have a blank excel and a vba that attached to the spreadsheet. What the vba does is to populate the spreadsheet via ms query. Now I have to hit "run" to execute the vba to populate the spreadsheet. how can I have the vba execute as soon as someone open the spreadsheet?

automate excel

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.