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.â€Â
Creating number list in a WORD table
Moderators: JRL, Dorian (MJT support)
- Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
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
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
- Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
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.
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!
Bob
A humble man and PROUD of it!