VBA To Copy URL

[DMT Dave]

Hi Guy's is there a method to copy and save to recordset web page URLS ?

So I may have 6 active pages open with URLs on there, before I close them, can I use VBA code to go to the 1st active page, copy the URL and save to table tblMaps,



Field Date: FormatNow()
Field URL (Long text)

Hope all of this makes sense

[ranman256]

wouldnt you need to FTP the file?

[DMT Dave]

Im just looking to copy the URL and save to a table then recall it based on a date, storing routes is the aim ?

[orange]

Dave,

Review this for ideas , found via Google, but untested. There is an accompanying youtube video.

Good luck.

Update: Interesting but several unDimmed variables. Errors on Err 91 Object or With block not set ????