Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing XLSM format
Message
From
19/03/2010 14:03:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Importing XLSM format
Miscellaneous
Thread ID:
01455738
Message ID:
01455738
Views:
103
My workstation has Microsoft Office Excel 2003 (11.5612.5606)

I needed to import a file that was sent to us in XLSM format.

If I try to open with Excel it shows a conversion messagebox and then appears correctly on the screen.

When I try to open it via automation however.........
oxl=CREATEOBJECT("excel.application")
oXL.DisplayAlerts = .F.
oXL.Application.WorkBooks.Open(tcFile)
oxL.visible = .T.
the screen shows all sorts of crazy characters. Is there any way to force the format conversion process?

Thanks to all.........Rich
Next
Reply
Map
View

Click here to load this message in the networking platform