A
Al Austin
I need some help in figuring out how to accomplish the
following programming technique. I would be willing to pay
for the knowledge to figure out how this is done so that I
can create the menu system and the associated macros to
direct the selection process. Your help is appreciated. I
don't want to become come a VB programmer, I just need the
exact procedure to get over 5000 autotext entries into
variable reports. The autotext is already written. I also
don't know how to decipher the macro language. Combo boxes
or some other "ActiveX control" feature might work.
The application is related to creating a report of items
that would be presented to a client. The actual
application would different, however the premise would be
the same. Since there are thousands of possible auto text
entries to be placed in a template file I will need to add
each one. However going through a menu system is better
than selecting each entry from a single menu such as MS
Word's AutoText Tool bar. The following documents the
structure of a menu tree that can be used to add Auto text
into a standard document via bookmarks, txt file submenus
and a template containing the actual Auto text entries and
macros.
Icon in MS Word Menu Bar (loading template to a blank
document and activating macros)
|
| | | |
| | |
option 1 option 2 option 3
option 4 option 5
option 6 option 7
shoes shirts pants socks
underwear hats misc
(Each of these options would then appear on the main MS
word menu bar. When the user selects an option item then
the macro would allow a popup window that has menu items
other items listed. These items on the menu would then
lead to other sub menus. For example: the menu structure
could be representative of a retail clothing store. After
initializing the top selection by starting the store's
template the department selections would appear on the
menu bar. The user would then select an option related to
a particular department. Each entry in the following
submenu could be read from a txt file. The rest of the
tree structure would eventually lead to an auto text entry
that would be inserted into the document file at a
particular location based on the book marked locations as
defined by the template.)
| Shoe Sub menu
| | |
option 1 option 2 option 3
Boots Loafers Sandals etc
(this level of the menu system would read something like
this within the shoes.txt file which is represented below.
Other txt files would have other descriptions for the
other categories such as listed in the menu bar for
shirts, pants, socks, underwear, hats, misc)
Boots
Loafers
Sandals
Sneakers
High Heels
Wing Tips
Etc
| Boots Sub menu
| | | |
| | |
option 1 option 2 option 3
Square Toe Pointed Toe Rounded Toe etc
(this level of the menu system would let the user be more
specific about boots. The Boots sub menu items again would
be read from a text file that would read something like
this within the boots.txt file which is represented below.
Square Toe
Pointed Toe
Rounded Toe
The patterns can stop here or go to deeper levels.
Eventually the Auto text entry would be inserted into the
template at the predefined location for a report. A
typical Auto text entry would be a precisely worked
paragraph defining an item such as "Square Toed Brown
Boots manufactured by the Fry company in sizes 7 to 13
selling for under $60.00. The actual auto text would
actually be more descriptive and considerably longer at
approximately 3 to 7 sentences. Thanks for your help.
Contact me at (e-mail address removed) if you have any questions. I
know that this is also an application for a database and
its reporting format, but it is not my objective to use a
database, since many applications on them are inflexible
(rigid) as compared with a word processor such as MS Word.
Al Austin (281) 480-4606
following programming technique. I would be willing to pay
for the knowledge to figure out how this is done so that I
can create the menu system and the associated macros to
direct the selection process. Your help is appreciated. I
don't want to become come a VB programmer, I just need the
exact procedure to get over 5000 autotext entries into
variable reports. The autotext is already written. I also
don't know how to decipher the macro language. Combo boxes
or some other "ActiveX control" feature might work.
The application is related to creating a report of items
that would be presented to a client. The actual
application would different, however the premise would be
the same. Since there are thousands of possible auto text
entries to be placed in a template file I will need to add
each one. However going through a menu system is better
than selecting each entry from a single menu such as MS
Word's AutoText Tool bar. The following documents the
structure of a menu tree that can be used to add Auto text
into a standard document via bookmarks, txt file submenus
and a template containing the actual Auto text entries and
macros.
Icon in MS Word Menu Bar (loading template to a blank
document and activating macros)
|
| | | |
| | |
option 1 option 2 option 3
option 4 option 5
option 6 option 7
shoes shirts pants socks
underwear hats misc
(Each of these options would then appear on the main MS
word menu bar. When the user selects an option item then
the macro would allow a popup window that has menu items
other items listed. These items on the menu would then
lead to other sub menus. For example: the menu structure
could be representative of a retail clothing store. After
initializing the top selection by starting the store's
template the department selections would appear on the
menu bar. The user would then select an option related to
a particular department. Each entry in the following
submenu could be read from a txt file. The rest of the
tree structure would eventually lead to an auto text entry
that would be inserted into the document file at a
particular location based on the book marked locations as
defined by the template.)
| Shoe Sub menu
| | |
option 1 option 2 option 3
Boots Loafers Sandals etc
(this level of the menu system would read something like
this within the shoes.txt file which is represented below.
Other txt files would have other descriptions for the
other categories such as listed in the menu bar for
shirts, pants, socks, underwear, hats, misc)
Boots
Loafers
Sandals
Sneakers
High Heels
Wing Tips
Etc
| Boots Sub menu
| | | |
| | |
option 1 option 2 option 3
Square Toe Pointed Toe Rounded Toe etc
(this level of the menu system would let the user be more
specific about boots. The Boots sub menu items again would
be read from a text file that would read something like
this within the boots.txt file which is represented below.
Square Toe
Pointed Toe
Rounded Toe
The patterns can stop here or go to deeper levels.
Eventually the Auto text entry would be inserted into the
template at the predefined location for a report. A
typical Auto text entry would be a precisely worked
paragraph defining an item such as "Square Toed Brown
Boots manufactured by the Fry company in sizes 7 to 13
selling for under $60.00. The actual auto text would
actually be more descriptive and considerably longer at
approximately 3 to 7 sentences. Thanks for your help.
Contact me at (e-mail address removed) if you have any questions. I
know that this is also an application for a database and
its reporting format, but it is not my objective to use a
database, since many applications on them are inflexible
(rigid) as compared with a word processor such as MS Word.
Al Austin (281) 480-4606