VBA on mac coding

The below code opens dialog box let you select files and folders and zips them. I want to run that code on Excel 2016 for mac

set BatchFolder to choose folder

tell application "Finder"

set theDestination to container of BatchFolder

tell (POSIX path of BatchFolder) to set {theSource, theDestination} to {it, (its text 1 thru -2) - Grammar & ".zip"}

do shell script ("/usr/bin/ditto -c -k " & quoted form of theSource & " " & quoted form of theDestination)

end tell

Skills: C++ Programming, Excel, Software Architecture, Visual Basic, Visual Basic for Apps

See more: vba excel mac 2011 tutorial, vba excel mac 2016 tutorial, how to open vba in excel mac, macros in excel for mac 2011, vba editor mac shortcut, does vba work on mac, how to open vba in excel 2016 mac, create userform excel 2016 mac, vba mac install, vba mac excel, vba mac excel 2011, word vba mac, vba mac list files folder, plugin vba mac, numbers vba mac, vba mac database, vba mac word, vba mac numbers, mac coding widgets, vba mac plugin

About the Employer:
( 3 reviews ) Istanbul, Turkey

Project ID: #17241867

Awarded to:

$30 USD in 1 day
(0 Reviews)

3 freelancers are bidding on average $30 for this job


HI there! I have a large experience in Excel, MACROS, and VBA I have all tools and tricks, I assure you, you will be more than satisfied with our work Can you please share more description and file? We are ready to More

$35 USD in 0 days
(14 Reviews)

Hey, I'm interested in your project. Please send me a message so t More

$25 USD in 1 day
(1 Review)