Re: [libreoffice-users] Macro Questions

It looks to me that your question is about clarification with the 
documentation written by our Documentation Writers.  Sometimes things 
are clear to one, when it is not clear to others.  I am not a "Macro 
person" so I cannot help you, but these things do happen from time to time.

I sure admire your keeping your testing records for so many years.  With 
several family members testing 2 and 3 times a day to deal with knowing 
their proper injection doses, It can be important to see the history of 
your tests and maybe the doses of fast acting and slower acting meds 
injected.

----------------------------------------------------------------------------------------
This document may be of use to you in writing Macros.

OpenOffice.org Macros Explained - Andrew D. Pitonyak - third edition - 
July 26, 2011

He has stated that there should be a LibreOffice version in the future, 
but he initially wrote this when LibreOffice was not available.  I have 
been told that this is the best documentation for this subject material.

http://libreoffice-na.us/English/documentation-PDF-and-other/Base/OOME_3_0.pdf

This document is 495 pages long, so it might have some useful 
information about Macros.

I know some people have problems with referring LibreOffice users to OOo 
documentation, but sometimes there are not any related documents written 
specifically for LO yet, so we have to use the original OOo version 
until they get re-written 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.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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