nuffcedd

BINGO! Thanks!

My macro launches a program (Bat. file) that is taking anywhere from 1 to 5 minutes to run. That program finishes by overriding an existing excel file with new data in a folder (report.xls). Then the macro places today’s date in a variable. Then the macro is SUPPOSE to copy the excel file (that has just been overridden) in the same folder with the date variable (report.date.xls). After macro runs, there should be two excel spreadsheets (report.xls and report.date.xls) with same data. The end result I am getting is the file that is overridden each day, (report.xls) is correct but (report.date.xls) is always the data before the override. My best guess is the bat. File is still running and my macro is proceeding to the next step. If that is the case, is there a way to keep the macro from proceeding until the Launch program step is complete? I could use the Delay command but the amount of data I am dealing with is constantly increasing, and what is 5 minutes today may be 10 minutes in 6 months. Any suggestions would be greatly appreciated.

Thank you both Cory sorry about the confusion, I was not trying to run them simultaneously, but I see how my poorly worded post would imly that. Kevin changing from equals to contains WORKED. I'm in business now!

Thanks Cory. Why is there an option on the Muliple Choice Menu to select checkbox menu, where you can then make more than one choice. In the sample macro (copied below) it even implies that you can run more then one. Thanks again. EA // =========================================================================== // Sample Macro - Menu of Sample Macros // ---------------------------------------------------------------------------------------------------------------------------------- // // What it does: // This macro will display a menu of the sample macros and allow you to select which one(s) // to run. // // To incorporate a similar feature in your macros, use the Scripting Editor to study how this // macro works and change it as needed. // // Variables used: // T98 - Multiple Choice Menu selection // T99 - DONE flag // Variables used by the called macros // // Written by: // Insight Software Solutions, Inc.

I'm trying to build a multiple choice macro where the choices (A through ....) run other macros. My problem is I cannot get my macro to run more than one of the multiple choice options. I can celect multiple choices but macro only works if I have just one selected. I did change from radio button to check box) I am using the example "Menu of Sample Macros" as my template.

That did it. Thanks a bunch!!!

Here is a snipit of my macro - No laughing, I know it doesn't work Clear All Variables: All If File Exists "ACH Unathorized CCDs.csv" Variable Set From File Date/Time Delay 250 Milliseconds Copy File or Files: "Unathorized CCDs.pdf" Delay 1 Seconds Copy File or Files: "Unathorized CCDs.pdf" Delay 1 Seconds Delete File or Files: "Unathorized CCDs.pdf" Else Clear All Variables: All If File Exists "Five Star Credits.pdf" Variable Set From File Date/Time Delay 250 Milliseconds Copy File or Files: "Five Star Credits.pdf" Delay 1 Seconds Copy File or Files: "Five Star Credits.pdf" Delay 1 Seconds Delete File or Files: "Five Star Credits.pdf" Else End If End If

Yes!, and say using your example, file "aaa111111.pdf" does not exist but I need the macro to continue with "QQtoday" opposed to ending.

First thanks for all the great information I've recieved from these forums. My situation is this, I have multilpe filesthat need to be manipulated every day. Some need to be renamed and moved to folder "A" while another may need to be moved to Folder "B" with no name change then yet another file may need to be to be copied to folder"A" and "B". I've built one macro that looks for the first file, does what it needs to do with it, then looks for the next file and so on. My problem is there may be times that a file may not be there and this is causeing the macro to error out and quit. Is there some way to run a macro that can perform in "steps". Recognize if a "step" is performable, if so complete it and continue, if not, skip it and still continue. I thought the If file Exits or If file does not exist were my answer but I have not been able to get the macro to continue either way.