Solved

Is it possible to convert an Excel macro to a mac?

Posted on 2011-09-26
6
525 Views
Last Modified: 2012-06-21
I have an Excel spreadsheet that was created on a PC that uses macros. When I move the file over to a mac with Excel 2011 and the two missing references are Microsoft internet controls and Microsoft Windows Common Controls-2 6.0 (SP6).

I can get the spreadsheet to open on the Mac, but the macros don't work. and the 2 above references are missing.

Is there any way to get my spreadsheet that works on a PC to work on a Mac?  How much work is that going to take?  I am having trouble finding information on converting from one platform to another.
0
Comment
Question by:MyLtPny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 2

Expert Comment

by:jan24
ID: 36600600
Hi,
I have Excel 2011 for Mac but have never tried using macros on it (I do my macros on Excel 2010 for PC usually), though I understand that 2011 does support them.  
If you can send over a copy of the file I'll happily have a crack at getting it to work on the Mac for you.
0
 

Author Comment

by:MyLtPny
ID: 36600699
Thanks for the offer, but it is a huge file with confidential information so I am unable to share it.

Thanks again.
0
 
LVL 2

Expert Comment

by:jan24
ID: 36601112
You could try deleting all the data and then sending it over.  Is that possible?
0
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 36602467
ActiveX controls are not supported in Macintosh Excel. You will need to use Forms controls instead.

It sounds like you may be using other controls in your workbook as well (above and beyond the ones that are standard in Excel VBA). If so, you may need to find substitutes for those too. Neither of the two references that you mentioned is standard with Excel VBA.

It looks (from the name) like Microsoft Internet Controls comes with Internet Explorer, which hasn't been available for Macintosh for quite a while. I don't see Microsoft Windows Common Controls at all in my references.
0
 
LVL 50
ID: 37412266
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

707 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