Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac
This answer was rated:

I have had a spreadsheet application developed for financial

forecasting. (Windows, Excel 2010)...
I have had a spreadsheet application developed for financial forecasting. (Windows, Excel 2010). The vba code runs its own tab in the ribbon with buttons for a bunch of fairly simple time-saving macros (mostly more instant access to standard excel stuff like hiding columns, formatting cells etc. The most complex thing it does is combine a whole heap of custom views and produce a multi-page pdf doc. However my developer is despairing of ever getting it to work in Excel for Mac, which just seems to spit the whole thing back whenever we try to open it. My question is this: Should it work? Are we missing something? or is this just a fundamental short-coming. Much as I'd love it to work on macs as well I need to know whether to spend any resources on trying to solve this... Are they liely to big issues, or little ones that just need a bit of re-coding? I'd be grateful for a thumbs up or a thumbs down... Thanks, Simon
Show More
Show Less
Ask Your Own Mac Question
Answered in 4 hours by:
4/3/2013
James
James, Sr. Mac Support Expert
Category: Mac
Satisfied Customers: 15,908
Experience: Mac Expert
Verified
Hi, my name is XXXXX XXXXX I appreciate the oppurtunity to assist you today.
I will do my best to answer your question!

I am not sure which version of Excel you are using, so I'll try to address this broadly.
The old versions of Excel (pre-2008) use Apple Scripting, which is very different than the Microsoft VBA. Then in Excel 2008, Microsoft removed scripting support altogether.

In the latest version, Excel 2011, Microsoft re-introduced VBA, which is essentially the same as the VBA used on PC's, however since the operating systems are very different, there are still a lot of adaptations needed to make PC code work on a Mac. Depending on the version of Excel you have on the Mac, you will need to get someone who can convert the code for you. It would probably be easier to do it on Excel 2011, but will still require some work, preferably by someone who has done this before.

I hope this answers your question.

Thanks,

James.
Ask Your Own Mac Question
Customer reply replied 4 years ago

Hi James,


 


Thanks for your answer.


 


I'm aware of most of the issues you have raised, but what I'm trying to quantify is whether relatively straightforward code written for pc can be converted or not, or whether there are - or may be - absolute obstacles in the way. I know this is tough without seeing the code and knowing what it does, but my starting point has to be whether it's likely to succeed or not.


 


It's not a question of which version of Excel for Mac I'm running, it's about my clients. I'm aware that 2008 was a no-no, so am I likely to be able to adapt my application for people running later versions.


 


You haven't said "forget it", so do you think it's worth pursuing? At present I can't look after clients who use Macs at all. I guess what I'm hoping to hear is "there's no reason in theory why you couldn't re-code anything written in vba for Excel on a pc (assuming you';re not trying to put a man on the moon) and make it work on a Mac". Or failing that I could live with: "this whole area is fraught with difficulties and you could spend a lot of time and money without getting a result". At least I'd know. Are you familiar enough with the issues to come down on either side?


 


Thanks for your time. Beddy-byes time this side of the pond so maybe speak again tomorrow.


 


Cheers


 


Simon

Hi,

Thank you for the additional info.

Can you please tell me which version of Excel your clients are using? Is it all the same version, or multiple versions?

Can you tell me approximaely how many lines of code in the script?

I will then be able to estimate how long it will take to convert it.

Thanks!

J.
Ask Your Own Mac Question
Customer reply replied 4 years ago

Hi James,


 


It would be a help if I could first get an answer to the question I'm actually asking. Undecided What I need at this stage is reassurance - from someone qualified to have an opinion - on whether this is something I should pursue. (We're a bit away yet from quantifying the job...)


 


I infer from what you ask me that you don't see a problem but you don't say so clearly. You also haven't said to me " I'm familiar with the issues you;re discussing and I understand them", which would be kind of nice to hear in this environment.


 


So again, the question is: Given vba code written to conduct some fairly basic Excel tasks in Windows, how likely is it that it can be re-written for Mac, or are there any fundamental issues that might prevent it being successful?


 


Perhaps some percentage estimate of likely success would be an easy way for you quantify it? I appreciate you're a bit light on facts, but I won't hold you to it!


 


Obviously I have no control over what versions of Excel my clients are running on their Macs - I would like to offer and support as far back as I can, which clearly precludes 2008. If I have to stipulate the most recent version only, so be it, at least it's progress.


 


Am I right to also infer that this is the kind of work you do? Can I contract you outside the 'just answer' platform?. Or does the platform accommodate this kind of work anyway?


 


I guess if it looks like we may have the basis to proceed I'd need to send you a copy of the spreadsheet, with the code, for you to assess it properly...?


 


Thanks again for your time.


 


Simon.


 


www.edgeff.co.uk


 


 


 


 


 

Hi Simon,

I do understand the issues involved very well, I just want to make sure I give you good, accurate information.
You do realise that without adhering to a single, known version of Excel, the amount of work is multiplied by the versions your clients may use, and each version will need it's own code base (to be converted AND maintained).

I'll do my best to answer, if I still miss something, please let me know...

If you can't say for certain your clients will be using Excel 2011 - I would say this is a big task. You will need to convert the code to ALL versions of Excel, including VBA and Apple Scripting. This is a big task, since Apple Scripting is quite different from VBA. That said, it is doable - will simply take more time (several weeks).

If you can say for sure all clients will be using Excel 2011, the task is fairly easy, no issues that I can think of, and should be doable in a few days by any VBA programmer.

I do coding for Excel, but I'm not certified by JustAnswer as a programmer and certainly cannot undertake any work outside the site. It would be best to post this request in the programming category, though for this kind of project I would seriously consider outsourcing to a software house.

I hope this answers the questions - if not, please ask and I will do my best to revise my answer!

Thanks,

J.
James
James, Sr. Mac Support Expert
Category: Mac
Satisfied Customers: 15,908
Experience: Mac Expert
Verified
James and 87 other Mac Specialists are ready to help you
Ask your own question now
Customer reply replied 4 years ago

Hi James, Thanks.


 


That's all much clearer now thank you. XXXXX will restrict it to 2011, which I'm guessing is the latest Excel for Mac (any idea when they're planning a new release?) which would mean I would no longer have to flat turn away Mac users.


 


I guess in software development terms we have an advantage - that the usual development iterations, feature creep etc - don't affect us; we just have to convert exactly what's there. I will now look for a vba for Mac developer, more likely in the UK, or maybe far-east if I can find something that looks reliable and well-managed.


 


Sorry that you're not in a position to profit further from this, but thanks for your help.


 


Over and out.


 


Simon

Ask James Your Own Question
James
James
James, Sr. Mac Support Expert
Category: Mac
Satisfied Customers: 15,908
15,908 Satisfied Customers
Experience: Mac Expert

James is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

< Previous | Next >

Meet the Experts:

Mike

Mike

Mac Medic

8,555 satisfied customers

Over 20 years IT experience with Apple computers in publishing, marketing and design.

Daniel

Daniel

Mac Genius

4,711 satisfied customers

Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.

Vinod Menon

Vinod Menon

Support Specialist

2,394 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,994 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,507 satisfied customers

BSc H.Dip Apple Certified Professional

Claws224

Claws224

IEEE Datacommunication Engineer

965 satisfied customers

IEEE, Microsoft

Mac Tech

Mac Tech

Apple Specialist

888 satisfied customers

7 + Years Supporting Apple Products

< Previous | Next >

Related Mac Questions
I have Microsoft office for apple (Mac). I deleted excel and
I have Microsoft office for apple (Mac). I deleted excel and power point, how do I get em back? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have an Excel workbook that opens extremely slow. What can
I have an Excel workbook that opens extremely slow. What can I do to speed it up? Thank you. … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
I have a Mac with Microsoft ( word, powerpoint Excell and
I have a Mac with Microsoft ( word, powerpoint Excell and Outlook)I need to upgrade to outlook 2016. I am having problems as I don't remember my microsoft log in password Help … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I just purchased the excel-etal. I can't get excel to open.
I just purchased the excel-etal. I can't get excel to open … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
I had to update my Word and Excel recently and I have had
I had to update my Word and Excel recently and I have had nothing but problems every since. I can't Save As two different Excel docs. I try to close them and I get a whirling wheel and "Refreshing" wh… read more
Josh
Josh
It Support Specialist
Associate Degree
5,138 satisfied customers
Microsoft office outlook and excel and word will not open, i
microsoft office outlook and excel and word will not open, i get the message this application will not open correctly with a code Oxc0000142. what must I do to correct ? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I sent my wife and Excell file but we only have access to
I sent my wife and Excell file but we only have access to Mac computer so need to know how to convert it into pages to be able to open it on a MacBook pro … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,275 satisfied customers
I have been using the microsoft one cloud/ excel and word
I have been using the microsoft one cloud/ excel and word apps on my apple Ipad. it is telling me (after two years use) that it can not connect with the internet. Meanwhile all my other apps can? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
Can I back out an upgrade to Excel without losing files? OS
Can I back out an upgrade to Excel without losing files? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I am trying to understand why the Mail merge from Excel to
I am trying to understand why the Mail merge from Excel to Word will not work on my brand new computer??? The excel is saved in the format ".xlsx" but it still says I need an Excel Workbook Text Cover… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I just this afternoon updated microsoft office excel but I
I just this afternoon updated microsoft office excel but I don't want it now. I have a backup external hard drive. can i get rid of the update by downloading from time machine. if so, how? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
I am trying to save updates to an excel spreadsheet on my
I am trying to save updates to an excel spreadsheet on my new 27" Mac that I brought in from a 10 year old Mac. I get a "something went wrong" massage, which recommended that I contact you. … read more
Cabletech
Cabletech
High School or GED
140 satisfied customers
I've used Excel for years with no problems. I have a new
I've used Excel for years with no problems. I have a new iMac desktop with a more current OS and Excel version than I have been using. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I guess I need to update my Excel but not sure how to do it.
I guess I need to update my Excel but not sure how to do it … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
Excel for Mac opens to a blank Excel file, When I bought the
When Excel opens to a blank file, it also freezes my machine from doing other things, such as logging out, restarting, etc. I've done a forced shutdown (holding down the power button), but this hasn't helped. Same problem exists once I restart the machine. … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
781 satisfied customers
Im on my moms computer trying to help her. Her excel program
Im on my moms computer trying to help her. Her excel program is not working and will not open at all. I have the original Office.mac dvd but dont know how to reinstall excel without losing whatever da… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Hanging with Word and Excel - just did updates. No idea. It
It is a Mac mini, i7 with 16 mb ram purchased in 2013, it should be running the latest Mac OS … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Excel for Mac. The tabs at the bottom of the page have
Excel for Mac. The tabs at the bottom of the page have disappeared. Tried changing preferences as suggested and no change.Thanks.… read more
Jon
Jon
Bachelors Degree
479 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x