Office 2003 VBA Not Working

Questions about Wine on Linux
Locked
mwaterbu
Newbie
Newbie
Posts: 4
Joined: Sun Dec 07, 2014 12:52 pm

Office 2003 VBA Not Working

Post by mwaterbu »

I found some direction on making VBA macros run here, but unfortunately, it is not working for me. I am interested specifically in Excel.
Office installs fine, if I run a typical install (if I try to run the custom install it will fail). Once it is installed, I can create and open documents, but running a macro will cause Excel to crash.
As recommended in the guide linked above, if I install dcom98 with winetricks, Excel displays "Cannot use object linking and embedding" upon starting.
With dcom98, when I try to open a workbook that contains a macro, I receive the error, "An error occurred initializing the VBA libraries (14)" followed by a message asking if I want to recover unreadable content from the workbook.
Not sure what I am doing wrong or how to proceed. Hopefully I am just forgetting a simple step in the setup?
I appreciate any help with this, thanks!
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Re: Office 2003 VBA Not Working

Post by dimesio »

Outside howtos aren't supported here, and the one you followed is 6 years old. Native dcome98 hasn't worked with Wine in about 5 years.

You didn't mention what Wine version you're using, but it must be an old one, because the problem with Excel macros was fixed over a year ago. https://bugs.winehq.org/show_bug.cgi?id=25762

Upgrade Wine to the latest development release and reinstall Office 2003 to a clean, 32 bit wineprefix following the instructions in the AppDB. https://appdb.winehq.org/objectManager. ... n&iId=3214
mwaterbu
Newbie
Newbie
Posts: 4
Joined: Sun Dec 07, 2014 12:52 pm

Re: Office 2003 VBA Not Working

Post by mwaterbu »

Excellent, thanks for the help. Honestly not sure what I was doing wrong, since macros were not working before I added dcom98 to begin with, and I was using the latest WINE. But I re-installed, and things seem to be working. One of my workbooks still won't load, but I think I found a solution at an outside how-to regarding a change with MSCOMCTL.OCX.
Locked