waiting

Hello all, My code is working as intended. There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the code is running in the background. I cannot figure out how to call it from VBA to appear as this...

I am reading a bunch of text files in a folder through loop. Using possibly a command button, how can i halt the loop half way instead of waiting for it to complete before i can do some other things.

I need to know if there's a more efficient way of uploading data to my list on Sharepoint. I have a worksheet with an average of 100 rows and 106 columns, making a total of approximately 9,900 cells. This is my current process to upload: I go to my list on Sharepoint, viewing it in edit mode...

hello everyone, I have a question regarding vba if I move a data from file a to file b when pressing f8 the process repeats thus in file b there will be a duplication what can I do to remove duplication using the vba of file a waiting for a reply asap thank you

Hello, I am trying to complete the situation stated above. I need a waiting day results. There are 4 related columns. 1:process column(selecting from drop down list). 2:process last update date. 3:today's date. 4:waiting time result. 1,3 and 4 is okay. But I need help on second column. When...

if any row in column J that = ATO then I need every row in column O to populate "Automated". Also if any row in column J = PRD and any row in column L = "waiting" then I need every row in column O that satisfies both criteria to = "Manual".

Hi I have a problem. I have 2 sets of data. The first set contains movie times This is calculated by subtracting the current time from the previous rows time. The second set of data are instances that are described as waiting time. an instance of waiting time should fall between a move time...

Hi all, I have a table of customer who are awaiting or have had a procedure in a table like this: <tbody> Customer ID Procedure Request Date Completion Date 0001 Echo 2018-04-02 2018-05-05 0002 Echo 2018-05-06 2018-05-27 0003 TILT 2018-05-07 2018-05-20 0004 Echo 2018-05-19 </tbody>...

Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...

Guys, good afternoon! when you log in via vba excel on the page, you open a form in .asp, the macro does not continue, it stops waiting for the form to close. I need the macro to continue ... Can you help me?</pre>

Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...

I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking n people per year to join. However, we don't want this done on a first-come-first-served basis, nor do we want an entirely randomised selection, rather a combination of...

Hi, I'm sorry for the title being so vague, but i quickly need to run some numbers and the source data is a bit messy. The simplest way for me to do this with my limited knowledge is an IF statement, but i think it's going to be very messy in terms of nested IFs to do what i need, so i wonder...

Hi all, I was using a macro attached to a button to filter rows based on the colour of a cell (determined by conditional formatting). The code was: ----------------- Sub Due() ' ' Due Macro ' ' ActiveSheet.Range("$B$1:$Z$5997").AutoFilter Field:=10, Criteria1:=RGB(218, _ 150...

Hi All, I need help for the below: A1 A2 A3 0 0 display "blank" 17-Nov-17 0 display "waiting" 17-Nov-17 16-Nov-17 display "done" Thank you!

Hello, I have a file structure like: a main folder\many sub folders\excel files. What i need to do is to loop through all sub folders and if a sub folder name has "waiting" as part of its name, then open all excel files in it. can someone please help me with this line of code, the underlined...

I have a macro that iterates through several rows, sending cell values to another program (MathCAD). The other program processes that input, and then excel gets results back from the other program and inserts them into the worksheet. This had been working fine for some small test batches (100...

Hi- So I'm using VBA to complete a form in Internet Explorer. Within the form, I enter text in one box(Store Number), then text in another(Qty per Store), then I click a button. The problem is the image is clicked before the text is entered, so I get an error telling me to enter a "Store...