I am using this line of code to get a zip file to open with winzip.
objShell.Run """C:\Progra~1\WinZip\WINZIP32.EXE"" ""I:\S3DATA~1\MEPSFLR\FLRCDR~1\BDE_Reports\" & olkAttachment.FileName & """"
& olkAttachment.FileName & """" = May.zip
if I put:
C:\Progra~1\WinZip\WINZIP32.EXE I:\S3DATA~1\MEPSFLR\FLRCDR~1\BDE_Reports\May.zip
in the run window it works perfectly.
I believe the problem is with the quotations.
ANY help would be appreciated!!!!
Thanks for any help and
Have a GREAT weekend
objShell.Run """C:\Progra~1\WinZip\WINZIP32.EXE"" ""I:\S3DATA~1\MEPSFLR\FLRCDR~1\BDE_Reports\" & olkAttachment.FileName & """"
& olkAttachment.FileName & """" = May.zip
if I put:
C:\Progra~1\WinZip\WINZIP32.EXE I:\S3DATA~1\MEPSFLR\FLRCDR~1\BDE_Reports\May.zip
in the run window it works perfectly.
I believe the problem is with the quotations.
ANY help would be appreciated!!!!
Thanks for any help and
Have a GREAT weekend