Macro Questions

users
#1

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

The e-mail that I got had my earlier question properly formatted.

Thanks, and bless you.

#2

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.

#3

Today is Saturday. I wrote the long letter on Friday. The
Main-ReArrange-End Sub routine now works. And the TabSet imbedded in
ReArrange is also working. I have both the sub and the line 'Call TabSet'
imbedded. I don't know which is working, but, on the other hand, who cares?

Thanks, and Bless you.

#4

Today is Saturday. I wrote the long letter on Friday. The
Main-ReArrange-End Sub routine now works. And the TabSet imbedded in
ReArrange is also working. I have both the sub and the line 'Call TabSet'
imbedded. I don't know which is working, but, on the other hand, who cares?

Thanks, and Bless you.

You care, and hopefully someone with the proper skill set will answer your questions. Everyone here is someone who wants to help, when they have some free time in their schedules. It can take a few days for the person with the right skill level to read your email and know what the answer it.

Please be patient. Macros are something that many of us do not do.

#5

Are you looking at the version for OOo or for LO. This was very recently redone for LO.

#6

What should I do when a linked value says True instead of the value it is supposed to reference or compute? I have a vlookup function that works partialy, the cell it is supposed to reference says true instead of the value it supposed to say. The cell it is supposed to reference is linked to a number field form.It works partially because some other values are derived from this and they turn out fine, still I have "True" where it should have a value.

Thanks,
Jack

#7

Can you upload an example file somewhere and give us the link here?
That would make it a lot easier to answer your question.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#8

Hi :slight_smile:
Even just copy&pasting the equation into a reply to this thread might help :wink:
Regards from
Tom :slight_smile:

#9

Hi :slight_smile:
Even just copy&pasting the equation into a reply to this thread might help :wink:
Regards from
Tom :slight_smile:

Might help but not necessarily, I think. Depends on where the problem
is. It's not always where it seems to be…

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#10

Do you think that this could be a cell format problem?
nvsoar

Hi :slight_smile:
Even just copy&pasting the equation into a reply to this thread might

help :wink:

Regards from
Tom :slight_smile:

Might help but not necessarily, I think. Depends on where the problem
is. It's not always where it seems to be…

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

________________________________
From: Johnny Rosenberg <gurus.knugum@gmail.com>
To: users@global.libreoffice.org
Sent: Sun, 28 August, 2011 11:52:49
Subject: Re: [libreoffice-users] Linked Cell says True instead of Showing

the

value

What should I do when a linked value says True instead of the value it

is

supposed to reference or compute? I have a vlookup function that works

partialy,

the cell it is supposed to reference says true instead of the value it

supposed

to say. The cell it is supposed to reference is linked to a number field

form.It

works partially because some other values are derived from this and they

turn

out fine, still I have "True" where it should have a value.

Thanks,
Jack

Can you upload an example file somewhere and give us the link here?
That would make it a lot easier to answer your question.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

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

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

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

#11

Am 29.08.2011 09:13, nvrk wrote:

Do you think that this could be a cell format problem?
nvsoar

Could be. Nobody can tell without any data nor formulas from the original poster. Unlike Excel, the boolean data type is just a subtype of the decimal type. The number format "BOOLEAN" displays any non-zero number as TRUE and all the rest as FALSE. In Excel there is a separate boolean data type, so TRUE and FALSE are never equal to any number.

#12

I'm sorry, Andrew, but I don't know what you are talking about :(&nbsp; I have seen the abbreviations in the discussions, but I don't really know what they mean.&nbsp; I think OOo means Open Office.org, and I guess LO is for Libre Office.&nbsp; I have Libre. Thanks. -----Original Message-----

#13

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

#14

http://www.pitonyak.org/book/

This [below] has the old "Book" listed, but the above one is the newest version I know of.

http://www.pitonyak.org/oo.php

#15

In
news:25865823.1314931421273.JavaMail.root@wamui-haziran.atl.sa.earthlink.net,
20rdj04 <20rdj04@earthlink.net> typed:

I'm sorry, Andrew, but I don't know what you are talking
about :(&nbsp; I have seen the abbreviations in the
discussions, but I don't really know what they
mean.&nbsp; I think OOo means Open Office.org, and I
guess LO is for Libre Office.&nbsp; I have Libre. Thanks.
[via Document Foundation Mail Archive]"
&lt;ml-node+3290076-332381919-395149@n3.nabble.com&gt;
Sent: Aug 27, 2011 7:29 PM
To: 20rdj04 &lt;20rdj04@earthlink.net&gt;
Subject: Re: Macro Questions

Are you looking at the version for OOo or for LO. This
was very recently
redone for LO.
&gt; Hello,
&gt;
&gt; I am writing this off line, as I expect it will be
overly long. &gt;
&gt; I have a record, going back to 2008, of my daily
blood testing. &nbsp;Over time, &gt; I have changed the
format of the lines. &nbsp;Today I am making the columns
&gt; narrower, and putting the columns into a different
order. &nbsp;I used to &gt; indicate the finger that I
was using, and then the day, and then the date. &gt;
Blood pressure and time of day were next; and finally
glucose reading and &gt; pulse. &nbsp;Today I want day,
date, glucose, time, b/p, and pulse. &nbsp;Since the &gt;
former record was pretty uniform, it was easy enough to
write a macro, &gt; ReArrange. &gt; &gt; Today I found
&gt; Chapter 13 &gt; Getting Started with Macros
&gt; Using the Macro Recorder b& and beyond
&gt;
&gt; On page 5, there are these 2 lines:
&gt;
&gt; 8) Select the Module1, or the new module that you
created, and click Edit to &gt; open the &nbsp;Integrated
Debugging Environment (IDE). &gt; 9) The IDE is a text
editor for macros that allows you to edit and create &gt;
macros. Copy the macro into the IDE. &gt;
&gt; Since I had already written 7 macros, by clicking on
Tools, Macros, Record, &gt; I don't understand these 9
lines. &nbsp;And I found Tools, Macros, Organize, &gt;
Basic, Run by going out a little farther. &gt;
&gt; NOW for the important questions. &nbsp;Page 12,
Running the Macro Quickly. &gt;
&gt; I have modified Main thus: Sub Main
&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ReArrange &gt; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; End Sub &gt; &gt; On the edit
screen I find Run Basic. &nbsp;But of what value is that?
&nbsp;To get &gt; there I still need to press Alt-T, M,
O, B. &nbsp;So what is the difference &gt; between Enter
(to Run) and clicking on Run Basic? &nbsp;I need a button
(Run &gt; Basic) or a function key (F5) on my main
document window. &nbsp;(I know F5 &gt; currently opens a
Navigator window, whatever that is.) &gt; &gt; Also, near
the end of ReArrange, I want to CALL TabSet, and align
the &gt; columns properly. &nbsp;Putting TabSet into
ReArrange does nothing. &nbsp;I have also &gt; tried
copying the TabSet macro into ReArrange. &nbsp;This also
does nothing. &gt; &gt; I know I'm doing something wrong,
but what? &nbsp;And I know that I ask very few &gt;
questions. &nbsp;I expect you to read between the words,
never mind the lines, &gt; and answer the questions that
I imply. &nbsp;:slight_smile: &gt; &gt; The e-mail that I got had my
earlier question properly formatted. &gt; &gt; Thanks,
and bless you. &gt; &gt;
&gt; --
&gt; View this message in context:
http://nabble.documentfoundation.org/Macro-Questions-tp3288593p3288593.html
&gt; Sent from the Users mailing list archive at
Nabble.com. &gt; --
Andrew Pitonyak
My Macro Document:
http://www.pitonyak.org/AndrewMacro.odt Info: &nbsp;
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 .
&lt;/ml-node+3290076-332381919-395149@n3.nabble.com&gt;

--
View this message in context:
http://nabble.documentfoundation.org/Macro-Questions-tp3288593p3303147.html
Sent from the Users mailing list archive at Nabble.com.

&nbsp; is a non-breaking space. Used to put multiple spaces in one place
where normally you can't get it to show more than one space.

#16

The email references Chapter 13 from the documentation project. I believe that LibreOffice recently redid this chapter. I was not certain which chapter had been used.

It had not occurred to me that there was a reference to either AndrewMacro.odt or OOME_3_0.odt