Convert a PC-Based VBA Excel Macro for Use on a Mac

1.) The attached Excel file "[url removed, login to view]" contains a macro ("DataImport").

2.) The "DataImport" macro finds .csv files in a specific PC location (C:\bookmarks) and pulls in data into columns A-G; it gets data from multiple .csv files based on text string in the file name(s).

3.) The "PC import" button on LA3import runs the DataImport macro. (try it)

The Problem:

The existing DataImport macro works on PC (Excel 2010 and up) but not on a Mac (running Office 2016).

I need some help to get a Mac version of the macro working.

The file path format for Mac is different and I think the Dir command in my VBA does not work for Mac version of Excel?

The goal is to have two buttons on the Excel sheet: one button for PC users, a different button for Mac users. Same results either way, depending on Mac/PC platform.

Successful bidder must:

1.) Create a new Excel macro ("DataImportMac") that performs exactly like the existing "DataImport" macro when run on a Mac with Excel/Office 2016 for Mac.

2.) Assign the new macro to the "Mac Import" button button on LA3import tab.

3.) Save the Excel file.

4.) Transfer the files to *YOUR OWN MAC* and confirm the new macro works on a Mac.

Quick and easy job for the right person who knows how to do this---I'm not a coder!

Excel Mac OS Microsoft Office Visual Basic

ID Proyek: #11044877

Tentang proyek