Lonnie Johnson
prodevmg at yahoo.com
Sat Apr 2 06:07:18 CST 2005
Thank you ever so much Mr McLachlan. I have never had much use of the command line switches to that degree before. You help has been exactly what I have been looking for. Is there a list or reference source that explains these switches, how to use them and the positions they play in the command line. Again thank you very much. I applaud you. Stuart McLachlan <stuart at lexacorp.com.pg> wrote: On 1 Apr 2005 at 21:05, Lonnie Johnson wrote: > Thanks Stuart, > > The Shell statement I used below was borrowed. Where do I put the -r or p? > You need the -r AND either -p or -P You put all options before the file name so: Call Shell(strAppName & " -A -r -P " & """" & strZipFile & """" & " " & """" & strFileLoc & strTargetFiles(i) & """", 1) or Call Shell(strAppName & " -A -r -p " & """" & strZipFile & """" & " " & """" & strFileLoc & strTargetFiles(i) & """", 1) The first one will store the full paths to all the files. The second one will just store relative paths based on strFileLoc. -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? Better first dates. More second dates. Yahoo! Personals