Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Data
Hi All,
Is there a way to get the active Internet Explorer page data with all linked pages to Excel thru VBA TIA Soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Data
You could try looking at the GetObject function. It would be possible to
get a reference to the first running instance of IE and then use the IE methods and properties to get the address of the current page. With this you could load the page using the URL instead of the filename. Once in a worksheet you can strip what you want from there. Alternatively you are going to have to look at the actual web page source HTML and parse it for links etc. This would take a bit of work. The methods I'm thinking of are quite involved so I've not posted any code etc. Perhaps others have a better idea? -- Regards, Bill Lunney www.billlunney.com "Soniya" wrote in message ... Hi All, Is there a way to get the active Internet Explorer page data with all linked pages to Excel thru VBA TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |