sendkeys

  1. F

    SendKeys Method Hide Screen While executing

    Hi, I am executing a coding using sendkeys method. I wouldnt like to show the pages in the internet that I am using until the code delivers the resultant. The code below opens the google translator and write something, then it plays the audio from google translator audio play. How to hide the...
  2. D

    need to runt his macro twice for it to work

    this might be a a tricky one since not eveyrone here is famialr with ADP/Broadridge. Dim ws As Worksheet Dim tmp As Worksheet Dim acct As String Set ws = Sheets("Booking") Set tmp = ThisWorkbook.Worksheets.Add tmp.Activate On Error Resume Next...
  3. L

    My auto-save code isnt working!

    It did work...beautifully....now it just wont. I tried changing the folder it saves to, updated it on the sheet and saved, and nothing. I played with the wait times as well as my computer is on the slower side. This is my first time coding and i was surprised that everything else worked. There...
  4. R

    SendKeys and Ctrl+a problem

    If I write sendKeys "{^a}" I get "Run-time error '5': Invalid procedure or argument". But if I write sendKeys "{HOME}" it works. Any suggestions please?
  5. M

    Combobox is highlighted when loading userform... -- SendKeys ("{TAB}") --

    I have a userform that I load but the combobox is selected... I don't want the cursor blinking in my combobox when the userform is opend. I currently use sendkeys for Tab as it will move the selection to the next button which is fine. Is there a different way to code this rather than having to...
  6. C

    "Activating" a new IE window

    I have some code that runs flawlessly on my computer, but when i try it on a co-workers computer, the new IE window opens up in the background and the sendkeys lines of code dont work. Any ideas on why it works on mine but not theirs? I have searched and tried just about anything i could think...
  7. H

    Please help me close this PDF with VBA

    The below three modules work so well for pasting all the data from a PDF into Excel however, it doesn't close the PDF afterwards so I can go into another PDF in a loop. Based on the code below can somebody please show me how to close the PDF? Thanks so much friends Sub StartAdobe() Dim...
  8. rediffusion

    Context Menu

    Hi all! Found the script "VBA" which is a little tweaked to fit your needs: Sub Special_note() Dim myComm As Comment If Not ActiveCell.Comment Is Nothing Then If MsgBox("The cell already contains a note, delete?", 4) - 7 Then ActiveCell.Comment.Delete Else: Exit Sub End...
  9. M

    AppActivet for inactive webpage.

    Hi, my Webpage is not active when i run this macro, Sendkeyps UP hapens in excel, is there a way to make the web paga active, like AppActive? I cant get AppActive to work befor the sendkeys command. The funny thing is that the macro works IF i open VBA befor i run it.. Sub automatic_order()...
  10. M

    Help with Sendkey

    Hello, I'm trying to automatically enter my username and password that is prompted from a userform. I'm attempting to use the code below. It works fine without the userform present...but when the userform is the active screen, the macro stops working and is waiting for my input. Is there any...
  11. M

    Using VBA sendkeys with Vmware horizon client

    Hi, I'm trying to control keyboard with VBA using sendkeys within Vmware Horizon Client remote software. I managed to control the window of the remote software but i did not managed to write something with sendkeys . can you tell me if the function sendkeys is authorized with Vmware...
  12. gmooney

    ChartSheet Deselect VBA

    I would like a way via this VBA code to deselect the ChartSheet (Segment & Brand) WITHOUT using the SendKeys command. Private Sub SB() Application.ScreenUpdating = True Sheets("Segment & Brand").Select Application.ScreenUpdating = True End Sub Any thoughts?
  13. Nelson78

    Vba and Excel: scraping data from the web, SendKeys "^c" doesn't work

    Hello everybody. I'm struggling with scraping data from the web with sendkeys method. I'm now in a situation where, apparently SendKeys "^c" works but SendKeys "^v" has not effect. I mean: at the end of the failing macro, if I manually do ctrl+v, in sheet 3 cell A1 appears what I've copied...
  14. T

    Vba to Inport PDF Creates one Column?

    Hi Everyone, I have this code to import data from a PDF to Excel Sheet. The problem is it imports all the data as one column is there something im missing ? anyone know of a way to import from a pdf and have it look the same? here my code Sub PDFinport1() Dim wsLog As Worksheet, wsOutp...
  15. M

    Excel 2016 - VBA - Troubleshooting Macro that Should Work But Isn't Working?

    I have an Excel 2016 VBA macro that changes the "Office Theme" under: File>Account>Office Theme; to the next theme. This macro should work as when I try and perform the macro's sequence of actions manually the sequence of actions is successful in changing the "Office Theme" - would anyone might...
  16. M

    Excel VBA - Repeating Simple Actions?

    Is there a prebuilt way in Excel VBA to repeat simple actions? For example, if I want to repeat the following single action of SendKeys in the following Excel VBA macro is there a prebuilt way to do this? Sub Test1() SendKeys ("{TAB}") SendKeys ("{TAB}") SendKeys ("{TAB}") SendKeys ("{TAB}")...
  17. 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...
  18. K

    Trying to group a set of data

    Hi guys, I've been lurking around for awhile and getting answers, but I appear to be stuck on something that I can't find a solution for. I'm trying to create some groupings of rows, and I was struggling to do that, so I ended up having to resort to a SendKeys command. That's been working fine...
  19. T

    Web Query Login VBA Help

    So if I have a web query in cell A1 and run the following macro: Sub Caption() Worksheets("Sheet1").Range("A1").Select CommandBars(1).Controls("Data").Controls("Import External Data").Controls("Edit Query...").Execute End Sub It breaks the query and displays the following error...
  20. N

    Solved Linking to closed workbook with variable but created new problem with SendKeys slower than VBA

    Hello everyone, I am new to this forum. I have searched the internet everywhere looking for a solution to link to a closed workbook with no success. The only solutions i found would require installing 3rd party Add-ins which wont work, since this is a work computer, and i want to pass this file...

Some videos you may like

This Week's Hot Topics

Top