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...
I am trying to refresh and factset excel template with vba, I am trying to use sendkeys to use the hot keys that will kick off the refresh.
The code I am using is this
Application.SendKeys ("%srw")
which works by itself but not with other code. ( I am cycling through portfolios and getting...
Hi All,
I have come upon an issue regarding the SendKeys feature in VBA. i have used this before with succes but for some reason i cannot figure out whats the problem.
I want the code below to enter each cell within a range by sending the keys F2 and ENTER. It will not work... It keeps...
Hi Guys,
I am trying to simulate "F2" and "Enter" SendKeys event, on a specific cell "C1" in a specific Sheet "Past Login", which has 2 Pivots from a data source in a different workbook.
I have a Slicer pulling data from another data source in the same workbook. This slicer has dates and i...
Thank you for the great forum to ask questions and get answers. I have used it many times to help out with Excel problems.
I am trying to write VBA code in Excel 2007 to open (I have that part figured out) and then access the Tools menu, enter and start a data acquisition by “clicking” the...
Send enter key to open Internet Explorer page via Excel VBA
I am trying to click a webpage input box and use a Send key enter. I can select the Input box, but can not make it Send(Enter). Thanks!
Hi,
I am trying to do something like a user first selects a range in a excel sheet. Then he hits the TAB key which makes the cursor to move within the selected range. I want this to be done by a macro once the user has triggered it after selecting a range.
Each time a macro sends a TAB command...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.