Generating coversheets using inputboxes

gmayor · #1 05-26-2019, 02:50 AM

It writes ABC and 123 because Greg hard coded that into the template code rather than the strName and strNum from the userform, no doubt while testing if his code worked to populate the controls in the loop (the incrementing date being the important bit of the code), and then forgot to replace the fixed texts with the string variables. It's easily done.

Code:

      .ContentControls(1).Range.Text = "ABC"
      .ContentControls(2).Range.Text = "123"

The date format is set in the date content control properties, but once changed the autotext entry also has to be updated as that contains a copy of the template body with the three content controls.

See attached

alecambo · #2 05-31-2019, 06:55 AM

Quote:

Originally Posted by gmayor

It writes ABC and 123 because Greg hard coded that into the template code rather than the strName and strNum from the userform, no doubt while testing if his code worked to populate the controls in the loop (the incrementing date being the important bit of the code), and then forgot to replace the fixed texts with the string variables. It's easily done.

Code:

      .ContentControls(1).Range.Text = "ABC"
      .ContentControls(2).Range.Text = "123"

The date format is set in the date content control properties, but once changed the autotext entry also has to be updated as that contains a copy of the template body with the three content controls.

See attached

Thanks gmayor.
I forgot to add that between the store name and date I need to have a day of the week for staff (i.e. "Tuesday")

I would assume that this would be inserted as an aforementioned input - ".ContentControlsi.ContentControls(1).Range.Te xt = sDayName", but it doesn't seem to work. Is there something I'm missing here?

Thanks again for your help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
generating a calendar	jimmy2016	Mail Merge	2	09-28-2016 11:09 PM
Generating a Letter	Shanna86	Word	9	09-29-2015 09:11 PM
generating a number in Word	John P	Word	1	05-31-2012 10:29 PM
Generating Buy/Sell signals accordingly...	babapusy	Excel	0	04-14-2012 10:11 AM
MS Word 2003 – Generating a ToC	krazykasper	Word	1	04-29-2009 02:44 PM