Issue 112233

Summary: VBA won't run in 3.1
Product: Calc Reporter: gcreegan <grcreegan>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues
Version: OOo 3.1.1 RC2Keywords: ms_interoperability, regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Description Flags
Spreadsheet with VBA and "buttons" to run scripts none

Description gcreegan 2010-06-09 03:56:19 UTC
I just upgraded from version 3.0 to 3.1 and now my Excel spreadsheet VBA macros won't run any more.  I 
get an error box which says "A scripting framework error has occurred..."  I can run the macros manually 
but not from their "assigned" control buttons.  This used to work perfectly until 3.1.
Comment 1 Edwin Sharp 2014-01-15 18:30:34 UTC
Please attach spreadsheet.
Comment 2 gcreegan 2014-01-16 01:13:58 UTC
Created attachment 82298 [details]
Spreadsheet with VBA and "buttons" to run scripts

Good luck. It's been a long time but I hope you can get this to work on newer versions of Calc.  So far I've been sticking with 3.0.  Please let me know it you get the file OK.
Comment 3 Edwin Sharp 2014-01-16 06:36:11 UTC
Thank you.

Can not open file.
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Opens in Calligra Sheets 2.7.5
Comment 4 gcreegan 2014-01-16 17:00:33 UTC
All I can tell you is that the file I sent you (Database with VBA.xls) opens and runs in Neooffice 3.0, MS Excel 2000 and Libreoffice 3.5.  I can't imagine why you have problems with it.  Should I have sent it as an "attachment" instead of following the link on the bug report screen?  Would that have made a difference?  Let me know what more I can do.

I just now downloaded the file I sent you from the bugzilla page and I have no problem opening it.  So, I looks like you got it intact.  By the way, the sheet has macros so you'll need to have that feature enabled in your security settings.  Maybe that was the problem??

Comment 5 Edwin Sharp 2014-01-16 17:08:06 UTC
Attachment 82298 [details] performs OK in Excel 2010.
Attachment 82298 [details] opens OK but can't run macros in
AOO410m1(Build:9750)  -  Rev. 1558424
Win 7

Apologies for not testing in both operating systems at the same time.