Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
From
16/07/1999 11:44:07
 
 
To
16/07/1999 02:34:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00242078
Message ID:
00242342
Views:
20
>
uTMP = GetObject('ResulQAS12.XLS')
>oXLSApp = createobject("Excel.application")
>with oExcel
>  .workbooks.open('ResulQAS12.XLS')
>  .ActiveSheet.Range("A:D").EntireColumn.AutoFit
>  .ActiveWorkbook.Save
>  .Quit
>endwith
If columns weren't adjacent then you could use either :
>Range("A:A","F:F","P:Z") (if not coding internationally) or oExcel.Application.Union(.Range("A:A"),.range("F:F"),.range("P:Z"))
>Cetin

Hi Cetin

Thanks for the tip. I think a line of code is missing where oExcel is asigned right before the WITH.

I added:
oExcel = uTMP.Application
right before the WITH.
I removed the CreateObject command as sugested on you next message.

However the open does not work with or without full path.

Does it works for you?

Thanks and regards

Oscar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform