I have a client that I'm creating a Excel (local) / MySQL db(web hosted) order tracking application... I've done a few of these integrated to MySQL and they work pretty well.
The issue that I'm running into with this application is they want it to be compatible with MACs Excel 2011. At first I was like... No problem, Excel 2011 is suppose to support VBA and everything should work..... WRONG...

It's been a learning experience.. Mac Excel 2011 version doesn't support ActiveX controls or ADODB... So I feel that I have my hands tied behind my back.

My first hurdle was getting the connection string to work. I normally download free MySQL drivers from MySQL.com. but Oracle MySQL doesn't have a 10.7 driver for macs, and I had trouble installing the earlier versions on the Mac... SO, I did download one from Actual Technologies and I up and running.

Next hurdle... ActiveX controls... all the neat Userforms w/ dropdowns to build the criteria for queries that I was using, Now needed to be handled differently..

MY BIGGEST Hurdle.. lack of ADO... I'm using the QueryTable method to SELECT, DELETE, and INSERT data.. I've got it working but it's a pain.
Also, with the QueryTables, is there a way to work with individual records in the recordset that's returned? I see where it only appears that you return the entire query to a set destination. I need to manipulate the records within the recordset. I can't find much documentation on the QueryTables method to help me. Any ideas?

Or.. Do you have other suggestions of how to tackle database development for the Mac side of VBA?