Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / July 2007

Tip: Looking for answers? Try searching our database.

Business Card Templates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pierre Goyette - 04 Jul 2007 22:06 GMT
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 - 04 Jul 2007 22:34 GMT
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?

> 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
[quoted text clipped - 9 lines]
>
> Thank You

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Pierre Goyette - 04 Jul 2007 22:48 GMT
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

> With the Avery doc open, did you try to look at the field code by pressing
> the keys ALT/F9 (function key)?
[quoted text clipped - 16 lines]
> >
> > Thank You
Russ - 04 Jul 2007 23:00 GMT
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?

> 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
[quoted text clipped - 30 lines]
>>>
>>> Thank You

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Pierre Goyette - 05 Jul 2007 01:56 GMT
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...

> 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
[quoted text clipped - 34 lines]
> >>>
> >>> Thank You
Russ - 05 Jul 2007 04:09 GMT
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?
> 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
[quoted text clipped - 43 lines]
>>>>>
>>>>> Thank You

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Pierre Goyette - 05 Jul 2007 11:48 GMT
I think I wasn't very clear in my post. I downloaded the following templates
for Office 2007:

http://www.avery.com/us/software/download_template_predesigned.jsp?catalogcode=W
EB01&downloadfile=/us/software/download_template_predesigned.jsp&softwarecode=13
610&campaignid=21130&software=Pre-Designed%2520Templates&file=/us/downloads/temp
lates/predesigned/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

> Pierre,
> I downloaded this file by itself. It opened with no macro warning. I am
[quoted text clipped - 51 lines]
> >>>>>
> >>>>> Thank You
Graham Mayor - 05 Jul 2007 14:47 GMT
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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I think I wasn't very clear in my post. I downloaded the following
> templates for Office 2007:
[quoted text clipped - 93 lines]
>>
>>  drsmN0SPAMikleAThotmailD0Tcom.INVALID
Russ - 06 Jul 2007 03:56 GMT
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.

> I think I wasn't very clear in my post. I downloaded the following templates
> for Office 2007:
[quoted text clipped - 88 lines]
>>>>>>>
>>>>>>> Thank You

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Doug Robbins - Word MVP - 05 Jul 2007 08:26 GMT
See the article "Graphics on Labels" on fellow MVP Graham Mayor's website at

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

Signature

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

>I downloaded some Avery business card templates. The single file downloads
>as
[quoted text clipped - 13 lines]
>
> Thank You
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.