Home |
Search |
Today's Posts |
#11
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
![]()
GS wrote:
I thought I'd take a look at going with a userform and MS Web Browser control for more flexible programming opts While I'm on pause waiting to consult with client on my current project... This is doable; -I have a userform with web browser, a textbox, and some buttons. The Web Browser doesn't display AddressBar/StatusBar for some reason, even though these props are set 'True'. (Initial URL (pg1) is hard-coded as a result) You navigate to parent pages using Next/Last buttons, starting with pg1 on load. Optionally, you can enter a page# in a GoTo box. The browser lets you select links, and you load its current document page source into txtViewSrc via btnViewSrc. This action also Splits() page source into vPgSrc for locating search text selected in cboSearchTxt. The cboSearchTxt_Change event auto-locates your desired lines at present, but I will have it appending them to file shortly. This file will be structured same as illustrated earlier. I think this could be fully automated after I see how the links are define in their innerHTML. For now, I'll provide a button to write found lines because it gives an opportunity to preview the data going into your file. This will happen via loading found lines into vaLinesOut() which is sized 0to3. This will make the search sequence important so the output file has its lines in the correct order (top-to-bottom in page source). I use my own file read/write procedures because they're configured for large amounts of data in 1 shot to/from dbase.txt files, and so are included in the userform class. While there's still a manual element to this, it's going to be orders of magnitude less daunting and more efficient that what you do now. It seems highly likely over time that this entire task can be fully automated just by entering the URL for pg1! Way beyond me. If in HTML one can copy an <a href="..." to the hard drive, then that is all i need. |
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 |