Solved

How Convert Excel VBA macros to Excel for MAC 2011

Posted on 2014-04-05
1
1,824 Views
Last Modified: 2014-04-10
Can anyone advise me on how to convert some old Excel VBA code (Macros) so that I can run them on Excel 2011 for MAC ?
These Macro's read a file or two from the hard drive, and I see a few occurances of "C:/" here & there ... but am thinking that there may be more to it that just changing the path names.

Thanks
0
Comment
Question by:bleggee
1 Comment
 
LVL 65

Accepted Solution

by:
RobSampson earned 500 total points
ID: 39980749
Hi, I don't use a MAC, but I found this site which looks like it gives you great information on how to work with files on a MAC with VBA:
http://www.rondebruin.nl/mac/section3.htm

Regards,

Rob.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question