Getting Excel VBA written using Windows to work on Excel for the MAC

[adrian1906]

I am trying to get my Excel VBA code written on a PC to operate properly on a MAC. I have determined that the MAC version is missing key libraries. How would I go about locating the library or at minimum determining if it even exists for the MAC (for example, regular expressions).

On my PC version, I can determine the .dll file associated with each reference.

For example:
Microsoft XML, v6.0 ==> c:\Windows\System32\msxml6.dll
Microsoft Internet Controls ==>c:\Windows\SysWOW64\ieframe.dll
Microsoft InkEdit Control 1.0 ==> C:\Windows\System32\Inked.dll

Should I try and search for these same files on the MAC and then attach them as references. Should I try to find MAC versions? If so, where? I need to provide the instructions over the telephone to the person who uses the mac. I don't own one and do not have easy access to one.

The person would like to use the program without using a windows emulator.

Thank you.

[westconn1]

i am sure there is no equivalent to any of those controls on a mac

i would suggest removing the parts of the code that rely on those controls or better using a Mac program and automating it, rather than trying to make windows programs work on a Mac operating system
i do not believe VBA can use features of the Mac system, that are outside of the excel object

[adrian1906]

This is what I'm slowly figuring out.

I had setup a database using Excel for my track and field team to record our member's performance marks. Excel was an easy choice because all the coaches had it on their computer and was somewhat familiar with using it. Unfortunately, the head coach uses a Mac. It was fine at first but, over time, the code had increased in complexity without any though of compatibility issues and without constant checking to see if worked on the Mac. I don't thinks it was far fetched to think that I should be able to do anything with Excel for the Mac that I can do with Windows. I realized early that there was an issue with Regular Expressions, but I thought that was it. It's worse than I thought! Why any serious computer user would choose that OS is beyond me.

Never the less, I have been brushing up on MySQL with the hope of eventually converting to a true database and then just use Excel to perform queries. This will provide the impetus. OH WAIT.... a quick Google search indicates that there may be an issue with Mac Excel VBA having access to ODBC drivers.... WOW.

I'm still going to convert the database to MySQL. Maybe I'll use a web based server to perform queries from the MAC and save as .csv files that can be imported into Excel.

Thanks again for your response.

i am sure there is no equivalent to any of those controls on a mac

i would suggest removing the parts of the code that rely on those controls or better using a Mac program and automating it, rather than trying to make windows programs work on a Mac operating system
i do not believe VBA can use features of the Mac system, that are outside of the excel object

[westconn1]

just put the whole app onto the web and let them all run from there, or else use some terminal server or citrix

i was being polite before and did not say tell them get a real computer