Ask Your Question
0

Macro Record Disappears When Recording to Open a Document

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

Frank1000 gravatar image Frank1000
1 1 2 1

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

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted
1

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

w_whalley gravatar image w_whalley flag of United States
1606 10 24

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
filename="/home/bill/filename.odt"
filename=convertToURL(filename)
rem Empty() = Array()
testDoc=StarDesktop.loadComponentFromURL(FileName, "_blank",0,array())
end sub
link delete flag offensive edit
0

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

Frank1000 gravatar image Frank1000
1 1 2 1

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

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 95 times

Last updated: Oct 06 '12