Creating number list in a WORD table

General Macro Scheduler discussion

Moderators: JRL, Dorian (MJT support)

Post Reply
wdc
Junior Coder
Posts: 33
Joined: Mon Jun 09, 2003 1:37 am
Location: Chevy Chase Maryland

Creating number list in a WORD table

Post by wdc » Tue Jun 08, 2004 11:02 am

I am returning to MacroScheduler after months of inactivity and I find that I have forgotten basic things I used to know. For example:

Using WORD97 I have built a long table (with 750 rows). Column 1 is titled “Index Number.â€Â

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Tue Jun 08, 2004 1:21 pm

Could look something like this:
Let>Max=750
Let>Line=0

Tab>to the top cell to be modified

Label>Start
Add>Line,1
Send>%Line%
PRESS DOWN
If>Line=Max,End,Start

Label>End
Note, this is untested quick and dirty concept.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

wdc
Junior Coder
Posts: 33
Joined: Mon Jun 09, 2003 1:37 am
Location: Chevy Chase Maryland

Post by wdc » Wed Jun 09, 2004 2:11 am

Bob: Thanks so much. I did not realize just how much I have forgotten. For example --- in your script

Quote:
Let>Max=750
Let>Line=0

Tab>to the top cell to be modified

Label>Start
Add>Line,1
Send>%Line%
PRESS DOWN
If>Line=Max,End,Start

Label>End

How do I insert the line Tab>to the top cell to be modiified? What is the address of that cell (say the first column, first row in C:\\mytable.doc)?

In general, how does one go about copying and then editing a script (say yours) into a macro of my own?

FWIW, my MacroScheduler is Version 6.2.3.

I really appreciate your hand-holding here. … wdc

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Wed Jun 09, 2004 2:38 am

To get to the first cell of your table, beneath the top row of labels, you may have to do something like this:

Open Word
Wait Word Open and Ready
Use Word shortcust to GOTO Table name. The will get you to top left cell of table.
From there, do Press Down

Let>RP_WAIT=1
Run Program>Word c:\mytable.doc
WaitWindowOpen>Word*
WaitReady>1
Send>commands to Word as noted next
The following commands are in Word2000, and should be sent using Send and/or Hot Keys:
Go To Table = From the Main Menu, Edit, Goto (CTL_G),Goto Tab(ALT-G),,
Goto (ALT-O), Table(T), Enter Table Number (ALT-E), Enter table number, using Send>(number of table)
Close Word
End Macro

=================================
To get script from forum into Macro Scheduler:
1. Start a new macro and open macro editor.
2. Highliight and copy to clipboard the script on forum.
3. Paste into Editor.
4. On the Editor Main Menu, use Edit, Show All Characters, and Remove Trailing Spaces. Trailing Spaces on lines may cause some problems with variables and labels.
5. Save the Macro script.

=================================

Note that syntax above is untested and not correct, just trying to give you a quick and dirty general skeleton of commands to put together.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts