Ted at Miles

I noticed your posting. I want auto it to read one cell from an excel file, the worksheet is open when I run the autoit script. It is a cell that contains a date. I have a good autoit script that goes into our hospital software at Miles and pulls a bunch of reports for me, then it continues by running a macro in excel to open all the downloads. How do I get autoit to take the date I want from the cell in excel? It is cell C1. Right now I have to put in the date while the script is runnign thru a dialogue box that pops up. ted ttrebilcock@mileshealthcare.org

How do I get a script to save the last line # of all the script code into a variable? For example, the first line of a 1,000 line script puts up a message, "There are 1,000 lines of code to run" Or to allow the use of the actual # of lines as a progress bar control.

Why not use a free program, like Adobe Photoshop that comes with Epson scanners? It has a BATCH SAVE function. You can pick up a folder, and re-save its contents, rename names with a numbering system and pick the file size and density. Real easy. I have used mouseclicks a few times and ran into trouble, I would recommend using some sort of file path command instead. Good luck. I love seeing posts like this. People that are really into it and obviously learning.

I have messed with the line count command. Does not work most of the time. It is supposed to work for server logs from what I have heard. good luck

I have an autoit script that is pulling data off a large billing system. After a report compiles in the billing system (started by AUTOIT oc course) it saves the file. After the save is done I want autoit to then continue. How do I make it pause while a DOS window is compiling? Is there a way to do it using explore folders and files? The place it needs to pause is at the end of this script,. Before is copies the file to the C drive. I have to run this script about 150 times, and would like to find a way to make it pause only until the file is saved. The time is takes varies a great deal. One prov might take 2 minutes, another might take 45 minutes. GET_P011_AGINGS_ALL_LOCATIONS_ALL.au3