Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fill Excel range with XML?
Message
From
14/08/2004 07:29:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00849641
Message ID:
00933326
Views:
24
>Cetin, This is great! However, I am still running into one other problem. Apparently when
>I download the web page, I am only getting the html code for that page. When I try to
>do the following, I get this code "missing c:\cs\zcom.css" which I think must be some file
>asoociated with the web page, one that Excel expects to find when it open the file as below.
>This is why I though a PasteSpecial that only passed values might work cause it would
>eschew any of the photos or file links in favor of just the values.
>
>Thanks so much
>Steve
>
>mHtml = GETFILE("htm")
>oEx = Createobject('excel.application')
>With oEx
> .Visible = .T.
> .DefaultWebOptions.LoadPictures = .F.
> .Workbooks.Open(mHtml)
>Endwith

css refers to a cascading style sheet (style definitions for the htm).
1) You might make it available.
-Save that page once as html (complete) with giving a name such as myTesting.htm. Under folder where you save another folder named myTesting_files would be created. You'd find zcom.css there. Copy it to c:\css - (create folder).
2) You might fake it. Just create an empty file using notepad or VFP IDE named zcom.css (in c:\css). ie: From within IDE :
md c:\css
StrToFile('','c:\css\zcom.css')
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform