We help IT Professionals succeed at work.

Microsoft Word 2003 Template Macro does not autofill

435 Views
Last Modified: 2016-08-29
I have a template file called FAX.DOT  In this template is a macro that runs when the file is opened.  The macro displays a window with various fields such as (To:, From:, Phone:, Fax:, ect.)  After filling in these fields and selecting OK the template used to auto fill a table as a fax cover sheet.  Now it does not autofill.  Any suggestions?
Comment
Watch Question

GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
That's hard to guess. I suppose that it opens a Userform and you click a command button (OK). Can you set a breakpoint in the code for the OK button?
If not (because you don't know how)  and it's not a standard template (delivered with Word), then I suggest that you zip it up and upload it here:

www.ee-stuff.com, using your EE credentials and we will have a look at it for you.
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
He,he.

That'll teach me for being so gung-ho. This template is an automatic conversion from Wordbasic. That does not make the task impossible, but it does slow the analysis down a bit.

The file date of the template  is the 1st October 2007, which suggests to me that it might have been edited then. Do you have a version with an older date than that, and have you tried it?

Also, is there someone in your company who might have made an attempt to tweak it a bit? We might have to ask what was the objective.

Fortunately, I have worked in Wordbasic and still have a Wordbasic manual, published when I was only 55 years old.

I will carry on analysis while you try to find the answer to those two queries. Will you be available over the weekend?

Author

Commented:
I can restore the file from tape from 4-30-06, but that is the oldest I have.  I may have messed with that file a bit, but I do not remember saving anything.  Unfortunately, I will not be availiable over the weekend.

Would you like the older version?
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
At the moment I can't see how it was expected to work in the sense that there is no code that is directly triggered by pressing the OK button.

To further explain, the dialog close action is captured in the variable called x.

If the OK button is pressed, x should = -1.

x is tested three times, twice for = 1 and once for = 0. 1 means the Defaults button, and 0 means'Cancel'

The first test for x = 1 happens before the dialog is closed, so I don't understand that yet.

Yes, please, do send the older file. It could well help.

Author

Commented:
Also.  I am running Office 2003.  The macro seems to work in Office 2000.  I just now checked that.
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
I have tried to guess how the macro is intended to work, and rebuilt the macro accordingly. It still uses Wordbasic, however.

I have uploaded the zipped tempalte for you to try. Let me know if it is near what you need.

Next, I'll test the original in Word 2000.
Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Let me try the logos.  I'll look to see if I can find the path.  If you know what my original path was supposed to be, then post it please.  But not finding the logos could solve another problem I am having as well.  Thanks, I will get back with you.

Author

Commented:
Changing the pathname for the logo templates WORKS!!!!!!!!!!!  Thank you SOOOO MUCH!!!!!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.