Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Working with Files and Folders (Mac)

Problems with Apple’s sandbox requirements and Mac Office 2016 with VBA code

Get path of Special folder

Check if File or Directory Exists

Check if Disk exist

Make Directory if it not exist

Copy Folder in Microsoft Office for the Mac with VBA

Use VBA Kill to delete files

Use VBA to Delete all files in folder

Loop through Files in Folder on a Mac (Dir for Mac Excel)

Merge Excel workbooks on a Mac

Create a summary worksheet from different workbooks(formula links created with macro)

Select files on a Mac (GetOpenFilename)

GetSaveAsFileName on a Mac

Select Folder with VBA/Macscript in Mac Office

Count files in folder

Show hidden Files and folders on Mac

SaveAs and FileFormat numbers

Make folder in the Office folder in Office 2016 and create shortcut on the Desktop with VBA