[Wine] VBA in MSOffice?

[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/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