I have a program I wrote in Excel VB that I want to be able to run on a Mac. However when ever I open the workbook on a Mac many of the user forms come up blank, and most of the string functions are undefined. specifically mid() and chr() functions. When I start a new program from scratch on the Mac the mid() functions work just fine. Is it possible to resolve these issues or are these lower level functions not compatible between both systems.
PC excel vertion = Microsoft Excell 2002 (10.2614.2625)
Mac vertion = Office X for mac
Mac Pc compatibility with Excel VB
Thomas82
The error isn't in the string functions. The problem is with some other library or command which is not valid in Mac VBA. I've found that the strings library acts as the canary in a coal mine: when there's a bad reference or command elsewhere, the error shows up in the strings.
In the VBE, go to the Tools menu and select References. In the list, look for any which are labeled "MISSING:". Uncheck the missing reference, then see if the code works. You may need to find the equivalent reference on the Mac.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
olelar
eric_o
There was a reference listed as missing on the Mac, it was "Microsoft Help Visuals 1.0". I removed it other pc and the methods seemed to still work fine. I then reopened the project on a Mac and there were no references listed as MISSING. However the user forms are still coming up blank. Any other suggestions