Web query with login

[ken54321]

Hi Excel Expert,

I have sucessfully found an application in which I can retreive printer counter info to excel. But now, other problems has arised:

1. This application needs the user to login before getting the info, is there a way to use marco to fill in the username & password?

2. When the number is retrieved, the format looks like this:
<Total>
Print : 45645641
I just need the number to appear, not the other stuff...is there a way to reformat it automatically as it comes in?

Thanks,
Ken

[ken54321]

plz help any1.....i am clueless

[VBA Noob]

See if link helps

http://www.business-spreadsheets.com/forum.asp?t=103

VBA Noob