Replies

Each section is supposed to restart; however he would like the to say “on page 54” which may really be page 7 of Section 5. Does this make more sense?

The TOC references as actual pages, not section pages.

Hans,

That seems to do it. I’ll apply the code to all the templates that use the data file – and maybe now there won’t be so much frustration when using them.

I really apppreciate your time.

(Edited by Leanne S on 20-Mar-06 14:59. added additional info.)

Hans,

Yes, this version does exhibit the problems. I’m assuming when you open it, it then looks to your normal as you don’t have the associated template. Wonder what will happen if I open the doc and set it to look to normal……I’ve already tried so many options this morning I’m forgetting what I did.

I opened the file, set it to look at normal as the template, saved, closed, opened and all is ok. Now that leaves me with something else to think about. Is it possible when the document is saved that there could be code to have it look to normal; something that would work on different machines. I’ve got many offices/users who use the documents and I know they will never remember to change it.

Here’s merged doc.

Hans,

Edit links is grayed out. If I attach a sanitized document, should I attach the merged document or the template along w/Excel file?

I just modified the Excel file to only have 1 sheet then reset the template to look there but that didn’t make any difference.

While trying out the files this morning, I’ve reset the print area on the first sheet of the Excel file, and opened the Word template and reset it to look at the print area. While I still had the template open for the changes, I merged, saved, and reopened the merged document and Excel did not open. However, I then did file/new to access same template, merged, saved, closed and reopened and Excel did reopen as it didn’t lose the connection.

I checked and the document is merged.

In thinking about it over the weekend, I’m wondering if the fact that the workbook has more than 1 sheet to it makes a difference. The sheet I’m using is the first sheet. It was originally created in Excel 2000 but I migrated to 2003 for Excel but stayed at 2000 for Word. When using Excel 2003, I believe I was prompted for the “sheet” when selecting the data source. After having the problems, I went back to Excel 2000 and am only asked for ‘Entire Sheet’ or ‘Print Area’.

I’m using an excel workbook as the data source.

Thanks Hans, but mine doesn’t work like that or should I say like it used to. After I save/close the merged file, when reopen it the Excel file still opens and again asks if I want to save it.

Once again, you’ve come through for me. Both macros work perfectly.

The 2nd macro searches the document for highlighted E/A and changes to either Engineer or Architect then goes into each footer and replaces the date field code with an underline.

I’ll attach the document that this would be used on. Sorry I wasn’t more clear.

Again, thanks

Hans, I’ve got it working correctly now. Thanks again for all your help.

If I tab past the “Pick Central…” to choose “Pick Eastern…” my computer crashes. If I pick the “Pick Central…” it removes both the others. Is there a way that if I want “Pick Region…” that I can tab past the “Pick Central” to choose?

As always, thanks much.

Hans,

I cannot thank you enough for your help. It is MUCH appreciated.