wine, MS Excel and VBA

[udippel]

I have a VB application that I have to use relatively frequently. Excel does a great job from wine, but that application (working properly on Windows) does not do what it is supposed to when run from wine. The application interacts with a spreadsheet, extracts some fields, no rocket science.
I would love to have it running without any dual-boot. And I hope that the messages that I get from running it, can indicate to some expert, which library is eventually missing.

It is not totally hopeless, I think. It opens the proper application window, but doesn't read in the values. Also, when it is finished, the application window is indexed (2). That means, it must have opened the window in between, closed it, and opened another one. One that somehow doesn't manage to read the data from the excel file any longer (all this is my assumption, but in Windows it doesn't open the second window).

This is wine-1.6.2 on Ubuntu.

The file and path names have been obfuscated.

$ wine [ABc].exe
fixme:ole:CoInitializeSecurity (0x45ae08,-1,(nil),(nil),6,2,(nil),64,(nil)) - stub!
fixme:ole:RemUnknown_QueryInterface No interface for iid {00000019-0000-0000-c000-000000000046}
err:ole:CoGetClassObject class {24e669e1-e90f-4595-a012-b0fd3ccc5c5a} not registered
err:ole:CoGetClassObject no class object {24e669e1-e90f-4595-a012-b0fd3ccc5c5a} could be created for context 0x1
fixme:olepicture:OleLoadPictureEx (0x95f0dc,1086,1,{7bf80980-bf32-101a-8bbb-00aa00300cab},x=0,y=0,f=0,0x33f9e0), partially implemented.
fixme:olepicture:OLEPictureImpl_get_hPal unimplemented for type 3. Returning 0 palette.
fixme:olepicture:OleLoadPictureEx (0x960c4c,1086,0,{7bf80980-bf32-101a-8bbb-00aa00300cab},x=0,y=0,f=0,0x33f6f0), partially implemented.
fixme:olepicture:OLEPictureImpl_SaveAsFile (0x167ab8)->(0x185ff8, 0, (nil)), hacked stub.
fixme:olepicture:OleLoadPictureEx (0x966594,945,1,{00020400-0000-0000-c000-000000000046},x=0,y=0,f=0,0x33f524), partially implemented.
fixme:olepicture:OLEPictureImpl_Render Not quite correct implementation of rendering icons...
fixme:ole:RemUnknown_QueryInterface No interface for iid {00000019-0000-0000-c000-000000000046}
fixme:ole:CLSIDFromProgIDEx L"Excel.Application",0x33f40c: semi-stub
fixme:ole:CLSIDFromProgIDEx L"Excel.Application",0x33f404: semi-stub
fixme:heap:HeapSetInformation 0x110000 1 (nil) 0
fixme:heap:HeapSetInformation 0x110000 1 (nil) 0
fixme:heap:HeapSetInformation 0x110000 1 (nil) 0
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:thread:SetThreadIdealProcessor (0xc8): stub
fixme:thread:SetThreadIdealProcessor (0xd0): stub
fixme:thread:SetThreadIdealProcessor (0xd8): stub
fixme:thread:SetThreadIdealProcessor (0xe0): stub
fixme:heap:HeapSetInformation 0x110000 1 (nil) 0
fixme:win:EnumDisplayDevicesW ((null),0,0x33d5b8,0x00000000), stub!
fixme:win:EnumDisplayDevicesW ((null),0,0x33d5b8,0x00000000), stub!
fixme:wtsapi:WTSRegisterSessionNotification Stub 0x1011c 0x00000000
fixme:mscoree:get_runtime_info unsupported runtimeinfo flags 50
fixme:mscoree:CLRMetaHost_GetRuntime Unrecognized version L"v2.0.0"
fixme:mscoree:LockClrVersion (0x326ff57b 0x33428968 0x33428978): stub
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:time:GetCalendarInfoW flag CAL_NOUSEROVERRIDE used, not fully implemented
fixme:heap:HeapSetInformation 0x110000 1 (nil) 0
fixme:heap:HeapSetInformation 0x110000 1 (nil) 0
fixme:ole:RemUnknown_QueryInterface No interface for iid {00000019-0000-0000-c000-000000000046}
fixme:wtsapi:WTSRegisterSessionNotification Stub 0x200d6 0x00000000
err:ole:marshal_object object doesn't expose interface {7fd52380-4e07-101b-ae2d-08002b2ec713}, failing with error 0x80004002
err:ole:ClientIdentity_QueryMultipleInterfaces IRemUnknown_RemQueryInterface failed with error 0x80004002
err:ole:marshal_object object doesn't expose interface {37d84f60-42cb-11ce-8135-00aa004bb851}, failing with error 0x80004002
err:ole:ClientIdentity_QueryMultipleInterfaces IRemUnknown_RemQueryInterface failed with error 0x80004002
fixme:ole:serialize_param unhandled switch cases tattr->typekind 5
fixme:ole:deserialize_param unhandled switch cases tattr->typekind 5
fixme:storage:create_storagefile Storage share mode not implemented.
fixmeSHIsFileAvailableOffline (L"DEF Office2007.xls", 0x32ca80) stub
fixmeIPersistFile_fnSaveCompleted (0x3582630)->(L"DEF_Office2007.xls (7).lnk"): stub
fixme:ole:serialize_param unhandled switch cases tattr->typekind 5
fixme:ole:serialize_param Unhandled typekind 5
err:ole:TMStubImpl_Invoke Failed to stuballoc param, hres 80004005
fixme:ole:deserialize_param unhandled switch cases tattr->typekind 5
err:ole:deserialize_param Unhandled typekind 5
err:ole:deserialize_param failed to stuballoc in TKIND_RECORD.
err:ole:xCall Failed to unmarshall param, hres 80004005
fixme:time:GetCalendarInfoW Unimplemented caltype 2
fixme:time:GetCalendarInfoW Unimplemented caltype 2
fixme:time:GetCalendarInfoW Unimplemented caltype 2
fixme:time:GetCalendarInfoW Unimplemented caltype 2
fixme:wtsapi:WTSUnRegisterSessionNotification Stub 0x200d6
fixme:ole:DllDebugObjectRPCHook stub
fixme:advapi:RegisterEventSourceW ((null),L"Microsoft Office 12 Sessions"): stub
fixme:advapi:ReportEventW (0xcafe4242,0x0004,0x0000,0x00001b58,(nil),0x0006,0x00000000,0x33f2cc,(nil)): stub
fixme:advapi:DeregisterEventSource (0xcafe4242) stub
fixme:wtsapi:WTSUnRegisterSessionNotification Stub 0x1011c
err:ole:CoReleaseMarshalData IMarshal::ReleaseMarshalData failed with error 0x8001011d
fixme:msvcrt:__clean_type_info_names_internal (0x3a87296c) stub
fixme:msvcrt:__clean_type_info_names_internal (0x3be8a128) stub
fixme:msvcrt:__clean_type_info_names_internal (0x334d0b14) stub
fixme:msvcrt:__clean_type_info_names_internal (0x3b2cbf50) stub

[dimesio]

Your Wine version is over a year old. Try upgrading to the latest development release.

[udippel]

No difference with 1.7.34.

The second window [ABC](2) is already there at the end of:

$ wine [ABC].exe
fixme:ole:CoInitializeSecurity (0x468e08,-1,(nil),(nil),6,2,(nil),64,(nil)) - stub!
fixme:ole:RemUnknown_QueryInterface No interface for iid {00000019-0000-0000-c000-000000000046}
err:ole:CoGetClassObject class {24e669e1-e90f-4595-a012-b0fd3ccc5c5a} not registered
err:ole:CoGetClassObject no class object {24e669e1-e90f-4595-a012-b0fd3ccc5c5a} could be created for context 0x1
fixme:olepicture:OleLoadPictureEx (0x95f0dc,1086,1,{7bf80980-bf32-101a-8bbb-00aa00300cab},x=0,y=0,f=0,0x33f9e0), partially implemented.
fixme:olepicture:OLEPictureImpl_get_hPal unimplemented for type 3. Returning 0 palette.
fixme:olepicture:OleLoadPictureEx (0x960c4c,1086,0,{7bf80980-bf32-101a-8bbb-00aa00300cab},x=0,y=0,f=0,0x33f6f0), partially implemented.
fixme:olepicture:OLEPictureImpl_SaveAsFile (0x169c48)->(0x1839c0, 0, (nil)), hacked stub.
fixme:olepicture:OleLoadPictureEx (0x966594,945,1,{00020400-0000-0000-c000-000000000046},x=0,y=0,f=0,0x33f524), partially implemented.
fixme:olepicture:OLEPictureImpl_Render Not quite correct implementation of rendering icons...

and before I even select the Excel-file.

[dimesio]

You're still 4 versions behind; 1.7.38 was just released. Retest in that, and if the problem is still present (it probably will be), file a bug.

[udippel]

That's quite impossible for me, since I used the freshest one that i could get my hands on; from ppa:ubuntu-wine/ppa, just a few hours ago.
If a bug can only be filed for a version compiled from github, no, sorry, I can't.

[dimesio]

You can file one for 1.7.34, but you'll be asked to retest in current Wine.

Does this app have a free, legal download that someone else can use to test?

[udippel]

Thanks!

I'll make the executable available next week, and most of all, I'll prepare a simple demo Excel-sheet with which it interacts. Then a complete test case can be established, that can be run on Windows as well as wine.