_MARTIN_....Help!
Monday, January 31, 2005 by crashdau | Discussion: DesktopX
Hey Martin! I've been trying to following your example with the iTunes Object and it has helped me get closer to my goal (DesktopX doesn't crash immediately). Thank you. But, now I'm stuck. I've used the following code to get a excel file object using the MS Office Spreadsheet ActiveX control onto my desktop but it does actually display the excel file in question. Could you help me to improve it? Here isthe code that works:
Dim excelApp
'Called when the script is executed
Sub Object_OnScriptEnter
Set excelApp = CreateObject("Excel.Application")
excelApp.Workbooks.Open("C:\My Documents\Spare_Brain My Documents\DIPRC.XLS")
End Sub
When I change the following line, "excelApp.Workbooks.Open" to the one below it crashes:
Control.ActiveWorkbooks = excelApp.Workbooks.Open("C:\My Documents\Spare_Brain My Documents\DIPRC.XLS")
Any help would be appreciated.
Thanks,
Scott
Dim excelApp
'Called when the script is executed
Sub Object_OnScriptEnter
Set excelApp = CreateObject("Excel.Application")
excelApp.Workbooks.Open("C:\My Documents\Spare_Brain My Documents\DIPRC.XLS")
End Sub
When I change the following line, "excelApp.Workbooks.Open" to the one below it crashes:
Control.ActiveWorkbooks = excelApp.Workbooks.Open("C:\My Documents\Spare_Brain My Documents\DIPRC.XLS")
Any help would be appreciated.
Thanks,
Scott
Please login to comment and/or vote for this skin.
Welcome Guest! Please take the time to register with us.
There are many great features available to you once you register, including:
- Richer content, access to many features that are disabled for guests like commenting on the forums and downloading skins.
- Access to a great community, with a massive database of many, many areas of interest.
- Access to contests & subscription offers like exclusive emails.
- It's simple, and FREE!