How to Pause an Excel VBA script without freezing excel

Hello, I wrote an application that uses a VBA object called iMacros. iMacros is a browser automation tool. My program uses iMacros to fill forms. The iMacros object launches a browser and runs its own script in the browser. While the script is ...

Message posted on the November 9th, 2011 - 6:34 PM ET

Sprint Brings Truly Unlimited Data to Samsung Galaxy S 4 on April 27

New customers switching their phone number to Sprint can get an additional $100 instant credit, reducing the price of Galaxy S 4 to $149.99 Pre-order opens on April 18 at www.sprint.com/galaxys4.

Press published on the April 17th, 2013 - 6:30 AM ET

How to populate a cell based on font color/threshold

I'm totally in the dark on this so any help would be greatly appreciated! I have a spreadsheet that lists my call center staff in one column and their associated pause and login state times in other columns within the same row. I have conditional ...

Message posted on the May 26th, 2009 - 4:31 PM ET

Keyboard & Excel

This is really a keyboard issue but it only seems to do this in Excel so here it goes. I have an older Microsoft keyboard the model is Microsoft Internet Keyboard Pro. I do not have the documentation. Over the traditional Print Screen, Scroll ...

Message posted on the January 31st, 2009 - 10:46 PM ET

How to pause a macro to allow user to select cell

I am learning to do Macros in Excel and I am unable to figure this problem out. I am using Excel 2003. I have two spreadsheets in the same workbook. One is named Working the other is Existing. I would like to create a macro that allows the user to ...

Message posted on the June 12th, 2009 - 12:17 PM ET

Re: OnTime LatestTime Use

Hi all, Am using Excel 2010. I am trying to run a macro on just one day only, anytime throughout the day starting from 09:30 onwards. But not run it if the day has changed. I have the following code in the Workbook_Open section: RunTimeFirst = ...

Message posted on the December 10th, 2012 - 7:42 PM ET

Programatically open Access DB with user level security

I have an Excel Add-in that now needs to open an Access database that has user level security applied to it. The only way I have been able to achieve this so far is using the VBA Shell function, since by doing this I can pass the workgroup path and ...

Message posted on the March 3rd, 2010 - 1:01 AM ET

Macro for Mail Merge Error

Hi, I have made an Excel file in 2007 which sends data to a Word file via mail merge and everything works fine. This is the code: - Sub JobCardMerge() ' ' JobCardMerge Macro 'Open Word and run the mail merge MsgBox "When prompted, please ...

Message posted on the June 29th, 2010 - 12:03 PM ET

Problems looping though XL files...then each sheet in each XL file.

Hello all, I've developed packages that loop through all Excel files in a folder, then through all sheets in each file, without too much trouble in the past. With each package I create: - I prompt user to select one file in a folder to get the ...

Message posted on the September 4th, 2009 - 2:39 PM ET

pausing code until button in form is pressed

I'm working on an access program where the user can choose multiple excel files to get imported. My code takes the excel data then loads it into a temporary table where it will be checked to make sure critical fields follow a standard format. If ...

Message posted on the January 12th, 2009 - 7:17 PM ET

Lotus ? command

How can you do an Excel macro to pause like the old Lotus {?} ? Val

Message posted on the June 23rd, 2009 - 2:02 PM ET

Keyboard help please

This is a long shot but I'll try. I have an older Microsoft keyboard the model is Microsoft Internet Keyboard Pro. I do not have the documentation. Over the traditional Print Screen, Scroll Lock, and Pause buttons are 3 lights. The 1st is for the ...

Message posted on the January 31st, 2009 - 10:44 PM ET

how pause excel