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.
It would be a help if I could first get an answer to the question I'm actually asking. 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.
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.