http://bugs.winehq.org/show_bug.cgi?id=25762
David Sempsrott dsempsro@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |dsempsro@gmail.com
--- Comment #6 from David Sempsrott dsempsro@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.