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.