[Solved] Importing Macro & Short Cut

Discuss the word processor
Post Reply
User avatar
GridLok
Posts: 109
Joined: Thu Mar 08, 2012 12:54 pm
Location: Adelaide, South Australia

[Solved] Importing Macro & Short Cut

Post by GridLok »

I recently received an odt. document from a correspondent. I quickly discovered that the macros (and associated keyboard shortcuts) that work in documents I create, do not work in this one. Is there a simple way in which this can be arranged, or would I do better to create a new document on my computer and paste the contents of the 'foreign' item?

I did look existing instructions on importing macros but found them puzzling.
Last edited by GridLok on Sat Feb 02, 2019 2:15 am, edited 1 time in total.
"To find the right answer, first find the right question"
OpenOffice org. 4.1.4
OO414m5(Build:9788) - Rev. 1811857
2017-10-16 22:12:14 (Mon, 16 Oct 2017) - Darwin x86_64
Mac OS X 10.12.6 (Sierra)
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Importing Macro & Short Cut

Post by Zizi64 »

- where are stored the macros? (in your documents or in the MyMacros library?)
- what is the scope of the shortcuts? (document or global?)
- how (where from) did you open the received documents? (Never open them directly form a mail service. Download it before.)
- is the received document protected?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Importing Macro & Short Cut

Post by RoryOF »

The answer may be to open a blank document using your standard (macro included) template, then /File /Insert to insert the new document into it.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
GridLok
Posts: 109
Joined: Thu Mar 08, 2012 12:54 pm
Location: Adelaide, South Australia

Re: Importing Macro & Short Cut

Post by GridLok »

Thank you Zizi and Rory. Sorry about the delay in responding.

The document sent as an attachment to an email, is an .odt file and, after downloading it, I have been able to edit it and insert comments … so I don't think it is 'protected'.

I would like to get my macros and shortcuts organised, and thought I knew where they all are stored … clearly I do not. I have macros stored in My Macros, and they are accessible in all documents I have checked (so far) … so I would say they are "global". However, wanting to be able to: i) Change text colour to red; ii) Change text colour to red with a single line strikethrough (without using the "Changes" procedure, available in Edit) I created two macros and assigned keyboard shortcuts. They work exactly as I had hoped, but I cannot find where they are stored. I notice that in older .odt documents, the macros that I can see in My Macros all function, but not the two text altering ones … they only work in newer documents (presumably created since the macros were created).

Could I find out what I have created - might it be they are NOT macros after all, and where they are stored by examining the Customise > Keyboards listings?
"To find the right answer, first find the right question"
OpenOffice org. 4.1.4
OO414m5(Build:9788) - Rev. 1811857
2017-10-16 22:12:14 (Mon, 16 Oct 2017) - Darwin x86_64
Mac OS X 10.12.6 (Sierra)
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Importing Macro & Short Cut

Post by robleyd »

Look in Tools | Macros | Organise Macros under OpenOffice Basic
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
GridLok
Posts: 109
Joined: Thu Mar 08, 2012 12:54 pm
Location: Adelaide, South Australia

Re: Importing Macro & Short Cut

Post by GridLok »

Hello robleyd. I've looked where you suggested. Using (I hope) the 'correct' terminology, The macros that I can see, function in all documents.

WHOA! I'VE FOUND THE ISSUE!

The particular keyboard shortcut that I wanted to make available in the imported document ARE NOT MACROS! I finally remember now (my recall has never been readily available to me) … I attempted to record a macro … couldn't get it to work and, probably as a result of something I read in the OO Community Forums, resolved the situation by creating two character styles - then assigned a keyboard shortcut to each.

I have found how to make those two character styles available in documents not based on the template with which they are associated? (Aah! So true … to find the right answer, first find the right question) … by way of the OO Writer Users Guide - Styles and Formatting.

The question is then, can a macro be recorded (I have not the time, right now, to learn how to write a macro) that will perform the operation of applying a particular style to selected text?
"To find the right answer, first find the right question"
OpenOffice org. 4.1.4
OO414m5(Build:9788) - Rev. 1811857
2017-10-16 22:12:14 (Mon, 16 Oct 2017) - Darwin x86_64
Mac OS X 10.12.6 (Sierra)
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Importing Macro & Short Cut

Post by robleyd »

See if this Wiki article on copying and moving styles helps.
 Edit: Didn't fully read the question; I think you may already have that information. 
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
GridLok
Posts: 109
Joined: Thu Mar 08, 2012 12:54 pm
Location: Adelaide, South Australia

Re: Importing Macro & Short Cut

Post by GridLok »

Yes, I do have that info … although I had not yet read in detail, the particular section to which the Wiki linked. It has however, only just occurred to me that it is not possible to create a macro to make the text styling operation 'globally' available, since the purpose-created character styles are only available to documents created (however indirectly) from the template in which they were incorporated.

My little grey cells needed to be prodded!
"To find the right answer, first find the right question"
OpenOffice org. 4.1.4
OO414m5(Build:9788) - Rev. 1811857
2017-10-16 22:12:14 (Mon, 16 Oct 2017) - Darwin x86_64
Mac OS X 10.12.6 (Sierra)
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Importing Macro & Short Cut

Post by robleyd »

It's the Adelaide water...
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
GridLok
Posts: 109
Joined: Thu Mar 08, 2012 12:54 pm
Location: Adelaide, South Australia

Re: [Solved] Importing Macro & Short Cut

Post by GridLok »

Hmm. Currently about 80% from around your locality … no, I think it's probably innate … I was born this way! (lol)
"To find the right answer, first find the right question"
OpenOffice org. 4.1.4
OO414m5(Build:9788) - Rev. 1811857
2017-10-16 22:12:14 (Mon, 16 Oct 2017) - Darwin x86_64
Mac OS X 10.12.6 (Sierra)
Post Reply