Hi all,

This is my first post. Hope I am in the right place.

I have written a lot of code on a PC for a MAC with Office 2011. I guess I had a dumb hope that all the coding would be compatible. Not.

Am in the process now of debugging a "Missing library" error message. No mention made of the library missing. The references in the MAC match those in my PC.

I don't have a Mac, so experimentation is limited.

I am wondering if anyone knows of PC to MAC (2011) VBA documentation on what works and what does not.

Based on reading older articles on the Internet, I have the following list of suspects:

msoFileDialogFolderPicker
InstrRev
ShellApp
(ex: Set ShellApp = CreateObject("Shell.Application":ShellApp.Open s )


MAC directory referencing using colons rather that backslash
Example: "HardDriveNameocuments:Test.doc"
(see Ken Pulls article: vbaexpress.com/kb/getarticle.php?kb_id=559

Any tips on known problems with the list above or direction to further reading is appreciated.


Thanks & regards,
mauryb