Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel again
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00086697
Message ID:
00086703
Views:
25
>I've created my excel workbook, done what I need to do, now I want to save it as....
>I think I've seen this here before, but I could not find it..
>
>I've tryed several variations of-
>ox=ActiveWorkbook.SaveAs FileName:="C:temp\Book1.xls", FileFormat:=xlNormal,Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,CreateBackup:=False
>
>any help
>
>TIA
>Jeff

I guess following code should work:
oExcel=createobject("Excel.Application")
oExcel.visible=.t.
oWbook=oExcel.workbooks
oWorkobject=oWbook.Add("c:\temp\upts.xls")
**** user changed some excel data
oWorkobject.Close(.t.,"c:\temp\upts1.xls",.t.)
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform