[Bug 25762] Excel crashes trying to run macros

[wine-bugs at winehq.org]

http://bugs.winehq.org/show_bug.cgi?id=25762

David Sempsrott <dsempsro at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dsempsro at gmail.com

--- Comment #6 from David Sempsrott <dsempsro at gmail.com> 2012-05-12 12:13:41 CDT ---
Here's another scenario that might give some leads. I created a macro in Excel
2010 (using the 2003 file format .xls), and then tried to run it in Excel 2007
under Wine 1.4. It ran fine until it got to a statement that was supposed to
copy a range of data:

MySheet1.Range("A1").CurrentRegion.Copy MySheet2.Range("A1")

At this point Excel crashed. I reopened the workbook and modified the statement
as follows:

MySheet1.Cells(1, 1).CurrentRegion.Copy MySheet2.Cells(1, 1)

That worked. But then it came to the following code:

With MySheet2.Range("K1").Cells
    .Offset(0, -2).Value = "Status"
    .Offset(0, -1).Value = "Coverage"
    .Value = "Test case(s)"
    .EntireColumn.AutoFilter Field:=1, VisibleDropDown:=True
End With

And Excel crashed at the autofilter statement. Then I changed the
Range("K1").Cells to Cells(1, 11) and again it worked flawlessly. So it seems
fairly clear to me that the Range part is where the problem is -- although
apparently it's only methods, and not properties, that don't work.

I did get a complaint from Wine several times about not finding Windows Common
Controls:
fixme:actctx:parse_depend_manifests Could not find dependent assembly
L"Microsoft.Windows.Common-Controls" (6.0.0.0)

Sorry I'm not very experienced with Wine or VBA, but I hope that might give a
few hints as to where the problem might be.

-- 
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.