Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Now, save that xml as a html in my web_page directory...
Message
From
06/10/2005 17:21:24
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056887
Message ID:
01056979
Views:
31
SaveAs is a method of the WorkBook not of the Excel.Application

.ActiveWorkBook.SaveAs("C:\Absorb\WebPages\DMD.htm", 44)

BTW why you activate all Sheets one by one?

>>>What is the value of variable xlHTML?
>>
#DEFINE xlHtml	44	
>>You can use VFP Object Browser to open Excel type library and then drag Constants to an edit window to create the list of Excel constants. You may also find such header file on http://fox.wikis.com
>>
>>
>>>Where can I get a listing of other Methods/Procedures associated with Excel as object?
>>
>>Look for VBAXL*.CHM file in the office directory or on the office installation CD.
>ERROR
>
>
>OLE error code 0x80020006: Unknown name.
>
>      nWSF = ADIR(laFileListWS, cSpreadsheet+"\*.xls")
>      FOR ifw= 1 to nWSF
>         oExcel=CREATEOBJECT("Excel.Application")
>         With oExcel
>            .DisplayAlerts= .F.
>            IF SUBSTR(UPPER(laFileListWS [ifw,1]),1,3)="DMD"
>               .WorkBooks.Open(cSpreadsheet+"\"+laFileListWS [ifw,1],1)
>               FOR itabor = 1 to .ActiveWorkBook.WorkSheets.Count
>                  .ActiveWorkBook.WorkSheets(m.iTabor).Activate
>               ENDFOR
>               .Visible=.T.
>? "C:\Absorb\WebPages\DMD.htm"
>               .SaveAs("C:\Absorb\WebPages\DMD.htm", 44)
>               .Quit
>            ENDIF
>         EndWith
>         Release oExcel
>      ENDFOR
>
>
>Now, even Save causes an error?????????
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform