Business Card Templates

[Pierre Goyette]

I downloaded some Avery business card templates. The single file downloads as
a ".doc" file. It adds a new ribbon item called "Avery Template". The page
contains what I think are fields but I can't seem to display them or modify
them. There does not appear to be any macros inside the file although I know
there are since the new buttons on the ribbon don't work unless you enable
macros.

I want to change the template and modify the buttons but I can't figure out
how this document is working.

Does anyone have any ideas?

Thank You

 

[Russ]

With the Avery doc open, did you try to look at the field code by pressing
the keys ALT/F9 (function key)?
And if they loaded any macros, you can run them by the menu
Tools/Macro/Macros...
Or maybe they added a new menu or toolbar button. Did you read the
instructions at the download site?

 

[Pierre Goyette]

I figured out that if I enabled the Developer tab in the ribbon, I can see
that there is some VBA code attached in the file. However, the Avery buggers
password protected the code so I cannot see what they did and cannot modify
it. So, I think I'm screwed if I want to use the Avery template as something
to use as a base for my own modifications.

I still don't know how they change the fields given that Alt-F9 doesn't show
any fields...

Thanks,

Pierre

 

[Russ]

If they sent you a .dot template file, then you may have to File/'Open' the
..dot file itself in word, to see the macro code. Does it actually ask for a
password?

 

[Pierre Goyette]

It is a ".doc" file. But if I click on the Developer Tab and then click on
"Visual Basic", I get to the VBA editor. In there, there is a
"AveryWord2007Template" project which is password protected. I'm sure if I
could see that, I could figure out exactly what they are doing but it seems
they want to protect a few lines of basic...

 

[Russ]

Pierre,
I downloaded this file by itself. It opened with no macro warning. I am
using MacWord 2004. It didn't have any macros. I was able to manipulate the
autoshapes within each card.
http://www.avery.com/us/downloads/templates/predesigned/c_2208_us0_biz_cards
_10psht.doc

What link did you use?

 

[Doug Robbins - Word MVP]

See the article "Graphics on Labels" on fellow MVP Graham Mayor's website at

http://www.gmayor.com/graphics_on_labels.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Pierre Goyette]

I think I wasn't very clear in my post. I downloaded the following templates
for Office 2007:

http://www.avery.com/us/software/do...redesigned/c_2563_us0_bizcard_10psht_frt.docm

I enable macros when I open this file. All ok. It adds a new ribbon tab
called "Avery Template". I use the "All Cards the Same" button. All is fine.
Their template works fine.

But what I wanted was to change the "All Cards the Same" dialog to rename
fields and move things around on the page. Can't seem to do this since they
apparantly locked the VBA code for this file.

Also, when I view the file, I can't figure out what they are using as
placeholders for each field. If I had an idea, I could simply rewrite some of
the code from scratch.

While I'm on the subject, is there some sample code out there which shows
how Avery achieved this nice extension to Office 2007 ? I mean how they
automatically attach themselves to the Ribbon when the document is opened?

Thanks,

Pierre

 

[Graham Mayor]

This is only a simple card layout. If all you want to do is edit the content
of the cards whilst maintaining the same general format, edit the first cell
then use the macro at http://www.gmayor.com/graphics_on_labels.htm to
transfer the changes to all the other cells. The macros are superfluous.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Russ]

Yes, there is a difference between a .doc and .docm file.
http://filext.com/file-extension/DOCM
I don't know when my MacWord 2004 will have converters to open the new Word
xml files.