sendkeys in excel

  1. S

    SendKeys paste to excel then reactivate Internet Explorer to continue

    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...
  2. M

    Sendkeys not working Alternative code?

    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...
    • mpezzuto
    • Thread
    • alternative code refresh sendkeys sendkeys in excel
    • Replies: 1
    • Forum: Excel Questions
  3. R

    SendKeys to force enter a cell to update format - starts printing instead

    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...
  4. S

    Simulate "F2" and "Enter" with a macro triggered on a Slicer in a different work sheet

    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...
  5. J

    Sending commands to another non Office/Microsoft application using VBA in Excel 2007

    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...
  6. B

    Send enter key to open IE page via Excel VBA

    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!
  7. P

    Sending Tab command to excel sheet.

    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...

Watch MrExcel Video

Stacked & Clustered - 1091 - Learn Excel Podcast

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top