Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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: 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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.