How do I open existing excel document using vb6?

[keks]

Hi

Could anyone please help me, I need to open an existing excel document using vb6. I only need to display the document.

[QVeen72]

Hi,

If only for Display, Simplest Way would be,

Place and OLE Control on the form and give options this way,

* Create New
* Object Type : Microsoft Excel Work Sheet

To Display,

Private Sub cmdShowExcl_Click()
OLE1.CreateLink "C:\MyExclSheet.xls"
End Sub

Regards
Veena

[Comatose]

http://www.daniweb.com/tutorials/tutorial51307.html
http://www.daniweb.com/tutorials/tutorial51315.html

It's for word, but the concept and idea is the same.

[QVeen72]

Hi,

In OLE Control, Insert Microsoft Word Document
Rest Remains the same

If u still have problems mail me

Regards
Veena

[jbennet]

you mean open excel and load the document

isnt there an exce command?

something like:

exec("C:\Programs\Offise\Exel\" , "C:\Docs\Spreadsheet123\)

something like this worked in VB5 , google it

[Comatose]

Shell

[QVeen72]

Hi,

Yes the code u r hunting for is,

AppActivate Shell("C:\Program Files\Microsoft Office\Office\Excel.exe C:\MySheet.xls", vbMaximizedFocus)

Regards
Veena

[Comatose]

While this method will work, it is not the best way to go about doing it.... creating an object gives your application an infinite amount of control over the excel instance, whereas shelling excel only gives you control over opening it.

[staravi39]

Hi veena

Thank you very much

Regards

Ravi

Hi,

In OLE Control, Insert Microsoft Word Document
Rest Remains the same

If u still have problems mail me

Regards
Veena