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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top