Thanks Srinidhi for reply. Apologies but my query was how can I insert Username and password without have to insert every time manually.. ? Isn't it possible to automate this thing ? ?
Hello Experts,
WHen I tried to run below macro it throw errors , I apologies as I am newbie person in VBA, could you guys please tell me where am I going wrong here please ?
Below Code was meant for finding percentages figures and insert a min 100 percentage formula in it...
Hi All,
Is it possible to insert Username and password credentials in web query to login at website like gmail.com?
I know how to login through separate IE Object but it will be awesome if any expert here will share a little but his/her knowledge about how to insert Username and password...
Thank you Mark ,must be missing the same thing.
I am not on my desk at my desk so Apologies I could not find if your solution is right, but I am sure you are pointing at correct thing :)
The website that I was trying to download data needed a Login ,password for obvious reasons. As our code...
Hi Marc,
Your code and solution is brilliant. Many thanks for your prompt responce !
Was little worried if you could help me here, as when I added Website address , path and name of sheet to download, it gives me error as RUN TIME ERROR 13 - TYPE MISMATCH
I googled about it, but no success...
Hi Guys,
Please help. I am new to VBA macro's and want to prepare a macro which will
1. take a path from excel cell ,
2.open internet explorer , (please note here, I have hypelinks path which will download as I navigate to asked path),
3.and it will save downloaded file to specific folder...
Hi All,
Can anybody help me out here ? I want to write vba macro to Highlight out of trend figures in selected range ?
Example for - In 9000,8967,4544,2000,7800,8956 numbers 4544 and 2000 will be highlighted...