<div>
Try &quot;Shell&quot; command. you need to activate &quot;.exe&quot; file first, then open your excel file from VB. The syntax should look like &quot;Shell(&quot;c:\excel.exe&quot;,&quot;c:\<wbr />excle.xls&quot;<wbr />). <br />
Also you can try &quot;GetObject&quot; or try to use active X control. <br />
<br />

</div>


Try "Shell" command. you need to activate ".exe" file first, then open your excel file from VB. The syntax should look like "Shell("c:\excel.exe","c:\excle.xls").
Also you can try "GetObject" or try to use active X control.



<div>
qizhizhu,<br />
<br />
It is not the answer I had in mind. I am looking for the syntax for OLE automation with Excel such as:<br />
<br />
Set obj= CreateObject(&quot;excel.APPLIC<wbr />ATION.8&quot;)<br />
obj.Workbooks.Open (excelfile)<br />
.<br />
.<br />
<br />
Regards<br />
Baltaz13<br />

</div>


qizhizhu,

It is not the answer I had in mind. I am looking for the syntax for OLE automation with Excel such as:

Set obj= CreateObject("excel.APPLICATION.8")
obj.Workbooks.Open (excelfile)
.
.

Regards
Baltaz13


<div>
Yronnen,<br />
<br />
It worked fine,<br />
Thanks for your help!<br />
<br />
<br />
Baltaz13<br />

</div>


Yronnen,

It worked fine,
Thanks for your help!


Baltaz13


<div>
<div class="content wysiwyg-content">
I am trying to do the following using excel OLE objects in VB:<br />
<br />
* Open &nbsp;a specific filename in excel from VB<br />
* Open the file in readonly mode<br />
* make excel with the workbook the active window<br />
* make excel open maximised<br />
<br />
I am sure there is an easy answer, but could not find the correct syntax do it<br />
<br />
I would appreciate some help<br />
<br />
Regards<br />
Baltaz13
</div>
</div>


I am trying to do the following using excel OLE objects in VB:

* Open  a specific filename in excel from VB
* Open the file in readonly mode
* make excel with the workbook the active window
* make excel open maximised

I am sure there is an easy answer, but could not find the correct syntax do it

I would appreciate some help

Regards
Baltaz13

VB &amp; 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.

VB &amp; Excel

VB & Excel