PDA

View Full Version : Non Excel Application Status



gsmcconville
02-07-2012, 02:47 PM
Hello, does anyone know of a way to check the status of an application through VBA?

I have been using the SendKeys function for years in one of my spreadsheets, but would love to add a feature that waits for the application to be available rather than waiting for a few seconds before sending the next set of keys.

What I am using this for is to send data from a spreadsheet to a Point of Sale program to create credit claims etc.

Thanks

Grant McConville

Kenneth Hobs
02-07-2012, 03:37 PM
www.cpearson.com/Excel/ShellAndWait.aspx