Windows GetOpenFileName Method Workaround for Excel 2011 on MAC

Story11 · #31 01-25-2015, 11:09 PM

Hi! I have tried it but it didn't run. There was error in a line of the codes. The error says: 'object required'. I have attached a screenshot of the part that has error to this post. Thank you.

charlesdh · #32 01-26-2015, 01:13 PM

Hi,

In your workbook you must have this at the very top of the code module.

Code:

Dim MyFiles As String

The object is the "MyFiles"

Story11 · #33 01-26-2015, 01:19 PM

I have the code you mentioned there - it the first line of code in the whole macros.

Story11 · #34 01-26-2015, 01:22 PM

the only thin I noticed is this... Look at the fourth line of code, it looks like the declaration is not complete. That code is below.

Code:

Dim myos

charlesdh · #35 01-26-2015, 01:26 PM

That should not matter. Can you attach a copy of your workbook? or you can send it to me.
check pm

Story11 · #36 01-26-2015, 01:40 PM

I've attached the workbook to your mail like you requested.

charlesdh · #37 01-26-2015, 05:36 PM

HI,

Did the file work for you?
If all is well please post the result on the forum.

Story11 · #38 01-26-2015, 09:34 PM

I will definitely do that, thank you so much!

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