[AccessD] Zipping files in "subfolders" through Access

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