• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

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?
0
Bi-Con
Asked:
Bi-Con
  • 6
  • 5
1 Solution
 
GrahamSkanCommented:
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.
0
 
GrahamSkanCommented:
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?

0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
Bi-ConAuthor 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?
0
 
GrahamSkanCommented:
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.
0
 
Bi-ConAuthor Commented:
Also.  I am running Office 2003.  The macro seems to work in Office 2000.  I just now checked that.
0
 
GrahamSkanCommented:
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.
0
 
GrahamSkanCommented:
OK.
I noticed that your macro inserts a different logo graphic depending on which of three 'ICE' choices is made.

In a copy of your template, I changed the path for these graphics to point to three on my own system.

I have just gone back to your original template and discovered that the missing image causes the symptom that you describe.

You have an On Error goto Bye.

When an error occurs, the number is not tested, so all that happens is that the rest of the code is skipped. That includes the loading of the 'To' information.

I suspect that the graphic files are missing or not reachable on your new system.

I also suggest that error trapping is removed. The only effect that it has at the moment is to silently supress the error message.
0
 
Bi-ConAuthor 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.
0
 
Bi-ConAuthor Commented:
Changing the pathname for the logo templates WORKS!!!!!!!!!!!  Thank you SOOOO MUCH!!!!!
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now