Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 and Excel
Message
 
To
07/07/2003 04:25:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00806542
Message ID:
00850726
Views:
21
Cetin

I can't seem to close the excel file using the following code

The start of the program

With thisform.OleControl1
.Navigate2('file://c:\global\clientstats.xls')
Do While .ReadyState # 4 && Wait for ready state
EndDo
endwith

rest of program

oExcel.Application.ActiveWorkbook.Save()
With thisform.OleControl1
.Navigate2('file://c:\global\global.htm')
Do While .ReadyState # 4 && Wait for ready state
EndDo
endwith

Followed by attempt to email clientstats.xls which it can't because the emailer says flie accessed denied

Any ideas?

Thanks

Colin
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform