Issue 112233

Summary:

VBA won't run in 3.1

Product:

Calc

Reporter:

gcreegan <grcreegan>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Normal

Priority:

CC:

elish, issues

Version:

OOo 3.1.1 RC2

Keywords:

ms_interoperability, regression

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

4.1.0-dev

Developer Difficulty:

---

Attachments:

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.
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.