Convert VBA from PC Excel to Mac 2011 Excel

[jaimelwilson]

I have a VBA code which I wrote that works fine on my PC, but the person I wrote it for uses a Mac and says he is getting errors.
I know there are slight differences in the coding and was wondering if anyone could help me rewrite this so it works on Mac 2011.
I don't have a Mac to test it on so it's hard to identify where the problem(s) is(are.) I have tried to find a site that explain the differences in coding between PC & Mac, but haven't found anything that clearly shows how to change coding from one platform the another.
Any help is greatly appreciated.

Please Login or Register  to view this content.

[AlphaFrog]

I'm not a Mac guy. So I'm only offeing a suggestion.

I think your problem is just promting the user to open a file on a Mac. That bit is a little different than for a PC.

Once the file is open, the rest of your code is fairly stright forward. It justs copy\pastes and sets a VLOOKUP formula. I think (not positive) that part is all the same on a PC and Mac.

Here is a good link that shows you how to prompt a user to open a file for a Mac.
Select files on a Mac (GetOpenFilename)

That's all I have to offer. Good luck.