savethisid
New Member
- Joined
- Sep 1, 2007
- Messages
- 6
Hi,
I'm not an expert in excel, however I do feel that Excel can do the stuff, that I'm talking about in my below problem
I need the following to done with the help of VBA.
a) Click on a link provided in excel and open a webpage.
b) Wait for IE to open and then click on a specific location and click on it. *Note only mouse cursor works to click on the button.
c) Once the button is clicked copy the content below (top to bottom) and paste the same in excel.
Is there anyway this could be one. The challenge I'm facing is how does the macro know which part of the screen or button needs to be clicked .
If you can please do help
Best Regards
I'm not an expert in excel, however I do feel that Excel can do the stuff, that I'm talking about in my below problem
I need the following to done with the help of VBA.
a) Click on a link provided in excel and open a webpage.
b) Wait for IE to open and then click on a specific location and click on it. *Note only mouse cursor works to click on the button.
c) Once the button is clicked copy the content below (top to bottom) and paste the same in excel.
Is there anyway this could be one. The challenge I'm facing is how does the macro know which part of the screen or button needs to be clicked .
If you can please do help
Best Regards
Last edited:
