scotsrule08
New Member
- Joined
- Jun 21, 2018
- Messages
- 45
I need to "reactivate"/focus my VBA back to IE. to continue getting data off of various pages without having to log back in to the same page.
So right now it is selecting all data on the page, copying and then pasting to a sheet in my excel workbook. I am having trouble getting send keys to go back to the IE page to continue.
Below is a sample of the code where I am struggling:
So right now it is selecting all data on the page, copying and then pasting to a sheet in my excel workbook. I am having trouble getting send keys to go back to the IE page to continue.
Below is a sample of the code where I am struggling:
Code:
objShell.SendKeys "{Enter}"
objShell.SendKeys "^a"
objShell.SendKeys "^c"
Worksheets("Extensions").Cells(1, 1).PasteSpecial xlPasteAll
