5
Contributors
8
Replies
11
Views
11 Years
Discussion Span
Last Post by staravi39
0

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

0

Hi,

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

If u still have problems mail me

Regards
Veena

0

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

0

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

0

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.

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.