[OTP] VBA Shell Help

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I have a Access program and Im using VBA code in the background to run Winunzip using shell command. Well, the path of the .zip file has spaces in it and its not recongizing the path as a valid path.
Is there a another way to tackle this problem besides the shell?   I cant us pkzip either...
Has you can see I had to use progra~1 instead of Program Files
 
strZippedMI = Chr(34) & "c:progra~1winzipwzunzip -v " & "C:Documents and Settingsmsb915Local SettingsTempMI.ZIP" & Chr(34)
Shell strZippedMI, vbNormalFocus
 

View the full article
 
Back
Top