wait

  1. B

    Vba code to wait until query & calculations are complete before proceeding

    I am looking for VBA code sample for the following situation.... My excel code currently does a REFRESH ALL DATA. At which point in the lower left is displayed the message, "RUNNING BACKGROUND QUERY ... (CLICK HERE TO CANCEL)". Also later at times when I refresh, I get a message...
  2. S

    Wait for input from user in Windows Dialog Box

    Hello all, I have created a spreadsheet that takes information exported from another program and prints out different worksheets based on the information from the export. I use this spreadsheet multiple times a day and am looking to make a short key to bypass the steps required in actually...
  3. K

    Wait until user navigates away from current internet explorer webpage THEN run VBA code

    Hello, I have a piece of code that opens a webpage in internet explorer. I then want the next section of the code (just picks information off the webpage referring to specific elements) to run only when 'the user' types in a search and navigates to the search results page. The program would...
  4. B

    Set Macro to Wait/Pause

    I used to have a macro show a picture in the middle of the code and then continue. The code I can't remember is how to put in a pause for a given time period. Any help?
  5. A

    Shell wait and sendkeys

    I need to 1. launch cygwin from VBA, 2. run an executable with inputs and 3. wait for it to finish. I have had success doing steps 1 and 2 OR steps 1 and 3, but cannot figure out all 3. For steps 1 and 2: ReturnValue = Shell("C:\cygwin\Cygwin.bat", 1) SendKeys "S{ENTER}" (this is only one...
  6. D

    Wait for Calculations to Complete

    Hi everyone, I have an interesting problem. I thought Excel would not advance to the next line of the VBA code until all calculations were complete (assuming automatic calculations are turned on). However, that doesn't seem to be the case. So, I tried to add a while loop to allow it to run ALL...
  7. D

    Wait for Cube Values to return data before continuing macro

    Hi All, I've been trying to find a way to have my macro wait until after my data has refreshed to continue. I'm using Excel 2010. I have combined our Sales Cube & Stock Cube into a PivotTable and then converted the PT into formulas. I need to do this so that I can minimize the amount of data...
  8. P

    Excel VBA Refresh Wait

    I am trying to create a button with a macro code. When the button is pressed it will run a refresh code for a webpage. One of the sheets is updated with the information from this website. There is a waiting period for the refreshing. When done refreshing the rest of the code is run. My problem...
  9. D

    AppActivate Works Only Half the Time

    So I've created an Excel workbook to start and stop an external stopwatch and automatically copy the time to Excel, and everything works perfectly except the Stop function. Half the time it activates and the other half it doesn't. I used the ALT+TAB VBA SendKeys command which works fine, but...
  10. B

    Start Process, Wait Until Finished, Resume

    I'm having some trouble with a workbook that I've set to only calculate when the user clicks a button to force a total calculation with an Application.CalculateFullRebuild line. The trouble is *I think* that the code continues to progress while the sheet is rebuilding/recalculating, so it's...
  11. C

    Wait for links- function update

    Hello Everyone, I am having a problem with the updating of functions in my code: my code: Public MyDate Public MyExDate Public MyNewDate Public Period As String Public ExPeriod As String Public sht As Worksheet Public MyPath Public Index As Integer Public IndexValue As String Public...
  12. K

    How to make macro wait on file?

    Hello This is my first post, so be nice;) My problem is, that I need a macro in Excel to wait untill my work file is writable again. Because there is a another user, using the file. Macro: When the user has closed the file down, my macro continue. Or give notice of that file is busy Is...
  13. J

    Stop macro until calculations complete?

    Hello - I'm working on a fair sized spreadsheet which needs to execute a few api calls to retrieve data, then compare that retrieved data to similar points from another source. What I'd like to do, if possible, is prevent the macro from proceeding with the next formula on the sheet until the...
  14. M

    Delay for SendKeys, TsTom?

    Hi! I am using Sendkeys for Hyperion Planning Excel Add-In User Interface in order to automate retrieving data from the database. Sometimes the UI is too slow and I'd need a little pause between Sendkeys commands. The most helpful solution was provided by TsTom year 2003 in this Forum, see...

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
Back
Top