I have a question to ask in reference to Excel VBA and Internet Explorer.
I use VBA Excel at work, and now my job has created a website that allows their employees to look up info that will increase our productivity. Basically it is a online database where you can sort info and download documents.
I have been given a task to go to this website "login" and look up document numbers which will display an picture. This picture needs to be placed back into Excel as a rollover comment.
So what Is there a way that I can write VBA macro that will call out to the website, enter in my Username and Password, hit enter, find the area on the screen to paste in the document number, hit enter, the select the picture, copy it to clipboard, then insert it back into excel as a roll over comment?
I know you can open up web pages using Excel but what about positioning data in fiels outside of the normal toolbar that is in Explorer?
Thank you all!!