application.wait

  1. F

    VBA Fill in multiple PDF Files

    I have a code to fill in multiple PDF files from data in an excel sheet. It gets data from the first row and fills in the pdf and saves it. Then I need it to go to each line and fill in a new pdf and save it. When it creates the first pdf and saves it, a preview of the pdf comes up. Then the...
  2. Z

    Extracting YouTube views online using getElementsByClassName in VBA

    Hi there. My code is running and generating the necessary timestamps to viewership data from a YouTube link, however I can't seem to get the viewership to copy and print. Any help to extract this information from the YouTube code would be much appreciated. Thanks Here is a link as an example...
  3. K

    VBA Help

    Can anyone help with the below code. I keep getting an error of "This will cancel a pending data refresh. Continue?" even though all the tables have updated and then when the save happens I am getting a box to ask if I want to save changes. I thought what I had below would just save the...
  4. S

    Cant Save Downloaded File to Chosen Location

    i have the following code below..im trying to auto download a file from web then save it to a specific location..however the last part of my code doesnt work.. i highlighted it in RED. thanks. Sub Downloadfile() Dim ie As Object Dim TempFileName As String Dim ProfileID As String...
  5. W

    Run Time Error '1004': method 'sendkeys' of object '_application' failed

    hello all, New to this, found a random tutorial online, tried to alter it do it be useful to me. Im getting error mentioned in title. Please advise Option Explicit Sub PDFTemplate() Dim PDffldr As FileDialog Set PDffldr = Application.FileDialog(msoFileDialogFilePicker) With PDffldr...
  6. T

    Simpler Macro required

    Afternoon All, I have the following Macro for the sample Table below. I would like the Macro to loop until it reaches the end of the table, at the moment i have the shortcut entered at the end but this requires me to be infront of the computer at all times to end the macro by pressing ESC...
  7. 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...
  8. E

    VBA to google search based on cell value

    Hello, I am having trouble coming up with a macro that searches google based on a cell value, then returns the Google review score. I tried modifying the below code to suit my needs but keep getting a Run-time error 91 Object variable or With block variable not set. Any help would be greatly...
  9. B

    Vba subscript out of range

    Hello everyone, I try to figure out how to get a value (id) from a website url. I've created a table with 2 columns, name and id. I've filled the name column (95 rows) and try to get the id from the website url. The code below does function (i'm sure it could be done better, but i don't have...
  10. A

    VBA Code stuck in a loop

    Hi, Im using this code below but im stuck in the loop until i press ESC. Can someone help me write into this code that it stops when ESC is pressed Sub rrrr() Do button24hr Application.Wait Now + TimeSerial(0, 0, 5) BUTTONNOW Application.Wait Now + TimeSerial(0, 0, 5)...
  11. 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...
  12. R

    Is there a VBA error message that allows code to continue executing?

    I'm creating an automated sheet for a rather rude colleague and as a bit of fun I've made it so if she types an incorrect value in a table, the table then flashes red and blue like police lights, I want to have a pop-up box that informs her the value is incorrect but the issue is this interrupts...
  13. 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...
  14. P

    Simpler loop

    Hi All and HNY2019 Is there simpler and cleaner way to code this to make the Status Bar appear to flash? Sub StatusFlash() Do Until c > 5 Application.StatusBar = "Setting up - " Application.Wait (Now + TimeValue("00:00:1")) Application.StatusBar = "Setting up -...
  15. M

    Blank duplicate still open when open and close workbook with VBA

    Hello, I am really going to do my best to explain this problem I am having, Also I have searched this site and others found nothing but maybe I am searching with the wrong terms. I have a main workbook that uses several other workbooks to save/archive information, several of the operations...
  16. C

    Login to websites from Excel spreadsheet

    On my Excel spreadsheet: web address is in B, username in C, password in D, UN ID in E, PW ID in F, Button ID in G, land page (to go to after logged in) in H. Right click triggers below macro for that particular row. Succeeds in opening address in B, however not seeing log in credentials being...
  17. A

    Shell not working

    Am I doing it correctly ? x = Shell("D:\A-Sides\doit.bat", vbNormalFocus) 'wait for bat to finish Application.Wait (Now + TimeValue("0:00:10")) The wait is working but Doit.bat doesn't run. Is something else needed?
  18. A

    VBA Loop

    Hi all, can anyone help with the below? I can't get it to repeat the code but I don't know why. 'START LOOP HERE Do Until Sheets("Sheet1").Range("A4").Value = "" Set mytextfield = IE.document.all.Item("txtJobNo") mytextfield.Value = Sheets("Sheet1").Range("A4").Value 'Next 'Press submit...
  19. 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...
  20. R

    Read Closed Workbook

    I am trying to read cell A1:A1500 on closed workbook C:\TimeCards\CivlianAlphaRoster.xls for loop info on open workbook to save as filename. I have tried for 3 days with no results. Can someone help to see what I may be doing wrong? Mega thanks for any help. Short VBA is below. Sub...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top