Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Overwrite without prompt Excel file
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00356747
Message ID:
00356753
Views:
12
>Following is sample of code used to convert excel file to HTML.
>How can I overwrite existing file without prompt to overwrite ?
>
>
>oXL = CREATEOBJECT("Excel.Application")
>oXL.WorkBooks.Open("c:\ssm\ccola13.xls")
>nFileFormat = '44'
>oXL.WorkBooks(1).SaveAs("c:\ssm\ccola13.htm",nFileFormat)
>oXL.Quit
>RELEASE oXL
>
>Thanks CB

Look at the thread marked here some people had problems about overwriting the
excel file before. Hope this helps or leads you somewhere

[Coding, syntax & commands] Excel97 SaveAs Method question Thread #188089
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform