Is there a simpler way?
I'm hoping there is a simple downloadable tool that will do this for me.
I have a spreadsheet that needs updating from a number of different web pages. To complicate things further, some of these websites need a password.
Is there a way I can put together a macro that will just record the steps I carry out on a routine basis and duplicate .
I'm no VB expert so I don't want to go down that road and also I don't see how the "web query" functionality in excel will help except maybe where the info is in a tabular format and where no passwords are required.
Anyone understand what I'm getting at.