MichaelFerguson
New Member
- Joined
- Jul 30, 2019
- Messages
- 3
Hello,
I'm hoping someone can help me as I've not done this before. I've written macros but never any that interact with Internet Explorer. I'm trying to automate a task that will allow the user to run the macro to copy specific text from an open browser window and paste the values into specific cells in Excel. One interesting variable is the browser window is a unique screen for every task since the users will be doing this out of a workflow system and each person will be working on an unique item with its own "URL" if that makes sense. Is there a way to have the code simply look for the active/top window and start from there?
I need the macro to fill in these fields (sorry, I can't show the source of the data as it's proprietary but anything to help get me going in the right direction would be greatly appreciated). In today's world the user has to manually locate each of the needed data elements and copy/paste into Excel. I need a macro that will allow the user to click a button and have all these fields get filled in.
Thanks!
I'm hoping someone can help me as I've not done this before. I've written macros but never any that interact with Internet Explorer. I'm trying to automate a task that will allow the user to run the macro to copy specific text from an open browser window and paste the values into specific cells in Excel. One interesting variable is the browser window is a unique screen for every task since the users will be doing this out of a workflow system and each person will be working on an unique item with its own "URL" if that makes sense. Is there a way to have the code simply look for the active/top window and start from there?
I need the macro to fill in these fields (sorry, I can't show the source of the data as it's proprietary but anything to help get me going in the right direction would be greatly appreciated). In today's world the user has to manually locate each of the needed data elements and copy/paste into Excel. I need a macro that will allow the user to click a button and have all these fields get filled in.
Thanks!