Microsoft Excel 2003 Forum

Nov-05-2005

Complete VBA support in this application would be very important in order to enable (big) companies to move their Excel/VBA based stuff to Linux-platform. Currently the Crossover Office's VBA support feels to be absolutely missing. I evaluated Excel 2003 on RedHatEnterpriseLinux 4.0, with most recent Crossover office demo (Nov 2005). Result: It doesn't support even smallest possible macro created by macro recorder ["change cell color"]. The excel files got often erroneously locked (error message: "locked by another user"). etc problems.

Conclusion: CrossOver Office & Excel 2003 combination is currently not suitable for business use. Hope you've plans for improvements. I know that there would be lots of potential users who would benefit from VBA support. VBA & Excel combination is widely used in business, as I guess most of you know.

-markus

VBA support will continue to get better on Office 2003. It should work perfectly in Office XP and Office 2000, however. So if you have access to either of those, I would urge you to try the macros again with them.

I'll look into the specific issues you mention.

I spoke with someone on IRC last week about VBA support in Excel 2003 and was told it might be helpful for having examples for things that do not work. The following spreadsheet is used by the ASHRAE SSPC 90.1 Envelope Subcommittee as part of their work on energy standards. It depends heavily on VBA for functionality. I was unable to get it functioning in Excel 2003, but did have success with Excel 97 (in Crossover 6).

http://www.gard.com/901EnvOpt_2006VBA(10-31-2006).xls

If I have time, I'll try to get down and dirty and with it and file specific bugs.

I use Mandriva Linux 2008 as O/S and using Crossover Standard trial version for running Excel 2003.
I build macro program that use form(s) for interactive menu and can be ran on Computer that use Window's O/S
But when I ran that macro on computer with Mandriva O/S I got an error message "Could not load an object because it is not available on this machine". After I improve by added some Missing Refference Library there was still an error "Out of Memory"
Is there anybody knows how to solve my problem ?
Many thanks in advance.

• Teguh -

In F9 macros worked very well for Office XP (Crossover 6.2) and very little in Office 2003 (Crossover 7). The only bug I really encountered in XP was when I had an excel macro try and control Word (example below) it would come up with a compile error.

I've just tried Crossover Prof 7.0.2 and office 2003 and feel I just have to warn everyone thinking of using it with vba.
Events are missing. Thisworkbook has no events. Making classes with events are not possible.
I've tried creating a class with this familiar code :

Dim WithEvents App As Application
Dim WithEvents WB As Workbook
Dim WithEvents WS As Worksheet

No go - the editor just resets it all.

In fact - VBA is better in openoffice........

I haven't had ANY success with office 2003 vba...is there any starting point? I can't even record a two line copy/paste with Crossover 7 so I'm stuck in vmware server doing the most basic things yet alone anything remotely intermediate.

So what is the latest status of Excel VBA support in CrossOver mac? Still doesn't work with Office 2003? What is the reason it doesn't work? its been a couple years since people started complaining about this. I'm thinking about running some rather sophisticated excel programs on my mac, if they will work with Crossover mac and Excel, but it sounds like I need to be prior to Office2003?