Bug 78950 - Microsoft vba script doesn't work since 4.1.x (BASIC runtime error. '91' Object variable not set.)
Summary: Microsoft vba script doesn't work since 4.1.x (BASIC runtime error. '91' Obje...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
PreBibisect
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-20 07:44 UTC by sunweb
Modified: 2015-02-19 15:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
XLS with macros (58.50 KB, application/vnd.ms-excel)
2014-05-20 07:44 UTC, sunweb
Details

Note You need to log in before you can comment on or make changes to this bug.
Description sunweb 2014-05-20 07:44:14 UTC
Created attachment 99393 [details]
XLS with macros

Hi. VBA script that was made with MS office don't work starting with Libre Office 4.2.x 

It did work before with Libre Office 4.1.x

I'll add attachment. You'll get an error on document opening and any other function in there.
Comment 1 sunweb 2014-05-20 07:58:08 UTC
Sorry one mistake

It did work before with Libre Office 4.0.x and starting with 4.1.x stopped working.
Comment 2 Joel Madero 2014-06-01 04:42:16 UTC
Generally we don't support MS VBA - we recommend you migrate your macros to basic (or python). Since this is a regression I'll at least see if I can bibisect the problem.
Comment 3 sunweb 2014-06-02 07:34:36 UTC
(In reply to comment #2)
> Generally we don't support MS VBA - we recommend you migrate your macros to
> basic (or python). Since this is a regression I'll at least see if I can
> bibisect the problem.

Thats not my script, i use whats builtin LibreOffice, basic. But other companies are tend to send files with VBA only as they're using MSO. I understand that its not top priority but if you could fix regression it would be very helpful.
Comment 4 Joel Madero 2014-06-02 15:39:45 UTC
I'm getting errors opening the file all the way back to 3.6 - the "run time error"

Also clicking on at least a couple of the macro buttons I get errors all the way back to 3.6
Comment 5 Joel Madero 2014-06-02 15:43:57 UTC
Did further testing all the way back to 3.5 beta and see the error every single version. Cannot confirm that this is a regression.
Comment 6 sunweb 2014-06-16 09:30:07 UTC
I am terribly sorry. I didn't check for myself(and trusted co-wroker's words) before but now i've ended up with same results as you. Won't happen again. Hope i am not going to be banned from bugtracker for this.

It appears that the only thing changed is that VBA script that loads now even though the settings doesn't have directory marked as trusted in macros security settings. And that caused a problem to work with data because each time pressing on a cell would start script that doesn't work.

I am really sorry, thanks for time.