Inquisidor
New Member
- Joined
- Oct 25, 2011
- Messages
- 1
As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.
The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.
What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.
I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.
If you need more info please ask, I don't think I've been clear enough as English is my second language.
The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.
What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.
I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.
If you need more info please ask, I don't think I've been clear enough as English is my second language.
