wait

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

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

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

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?

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

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

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

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

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

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

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

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

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

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