I thought that the "Wait>WaitTime" was not running as part of "IFFileExists" = True, but it appears once again I was wrong.

Thanks for the help.

h

I am trying to build what is a simple macro but am so far unsuccesful. My objective is to: 1 - Test for file (%Path%\Folder_n\data.csv) 2 - If file exists then a run VBS script AND wait 60 seconds before continuing 3 - If file does not exist then do nothing and move on to next If routine. //Variable...

Many thanks for the help. I THINK / hope that does it.

Regards

hip

I have modified in a small way the sample progress bar script (included below). I have 2 problems in getting this script to do what I need: 1 - Start script counter on open (i.e., remove the "Start" button). I know what part of the script to remove to get rid of the start button, but I would like to...

I am trying to find a solution to the following problem:

Of many files of many names and types in a folder find the oldest instance of a file with the string "SNAPSHOT" in the name.

Insert the file name in a command to run> program.exe OldestSNAPSHOT.exe

Thanks in advance

k

sigh....

OK, then I expect that I will have to explore a variation of the DBQuery script that mtettmar suggested; unless someone has another direction to suggest.

Wonderful ideas/support.

Thanks

hip

mtettmar, Your code works perfectly with one Excel problem; Excel refuses to completely exit at the completion of the routine. This is evident iIf I run the script "n" times there are "n" Excel.exe processes running in the XP Process Manager. This seems to be an Excel problem, and does not have anyt...

I've tried the excel example but get an error: MS VBScript runtime error:438 Object doesn't support this property or method: 'XLApp.ActiveWorkbook.ActiveSheet.Sort' Line 6, Col 0 Is it me? Is there an Excel 2k3 switch that needs to be set? One other thing, Will I be able to sort on multiple columns ...

First I do not see a sort command on the macro editor, but even if I did I suspect this problem would be too complex for me (and my little brain). I also have not found any examples in the forum. I am looking to sort various csv files that are similar but different. By different I mean that some fil...