Of course, it is not much of an issue for me right now, as I was using Chart.Export to create a.gif file, and put it back into a UserForm with.LoadPicture().

And it will give us incentive to write to the MacBU at MS to request full-scale support.

This also gives me full access to Microsofts on-line support, which has also been crippled for Mac users (cant use all of the search features).

However, there does not seem to be any way to access that option via VBA on the Mac.

Just discovered to tady when trying to run the Dictionary Object Model macros that Mac does not have Microsoft Scripting Runtime.:(:dunno.

Save As PDF is not part of Windows VBA, it is installed by Acrobat, or maybe some other 3rd party PDF writer.

In an off moment, I might accept that MSFT does not support certain object model difference due to the increased cost of implementing for the Mac, but I NEVER will understand why simple string functions such as Split, Join, etc.

Excel Limitations Vba Code From Office

Right now Im converting Excel VBA code from Office 2000 to Office X on my new machine and hitting plenty of problems.

Yeah, Im too cheap to get Office 2004 yet).

Excel Limitations Vba Update Images In

The LoadPicture() method above hits me hard because I use it to update images in UserForms.

Havent found any useful workaround yet although Ive read that its been fixed in Office 2004 SP1.

For this one I just created a new function to handle it under both Mac and Win: Function RevSearch(ByVal string1 As String, ByVal string2 As String) As Integer RevSearch 0 Do While InStr(string1, string2) RevSearch RevSearch InStr(string1, string2) string1 Right(string1, Len(string1) - InStr(string1, string2)) Loop End Function There are probably more elegant solutions, but I have a lot of ground to cover.

Another one: Application.GetOpenFileName() always seems to fail for selecting multiple files.

Right now Im using a very cludgy workaround that goes like this: i) identify a directory using Application.GetOpenFileName() in single file mode.

Dim MyData() as Variant, n as Integer ReDim MyData(1 to lengthoffile, 1 to 1).

Do While blah-blah Input 1, MyData(n, 1) n n 1 Loop Sheets(My Sheet).Cells(1, 1).Resize(UBound(MyData, 1), 1) MyData.often fails with a Type Mismatch where file 1 just contains numeric data.

It seems that Mac VBA is not as smart as WIN VBA in determining types for Variant.

The fix here was to change the Input to: Input 1, TempData MyData(n, 1) Val(TempData) This forces VBA to recognize the Variant array as numeric.

Excel on Windows has a range between 111900 and 31129999 while at Mac its from 111904 through 31129999.

Not that this may impact too much but its always usefull to know.

Actually, Save as PDF is part of Mac OS X, available in all OS X applications.

In order to access that capability would require AppleScript, which can also work with Excel.

Its possible that its actually a permissions problem, but since Im asking it to export to the Documents folder, it really shouldnt be.

Excel For Mac Limitations Vba