pause macro

Hello: I have the below macro which pulls in an excel file from the Bloomberg application. Microsoft excel does not stop processing the VBA. I need the macro to stop until the file named "grid*.xls" is opened, and then start again so I can copy and paste the data. Please advise - been stuck...

Hi, 1> I have an Excel Macro that involves copying a bunch of formulas into many cells based on an Add-in. (i.e., Copy $A$2 to $A$3:$A$100, then $A$2 to $A$101:$A$200, etc.). I have to run these sequentially as otherwise the application runs out of memory (RAM is not the issue here). 2> The...

I need to write a macro that copies everything in current sheet, (variable sheet one), pauses for user to select new sheet tab, copy the data to the selected sheet, then value the data in (variable sheet on).

Hello, I have a macro that uses the active cell to sort through data and fill the acceptable data into three new columns. I wanted to see if someone could help me create a button that prompts the user to select the active cell and then runs through my macro code. This would be very helpful in...

I want to allow users to sort a protected worksheet. Apparently, this is not possible without unprotecting. This is the workaround I think about : user launches macro (button, shortcut,...) that unprotects for, say 15 seconds. user can now sort vba reprotrects after the 15 seconds In other...

Hello All, I'm just getting started with VBA - trying to teach myself. I was lent a book by a colleague and that's helped a lot, but I have an issue for this particular project that I can figure out. I'm sure it's a bit complex for a first time project, but I wanted to tackle something that...

i want to use something like application.wait but instead of a certain amount of time. i want the macro to wait until a specific url is loaded. something like application.wait ie.locationurl = "www.google.com" but obviously not that, because i can only specify an amount of time to wait and...