[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How Convert Excel VBA macros to Excel for MAC 2011

Posted on 2014-04-05
1
Medium Priority
?
2,107 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 2000 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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
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 will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

591 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