Ask Your Question

Macro Record Disappears When Recording to Open a Document [closed]

asked 2012-10-06 01:01:09 +0200

Frank1000 gravatar image

Hi, when I try to record a macro that opens a certain document, the little macro window disappears as soon as the document is opened ... thus not having recorded the macro.

Anyone who can help me in this ?

Regards, Frank

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:18:29.460950

2 Answers

Sort by » oldest newest most voted

answered 2012-10-06 01:57:37 +0200

w_whalley gravatar image

That topic has been addressed on an OpenOffice forum. I found their solution to work if I omitted the Empty()=Array() line, i.e.

sub Main
rem Empty() = Array()
testDoc=StarDesktop.loadComponentFromURL(FileName, "_blank",0,array())
end sub
edit flag offensive delete link more

answered 2012-10-06 04:50:39 +0200

Frank1000 gravatar image

thx, works cake. Probably my google phrase was to off to find the article ... but with that little coding I can achieve, I would have failed at the "rem" you've set anyways.

Looking for someone who can help me to set up some macros to write / retrieve from table and some formatting etc. for 1 hour skype session ...

Regards, Frank

edit flag offensive delete link more

Question Tools


Asked: 2012-10-06 01:01:09 +0200

Seen: 205 times

Last updated: Oct 06 '12