Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #31  
Old 01-25-2015, 11:09 PM
Story11 Story11 is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 64bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2013
Novice
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC
 
Join Date: Jan 2015
Posts: 28
Story11 is on a distinguished road
Default


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.
Attached Images
File Type: png object required.png (38.8 KB, 11 views)
Reply With Quote
  #32  
Old 01-26-2015, 01:13 PM
charlesdh charlesdh is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 32bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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"

Last edited by charlesdh; 01-26-2015 at 01:14 PM. Reason: added info
Reply With Quote
  #33  
Old 01-26-2015, 01:19 PM
Story11 Story11 is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 64bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2013
Novice
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC
 
Join Date: Jan 2015
Posts: 28
Story11 is on a distinguished road
Default

I have the code you mentioned there - it the first line of code in the whole macros.
Reply With Quote
  #34  
Old 01-26-2015, 01:22 PM
Story11 Story11 is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 64bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2013
Novice
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC
 
Join Date: Jan 2015
Posts: 28
Story11 is on a distinguished road
Default

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
Reply With Quote
  #35  
Old 01-26-2015, 01:26 PM
charlesdh charlesdh is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 32bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

That should not matter. Can you attach a copy of your workbook? or you can send it to me.
check pm
Reply With Quote
  #36  
Old 01-26-2015, 01:40 PM
Story11 Story11 is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 64bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2013
Novice
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC
 
Join Date: Jan 2015
Posts: 28
Story11 is on a distinguished road
Default

I've attached the workbook to your mail like you requested.
Reply With Quote
  #37  
Old 01-26-2015, 05:36 PM
charlesdh charlesdh is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 32bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

HI,

Did the file work for you?
If all is well please post the result on the forum.
Reply With Quote
  #38  
Old 01-26-2015, 09:34 PM
Story11 Story11 is offline Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Windows 7 64bit Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Office 2013
Novice
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC
 
Join Date: Jan 2015
Posts: 28
Story11 is on a distinguished road
Default

I will definitely do that, thank you so much!
Reply With Quote
Reply

Thread Tools
Display Modes


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
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Index Hyperlink Workaround Phil H Word VBA 9 10-30-2014 05:14 AM
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Workaround to have UserForm open from Web Link Kirsti Word VBA 11 08-23-2012 07:05 PM
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft