Issue 112233 - VBA won't run in 3.1
Summary: VBA won't run in 3.1
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1 RC2
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability, regression
Depends on:
Blocks:
 
Reported: 2010-06-09 03:56 UTC by gcreegan
Modified: 2014-01-16 17:08 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Spreadsheet with VBA and "buttons" to run scripts (41.00 KB, application/vnd.ms-excel)
2014-01-16 01:13 UTC, gcreegan 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.
Thanks,
George
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
Debian
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??

George
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
Rev.1558424
Win 7

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