Jump to content
Macro Express Forums

Need Clarification on Incrementing Text Variables


Recommended Posts



I've been using this forum off and on for several weeks though this is the first I've posted. I've been using Macro

Express at work for between 4-5 years now, and just a few weeks ago I purchased a license for at home (I've

become somewhat addicted to ME).


Right now I'm attempting to develop a process for work that will help me collect, save, and retrieve information.

So far I've got a working set-up, but it's unbearably long.


Here's the basic gist:


I run Macro#1 which, through prompts and various screen-scraping, collects a series of information. The end of the

macro pastes all the information into a word document, which I then have to print out for hard-copy record-keeping.


Macro #2 (which I will eventually just append to the end of Macro #1), saves the text of the word document to a

text-file titled from one of the prompts of Macro #1.


Macro #3 is the bear. This macro finds the text-file, then processes line by line the information on it. Since I only

need the information which falls after the colon on each line, getting the important information from each line isn't

a problem at all. The problem is in the unmanageable length of the macro itself.


I built a test macro using my first, middle, and last names; my wife's names, our baby's first and middle names and

the month and year of her birth. It works fine, but it's only 10 lines of processed text, and yet the macro itself is

insanely long and is going to be an immensely overwhelming task to convert for work (which is going to need at least

twice as many processes).


Here's the part of the macro that I'm trying to make more manageable:



Link to comment
Share on other sites

Ok, I think I got it.


So often I see posts where the person in need figures out their problem but fails to post what it was that they

did to fix it... well I want to see what I can to do help anybody else who's having the same problem as me.


Here's the updated code:



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...