Home |
Search |
Today's Posts |
#21
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
![]()
GS wrote:
Excel macros are SO... undocumented. Need a WORKING example for reading the HTML source a URL (say http://www.oil4lessllc.org/gTX.htm) Thanks. Look here... https://app.box.com/s/23yqum8auvzx17h04u4f ..for *ParseWebPages.zip*, which contains: ParseWebPages.xls NSN_5960.txt (Blank data file with fieldnames only in line1 NSN_5960_Test.txt (Results for 1st 20 pages) I did not even try cURL as the explanation was just too dern complicated. Fiddled in Excel,as it has so many different ways to do something specific. So, this is skeleton of what i have: Workbooks.Open Filename:=openFYL$ 'opens as R/O, no HD space taken then.. With Worksheets(1) ' .Copy ''do not need; saves BOOK space .SaveAs sav$ 'do not know how to close when done ' above creates the file described; that takes HD space, about 300K End With IMMEDIATELY after the "End With", a folder is created with useless metadata info; do not know how to close when done. WARNING: Scheme works only in XP and Win7. If in XP, at about 150 files,one gets a PHONY "HD is full" warning and one must exit Excel so as to be able to delete processed (and so unwanted) files. I say PHONY because the system showed NO CHANGE in HD free space, never mind those files take about 500MB. Furthermore, in Win7, these files show up in a folder the system KNOWS NOTHING ABOUT..Windows Explorer does not show C:\Documents which IS accessible; C:\<sysname\MY Documents is shown and CANNOT be accessed. Instead of the Excel program crashing, the system is shut down and locked. YET other reasons I hate Win7. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EOF Parse Text file | Excel Programming | |||
Parse a txt file and save as csv? | Excel Programming | |||
parse from txt file | Excel Programming | |||
Parse File Location | Excel Worksheet Functions | |||
REQ: Simplest way to parse (read) HTML formatted data in via Excel VBA (or VB6) | Excel Programming |