I built an application in Microsoft Excel on an XP computer for a client. The app consisted of data entry forms, validation logic (e.g. make sure 3 fields add up to 100%), publish functionality that takes data from the current spreadsheet and puts it in another spreadsheet that the user specifies the folder for.
I just found out that the client is running Excel on Mac OSX and is getting runtime errors on all of the validation logic as well as the publish functionality. All of this was written in Visual Basic and he mentioned he's had problems with VB functionality before on the MAC OS.
Is there any way around the issue that seems to exist with VB functionality on Excel for Mac OSX?