VBA in MSOffice?

Open forum for end-user questions about Wine. Before asking questions, check out the Wiki as a first step.
Forum Rules
Locked
Morgan Read

VBA in MSOffice?

Post by Morgan Read »

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/BrowserClie ... b54d9e378b
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/li ... /freed-ora
Top
James McKenzie

VBA in MSOffice?

Post by James McKenzie »

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
Top
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Re: VBA in MSOffice?

Post by dimesio »

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.
Top
Morgan Read

VBA in MSOffice?

Post by Morgan Read »

James
Thanks for getting back, comments in-line below.
Regards,
Morgan.

On 25/01/09 16:57, James McKenzie wrote:
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.
OK, thanks
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.
OK, good
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?
Fails to fire I guess, no crash or lock-ups, just a trail of dialogues
on attempting to run the macro. I included ALL the window dialogues I
got on that trail in the "listings" like this:
...
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!
...

They're all that happened - I've included it again below.
Can you add what you get from your terminal session when you attempt to
run the macro when you start Word from there, please.
That's what I included following my sig and I assumed you meant by
"listings". I've copied it again below.



Below is the output from the command prompt/terminal session (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/BrowserClie ... b54d9e378b
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/li ... /freed-ora
Top
Morgan Read

VBA in MSOffice?

Post by Morgan Read »

Rosanne
Thanks for getting back, comments in-line below.
Regards,
Morgan.

On 25/01/09 17:10, dimesio wrote:
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.
OK, thanks
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.
Just my own script that the comment is in and you've quoted above - I
just found it helps to document things for others and speed a repetitive job
What version of Wine are you using? If it's not the latest, upgrade.
$ rpm -q wine
wine-1.1.12-1.fc10.i386

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.
OK, but winetricks makes the process that much less painful...
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.
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?

Thanks.
--
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/BrowserClie ... b54d9e378b
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/li ... /freed-ora
Top
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Post by dimesio »

>
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.
Top
austin987
Wine Developer
Wine Developer
Posts: 2383
Joined: Fri Feb 22, 2008 8:19 pm

VBA in MSOffice?

Post by austin987 »

On Sun, Jan 25, 2009 at 7:22 PM, dimesio <[email protected]> wrote:
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.





There's now a fake placeholder dll for stdole2.tlb in git, so it
shouldn't be necessary.

--
-Austin
Top
Locked

Return to “Wine Help”