Excel Vba Files Mac To Select

For a better experience, please enable JavaScript in your browser before proceeding.

Excel Vba Files Mac To Select

I want to open the Finder on a Mac to select from available Excel files.

I want to have the user select from this directory the appropriate file.

From there I will copy the first four columns into another file and continue on with the my processing.

References include Visual Basic for Applications, Microsoft Excel 14.0 Object Library, Microsoft Forms 2.0 Object Library, Microsoft Office 14.0 Object Library and Microsoft Visual Basic for Applications Extensibility 5.3.

I am using Excel for Mac 2011.

I do recall reading that Mac doesnt accept wildcards the way that Windows does.

To make ones code cross plaftom, the Application.FileSeperator adjusts to the platform.

There is a function called MacScript that seems to do the trick for me: Here is what I did.

When I wanted the user to select the folder where the file would reside I used folderPath MacScript(choose folder as string).

This would allow the user to select a folder(equivalent of a directory in windows).

I would then simply save the file with the file name folderPath filename.

When I want the user to select a file, I used filePath MacScript(choose file as string) and then workbooks.open filename:filePath.

Evidently the VBA editor had some problems in some of the other versions.

However, that can be problematic as.xlsx,.xls, and.xlsm are all different Types.

I guess the only question is one of references when you get to some of the more complex functions.

I also think you may have a problem when it comes to things like list boxes.

For the most part, I am usually working with clients in one or the other and very rarely both.

We have a great community of people providing Excel help here, but the hosting costs are enormous.

You can help keep this site running by allowing ads on MrExcel.com.

Allow Ads at MrExcel Which adblocker are you using Disable AdBlock Follow these easy steps to disable AdBlock 1)Click on the icon in the browsers toolbar.

Click on the icon in the browsers toolbar.

Click on the Pause on this site option.

Go back Disable AdBlock Plus Follow these easy steps to disable AdBlock Plus 1)Click on the icon in the browsers toolbar.

Click on the toggle to disable it for mrexcel.com.

Go back Disable uBlock Origin Follow these easy steps to disable uBlock Origin 1)Click on the icon in the browsers toolbar.

Click on the Power button.

Go back Disable uBlock Follow these easy steps to disable uBlock 1)Click on the icon in the browsers toolbar.

Excel For Mac Vba Files