Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How Convert Excel VBA macros to Excel for MAC 2011

Posted on 2014-04-05
1
Medium Priority
?
2,059 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This is a tech scam I recently helped my parents through.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

877 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