Bug 57654

Created attachment 77526 [details]
Document after crah

@Joel: This is a major bug with some subbugs:
- VBA code can't be executed [Okay this is the main bug and quite obvious]
-- APPCRASH, when clicking play (Everything is fine, when opening it on Excel
-- Document restore needs a long time to save the document for recovery (2-3 min on a i5-2500k machine)
-- Compare the content of the .xls before and after the crash INFORMATION got lost

Version:

OS: Win 7 x64

Version LibreOffice 3.4.5 OOO340m1 (Build:502)[Portable version] reports a "BASIC-Syntaxerror: Unexpected symbol: Get" [Translated from German.] Line: 
Get myFileId, , myArr() AND does not crash -> Regression

[BTW: OO.org 3.2 does not crash as well]
opening BugPrio chart: Critical -> High + MAB to Critical -> medium
More in the next comment

BTW: Version: Version: 4.1.0.0.alpha0+
Build ID: 61d1f8f237bb45901de9c8016ea48fab1c3570d [missing in last comment]

Tried with 3.6.6.2: "Basic-Runtimeerror '57' (Original) Geräte-E/A-Fehler [de] Device -i/O-Error and a little movement, but no sound at all [Except of an error sound ~every second and (when the video stops) continueing for a long time...

So Latest working version 3.6.6.2 IMHO broken in 4.0 First tested broken "4.0.2.2"
Compatibility problem since time of OO.org

@Joel: read the previous comment as well. It is quite a major bug and a regression, with 4.0 data loss... THIS bug has everything (Thinking of HardHack)

I need your input here.... [Reason for needinfo]

I know almost nothing about macros but I wonder how it can work, since:
1) we can see this:
 Private Sub Workbook_Open()

Dim tmpPath As String

Sheet1.Activate
tmpPath = ThisWorkbook.Path
AudioFile = tmpPath & "\ACDC.wav"

which "ACDC.wav"?

2) Load module
impFile = ThisWorkbook.Path & Application.PathSeparator & _
          "logo-outline.txt"
impFile = ThisWorkbook.Path & Application.PathSeparator & _
          "12fps-45sec-cut.txt"

where are these files?

Noël: put you in cc, you might be interested

There are "embedded" in the .xls (at least the music file). You can see it, when opening it in Excel...

The regression is the crash...

Feel free to leave a comment, if you need additional information :)

I would have tried to retrieve a bt but I think it should be a Windows only bug since we can read this "winmm.dll" in the macro. I'm too lazy to try to retrieve a bt on Windows even with https://wiki.documentfoundation.org/BugReport#How_to_get_a_backtrace_on_Windows, I must be too accustomed with Linux way :-)

But Jesus must know how since he created a video tuto (see http://www.youtube.com/watch?v=fppBTs215yc)
You may also put bfoman in cc (he's already retrieved a lot of bts on Windows)

Finally, perhaps try to run the macro step by step to know exactly which instruction triggers the problem/crash.

Checked with:
LO 4.0.2.2
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

There is no LO crash, but simple break in ExtractWAV(). Error message is: 
BASIC runtime error.
'57'
Device I/O error.

in line:
Open tmpFileName For Binary As #myFileId

When this file is first opened in Excel 2010 ACDC.wav is extracted into current dir. 
When file is available all of this is working in LibreOffice - music is played and video rendered (quite slow).

Marking as NEW - macro execution error confirmed, all details seems to be delivered.

Hey Jesus,

the test file no longer exists. No more debugging possible.

Can you please provide the file in question?

This is NEEDINFO.