asked on

Microsoft Word 2003 Template Macro does not autofill

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?

GrahamSkan

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.

Bi-Con

ASKER

View all files for Question ID: 22875036
https://filedb.experts-exchange.com/incoming/ee-stuff/4945-BiconFax.ziphttps://filedb.experts-exchange.com/incoming/ee-stuff/4939-FAX.zip
https://filedb.experts-exchange.com/incoming/ee-stuff/4941-FAX.zip

Direct link to your file
https://filedb.experts-exchange.com/incoming/ee-stuff/4939-FAX.zip

GrahamSkan

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?

Bi-Con

ASKER

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?

GrahamSkan

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.

Bi-Con

ASKER

Bi-Con

ASKER

Also. I am running Office 2003. The macro seems to work in Office 2000. I just now checked that.

GrahamSkan

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.

ASKER CERTIFIED SOLUTION

GrahamSkan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bi-Con

ASKER

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.

Bi-Con

ASKER

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