 |  |  |  |  |  |  |  |
How do I open existing excel document using vb6?
 |
Hi
Could anyone please help me, I need to open an existing excel document using vb6. I only need to display the document.
Could anyone please help me, I need to open an existing excel document using vb6. I only need to display the document.
•
•
Join Date: Nov 2006
Posts: 848
Reputation: 
Solved Threads: 120
Practically a Posting Shark
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
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
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation:
Solved Threads: 211
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.
http://www.daniweb.com/tutorials/tutorial51315.html
It's for word, but the concept and idea is the same.
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
In OLE Control, Insert Microsoft Word Document
Rest Remains the same
If u still have problems mail me
Regards
Veena
In OLE Control, Insert Microsoft Word Document
Rest Remains the same
If u still have problems mail me
Regards
Veena
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
isnt there an exce command?
something like:
exec("C:\Programs\Offise\Exel\" , "C:\Docs\Spreadsheet123\)
something like this worked in VB5 , google it
If i am helpful, please give me reputation points.
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
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
Yes the code u r hunting for is,
AppActivate Shell("C:\Program Files\Microsoft Office\Office\Excel.exe C:\MySheet.xls", vbMaximizedFocus)
Regards
Veena
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation:
Solved Threads: 211
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.
|
Similar Threads
- VB - How to open an Excel Doc w/ existing data & add data in specific cells? (VB.NET)
- Displaying an Excel document in a windows application (C#)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: help in Sql syntax in ADODB data connenction
- Next Thread: Generate VC exe from VB6.0
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
