How do I display an excel sheet. I know everything about making changes to one but just can't google a way of opening it on screen
Set objXL = CreateObject("Excel.Application")
Set objXLWorkBook = objXL.Workbooks.Open("C:\MS.xls")
Printable View
How do I display an excel sheet. I know everything about making changes to one but just can't google a way of opening it on screen
Set objXL = CreateObject("Excel.Application")
Set objXLWorkBook = objXL.Workbooks.Open("C:\MS.xls")
Here you'll find all about what you are looking for...
http://www.vbforums.com/showthread.php?t=391665
JG
That's a great source. Thankyou!
vb Code:
objXL.visible = true