Sunnyboy

Thanks Kevin for the information provided. It's very appreciated!

Thanks for the info. I realize it works for regular file. However the command doesent seem to work with zip files. I taught it was the same. Macro express can't seem to find my file within the zip file. Is there a way to work it out? Thanks,

Hi evryone, I've tried to look over the previous post to find a related post. My search was not successfull. So heres my issue. I'm trying to copy a file from one folder to an other one from a txt file list. My list contains a number of file I need to copy Example : (File #1) 123456789.doc (File #2) 144400012.doc The file path for each file will vary depending on the first 4 numbers of the file. (File #1) C:\Windows\1234\123456789.doc (File #2) C:\Windows\1444\144400012.doc My question now is how do i use the File command: Files/Folders >Copy File or Files with a variable such as (%T1%) in the file(s) Path Name. If it can be used with tha function, how can I do it. Thanks evryone for your help. Louis

Hello John! Thank you so much for your help. I didn't know we could use variable in every command. With the information provided I was able to complete my macro job. Thanks again and i's really a good thing that you guys (the pros) are there to give us a hand when were stuck in our macros.

Hello every one, My macro needs to do 3 things. 1. I need to open an excel CSV file in a folder. 2. I need to change the extention CSV to TXT (tab seperated value in excel). 3. I need to move the new .TXT file to an other location. 4. I need to run an existing macro with this file. Here are my issues with each steps. 1. My macro will be run on a scheduler only week days. However, the CSV files that I need to process are generated in this folder every days. That means when my macro will run on mondays i will have 3 files to process (fri, sat, sun). Here is the format for the files generated in the folder: FILENAME_YYMMDD.CSV In the Launch program command, I can't use the "*" to complete the file name I need to open. I need to write the complete path name and I can't use a variable with this command. So how can I do this? I need to process all 3 files, one after another (the oldest file 1st). 2. Is there a faster, easier and safe way to convert my Excel .CSV file into .TXT (tab separated value) instead of opening the file in Excel and Save as command? 3. I have to move my .TXT file, to an other folder. I guess I use the Move file command and here i can use "*" in the Program Path/Name field. I have no issue with this step. 4. When I run my other macro, with the new TXT file, I am ask for a file name. Can't use the "*" here again. So how would I do that? Should I rename my file to process with something standard such as: FILETOBEPROCESS.TXT and delete it at the end of each process job? Thanks so much for your help. I've been looking over the forum for quite some time now to find topics that matches my needs. Thanks again.

Good day, In often uses in my macros variables such as VARIABLE > VARIABLE SET STRING > PROMPT FOR VALUE. I would like to know if it's possible within the prompt, to force/verify that only letters or numbers are punched it? Exemple: I have an address form to fill. I will prompt a user for a value for the field "street number". My form allows only numbers. I expect the prompt for value to acept only numbers Is it possible to limit the number of caracters of the prompt value? Exemple: I have a form to fill with a comment box that can hold 80 caracters (letters & numbers). I expect the prompt for value to limit the numbers of entry. Can we force a certain number of caracters in the prompt for value? Exemple: I have a form to fill. I will prompt a user for a value for the field "YEAR". My form expect 4 digits. I expect the prompt for value to force the user to provide with 4 digits. And finaly if a field of my form to fill can hold let's say 5 caracters but any values can be set (from 0 ro 99999) can the variable be saved once the prompt is over with spaces? Exemple: PROMPT (T1) = "250" // ONCE PROCESSED IT WOULD GIVE ME A VARIABLE T1= "2 5 0 _ _" (I added spaces to ease understanding). Thanks for the help.