Hiii All,
I am looking for a VBA macro code where we have CSV files and an empty zip file. We need to add the csv files to the zip file. The code need to work for MAC. (Able to achieve for WINDOWS) We cannot use AppleScriptTask funstion as we cannot use a different scipt file. Please suggest if there is any other alternative.
WINDOWS code that works:
Set App = CreateObject("Shell.Application")
App.Namespace(ZIPFILEPATH).CopyHere csvFileName
Bookmarks