thr3ads.net - wine users - [Wine] VBA in MSOffice? [Jan 2009]

If this information is useful, please help other people find it:
Share via:

Morgan Read

2009-Jan-25 03:40 UTC

[Wine] VBA in MSOffice?

Folks

I have a macro that fails in Word, are there any work-arounds, alternate
dlls etc that can be suggested to get it going?  Is there any forum
dedicated to getting these going?

I've installed MSOffice like so:
cd "/media/Office 2003 Pro/OFFICE";\
# Set your preferences
WINEPREFIX=~/.MSOffice winecfg;\
# Click through the dialogues
WINEPREFIX=~/.MSOffice winetricks wsh56 vb3run vb4run vb5run vb6run
msxml3 msxml4 msxml6 gecko;\
# Enter Pass-Key
WINEPREFIX=~/.MSOffice wine SETUP.EXE;\
### This script seems to stall here???!!!
# Set "gdiplus" dll to "(native, builtin)"
WINEPREFIX=~/.MSOffice winecfg;\
WINEPREFIX=~/.MSOffice winetricks dcom98;\
done

Any ideas?
Regards,
Morgan.
PS
Below is the output from the command prompt (with corresponding window
dialogues separated by ------------'s):

$ WINEPREFIX=~/.MSOffice wine "C:\Program Files\Microsoft
Office\OFFICE11\WINWORD.EXE"
err:module:attach_process_dlls "rpcrt4.dll" failed to initialize,
aborting
err:module:LdrInitializeThunk Main exe initialization for
L"C:\\windows\\system32\\explorer.exe" failed, status c0000005
fixme:psdrv:PSDRV_DeviceCapabilities DC_BINADJUST: stub.
fixme:psdrv:PSDRV_DeviceCapabilities DC_BINADJUST: stub.
fixme:psdrv:PSDRV_DeviceCapabilities DC_BINADJUST: stub.
fixme:psdrv:PSDRV_ExtEscape QUERYESCSUPPORT(25) - not supported.
fixme:psdrv:PSDRV_DeviceCapabilities DC_BINADJUST: stub.
fixme:psdrv:PSDRV_DeviceCapabilities DC_BINADJUST: stub.
fixme:reg:GetNativeSystemInfo (0x32f7e4) using GetSystemInfo()
fixme:advapi:CheckTokenMembership ((nil) 0x21ff90 0x32f7ec) stub!
fixme:advapi:CheckTokenMembership ((nil) 0x21ff90 0x32f7ec) stub!

-------------------------------------------------------------------------------
File > Open (template with macros & enable)
Tools > Macros > Macros... > Run
-------------------------------------------------------------------------------

fixme:psdrv:PSDRV_DeviceCapabilities DC_BINADJUST: stub.
fixme:win:EnumDisplayDevicesW ((null),0,0x3282ec,0x00000000), stub!
fixme:wtsapi:WTSRegisterSessionNotification Stub 0x10092 0x00000000
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:shell:DllCanUnloadNow stub
fixme:shell:DllCanUnloadNow stub
fixme:time:GetCalendarInfoW Unimplemented caltype 1
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_GETLANGOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETLANGOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_GETLANGOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETLANGOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_GETLANGOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETLANGOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:dciman:DCICreatePrimary 0x998c 0x27613b0
fixme:richedit:CreateTextServices Support aggregation

-------------------------------------------------------------------------------
Microsoft Visual Basic
System Error &H80040110
_[OK]_ [Help]
-------------------------------------------------------------------------------

fixme:dciman:DCICreatePrimary 0x8450 0x23b13b0

-------------------------------------------------------------------------------
Microsoft Visual Basic
Out of memory
_[OK]_ [Help]
-------------------------------------------------------------------------------

fixme:font:WineEngCreateFontInstance Untranslated charset 255
fixme:reg:GetNativeSystemInfo (0x329b98) using GetSystemInfo()
fixme:advapi:CheckTokenMembership ((nil) 0x1ff3938 0x329ba0) stub!
fixme:advapi:CheckTokenMembership ((nil) 0x1ff3938 0x329ba0) stub!
fixme:shell:DllCanUnloadNow stub
fixme:shell:DllCanUnloadNow stub

-------------------------------------------------------------------------------
Microsoft Visual Basic - Document 2 [break]
(The debugger generated window.)
File > Close and Return to Microsoft Word Alt+Q
-------------------------------------------------------------------------------

fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub

-------------------------------------------------------------------------------
Microsoft Visual Basic
This command will stop the Debugger.
_[OK]_ [Cancel] [Help]
-------------------------------------------------------------------------------
Document2 - Microsoft Word
(The template/macro generated window.)
File > Exit
-------------------------------------------------------------------------------

fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETBIDIOPTIONS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub
fixme:richedit:ME_HandleMessage EM_SETMARGINS: stub

-- 
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClients?#head-259758ec5ba51c5205cfb179cf60e0b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/linux-libre/freed-ora

James McKenzie

2009-Jan-25 03:57 UTC

head link

[Wine] VBA in MSOffice?

Morgan Read wrote:> Folks
>
> I have a macro that fails in Word, are there any work-arounds, alternate
> dlls etc that can be suggested to get it going?  Is there any forum
> dedicated to getting these going?
>
> I've installed MSOffice like so:
> cd "/media/Office 2003 Pro/OFFICE";\
> # Set your preferences
> WINEPREFIX=~/.MSOffice winecfg;\
> # Click through the dialogues
> WINEPREFIX=~/.MSOffice winetricks wsh56 vb3run vb4run vb5run vb6run
> msxml3 msxml4 msxml6 gecko;\
> # Enter Pass-Key
> WINEPREFIX=~/.MSOffice wine SETUP.EXE;\
> ### This script seems to stall here???!!!
> # Set "gdiplus" dll to "(native, builtin)"
> WINEPREFIX=~/.MSOffice winecfg;\
> WINEPREFIX=~/.MSOffice winetricks dcom98;\
> done
>
> Any ideas?
> Regards,
> Morgan.
>   Why all of the vb(x)runs?  VB6RUN is all you should need.

In your listings you had many fixmes.  These just point out where
additional functionality needs to be worked on but will work for Office
2003.

What SPECIFICALLY happens when you attempt to run the VBA macro?  Does
it fail to fire, Word crashes, or does Linux lock up so that you have to
reboot?

Can you add what you get from your terminal session when you attempt to
run the macro when you start Word from there, please.

James McKenzie

dimesio

2009-Jan-25 04:10 UTC

head link

[Wine] Re: VBA in MSOffice?

Morgan Read wrote:> 
> I have a macro that fails in Word, are there any work-arounds, alternate
> dlls etc that can be suggested to get it going?  Is there any forum
> dedicated to getting these going?
> 
> I've installed MSOffice like so:
> cd "/media/Office 2003 Pro/OFFICE";\
> # Set your preferences
> WINEPREFIX=~/.MSOffice winecfg;\
> # Click through the dialogues
> WINEPREFIX=~/.MSOffice winetricks wsh56 vb3run vb4run vb5run vb6run
> msxml3 msxml4 msxml6 gecko;\
> 

Why are you using all those overrides? None are needed to install or run Office
2003 in current Wine.

> 
> WINEPREFIX=~/.MSOffice wine SETUP.EXE;\
> ### This script seems to stall here???!!!

What script are you talking about? Third party scripts (e.g., wine-doors,
playonlinux, bordeaux) are not support here.

What version of Wine are you using? If it's not the latest, upgrade. 

Delete or rename your old ~/.wine and run the installer again, with no
overrides, no tweaks, and no third party scripts. After installing, set an
override for riched20. There is no need for winetricks; Office installs its own
riched20.

The problem with macros is http://bugs.winehq.org/show_bug.cgi?id=11415 .
I've found that putting an empty stdole2.tlb in Wine's windows/sytem32
directory was enough to enable Word 2003 to record and play simple macros, but I
haven't really tested it beyond that. There are other possible workarounds
mentioned in the bug report if that doesn't work for you.

dimesio

2009-Jan-26 01:22 UTC

head link

[Wine] Re: VBA in MSOffice?

> > 
>  What version of Wine are you using? If it's not the latest, upgrade.
>  $ rpm -q wine
>  wine-1.1.12-1.fc10.i386

Upgrade to 1.1.13; 1.1.12 had a lot of problems. 

>  installing, set an override for riched20. There is no need for
>  winetricks; Office installs its own riched20.
>  OK, but winetricks makes the process that much less painful...

All you have to do is run winecfg and select riched20 from the drop-down list on
the Libraries tab. As I said, there's nothing to actually install.

>  I'll try this re your comments Bug 11415 and James' comments,
comments:
>  cd "/media/Office 2003 Pro/OFFICE";\
>  # Set your preferences
>  WINEPREFIX=~/.MSOffice winecfg;\
>  # Click through the dialogues
>  WINEPREFIX=~/.MSOffice winetricks vb6run riched20 dcom98 gecko;\
>  touch ~/.MSOffice/drive_c/windows/system32/stdole2.tlb;\
>  # Enter Pass-Key
>  WINEPREFIX=~/.MSOffice wine SETUP.EXE;\
>  done
> 
>  If touch ~/.MSOffice/drive_c/windows/system32/stdole2.tlb isn't
>  sufficient, where can I find a real one? 

Touch worked for me, but if you're installing dcom98 (why?), it's not
necessary, as dcom98 installs a real copy of stdole2.tlb. I didn't install
either dcom98 or vb6run.

Possibly Parallel Threads

Search for more possibly parallel threads

wine users - Jan 2009 - VBA in MSOffice?

[Wine] VBA in MSOffice?

[Wine] VBA in MSOffice?

[Wine] Re: VBA in MSOffice?

[Wine] Re: VBA in MSOffice?

Possibly Parallel Threads