Hi :) Ouch, sorry Andrew. I might have given him a link to the older book off-list. I take it the
http://www.pitonyak.org/AndrewMacro.odt is the newer one? Regards from Tom :) ________________________________ From: 20rdj04 <[email protected]> To: [email protected] Sent: Fri, 2 September, 2011 3:43:56 Subject: [libreoffice-users] Re: OOo vs LO I'm sorry, Andrew, but I don't know what you are talking about :( I have seen the abbreviations in the discussions, but I don't really know what they mean. I think OOo means Open Office.org, and I guess LO is for Libre Office. I have Libre. Thanks. -----Original Message----- From: "Andrew Douglas Pitonyak [via Document Foundation Mail Archive]" <[email protected]> Sent: Aug 27, 2011 7:29 PM To: 20rdj04 <[email protected]> Subject: Re: Macro Questions Are you looking at the version for OOo or for LO. This was very recently redone for LO. On 08/27/2011 12:36 AM, 20rdj04 wrote: > Hello, > > I am writing this off line, as I expect it will be overly long. > > I have a record, going back to 2008, of my daily blood testing. Over time, > I have changed the format of the lines. Today I am making the columns > narrower, and putting the columns into a different order. I used to > indicate the finger that I was using, and then the day, and then the date. > Blood pressure and time of day were next; and finally glucose reading and > pulse. Today I want day, date, glucose, time, b/p, and pulse. Since the > former record was pretty uniform, it was easy enough to write a macro, > ReArrange. > > Today I found > Chapter 13 > Getting Started with Macros > Using the Macro Recorder … and beyond > > On page 5, there are these 2 lines: > > 8) Select the Module1, or the new module that you created, and click Edit to > open the Integrated Debugging Environment (IDE). > 9) The IDE is a text editor for macros that allows you to edit and create > macros. Copy the macro into the IDE. > > Since I had already written 7 macros, by clicking on Tools, Macros, Record, > I don't understand these 9 lines. And I found Tools, Macros, Organize, > Basic, Run by going out a little farther. > > NOW for the important questions. Page 12, Running the Macro Quickly. > > I have modified Main thus: Sub Main > ReArrange > End Sub > > On the edit screen I find Run Basic. But of what value is that? To get > there I still need to press Alt-T, M, O, B. So what is the difference > between Enter (to Run) and clicking on Run Basic? I need a button (Run > Basic) or a function key (F5) on my main document window. (I know F5 > currently opens a Navigator window, whatever that is.) > > Also, near the end of ReArrange, I want to CALL TabSet, and align the > columns properly. Putting TabSet into ReArrange does nothing. I have also > tried copying the TabSet macro into ReArrange. This also does nothing. > > I know I'm doing something wrong, but what? And I know that I ask very few > questions. I expect you to read between the words, never mind the lines, > and answer the questions that I imply. :) > > The e-mail that I got had my earlier question properly formatted. > > Thanks, and bless you. > > > -- > View this message in context: http://nabble.documentfoundation.org/Macro-Questions-tp3288593p3288593.html > Sent from the Users mailing list archive at Nabble.com. > -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: [hidden email] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Macro-Questions-tp3288593p3290076.html To unsubscribe from Macro Questions, click here . </[email protected]> -- View this message in context: http://nabble.documentfoundation.org/Macro-Questions-tp3288593p3303147.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
