Windows GetOpenFileName Method Workaround for Excel 2011 on MAC

charlesdh · #7 01-22-2015, 06:31 PM

Hi,

Here's a code that checks the "Operating" system.
Set the users button to run this code.
If the "OS" is windows ave the call to the windows code.
If it a mac then call the mac code.
Ps. I'm going to do this in a file that I created that needs to run in windows or mac.

Code:

Sub Test_Me()
Dim TheOS As String
TheOS = Application.OperatingSystem
If Left(TheOS, 7) <> "Windows" Then Call Gather_Data
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2008 vs Excel 2011 for Mac	nfotx	Excel	0	12-05-2014 03:48 PM
Index Hyperlink Workaround	Phil H	Word VBA	9	10-30-2014 05:14 AM
Workaround to have UserForm open from Web Link	Kirsti	Word VBA	11	08-23-2012 07:05 PM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM
MAC PPT 2011 compatibility with Windows	stoneygeorge	PowerPoint	0	08-05-2011 10:00 AM