Could use a little help!

[sventura]

I hope this isn't a silly question... I am currently working on a secured web site. The host does not provide the statistics the customer is requesting. So, I've been asked to figure out a way to produce this information. I am currently copying and pasting the information, one at a time! I am going crazy to say the least, there are 1000's of records. Is it possible to create a macro in excel that will do a task on a secured website?

Thanks for your help!
Sue

 

[schielrn]

Welcome to the Board!

It is not a silly question, but definitely not a small task.

You can automate a macro to pull data in using the web query option and I believe it will work with secure sites as well as I believe there is an option to save the password.

Are all these records in one table?

Have a look in the Data section and the part that is get external data and look at from Web.

You can record this macro as well, or it can be set to refresh every so often or you can refresh it manually.

But again this is not a simple task at all IMO.

You can also use macros to navigate to web pages and input passwords and usernames and such.

Then depending on how the data is laid our you might be able to copy it from the screen that way as well.

So long story short, sorry, it could be possible as I have used this for other sites.