PC Review


Reply
Thread Tools Rate Thread

Auto-save document to specific location (dir) and with spec. name?

 
 
oystlars@gmail.com
Guest
Posts: n/a
 
      27th Feb 2006
Situation:

- Have a template that needs to be saved to a specific location and
with a specific filename after use. How?


Name and location:


c:\referees\060222 Personalmeeting.doc


06 = year
02 = month
22 = day


There are a lot of people saving these documents, but hardly any know
how a file structure is organized.. Problem!


Thanks,
Øystein

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Q29veg==?=
Guest
Posts: n/a
 
      27th Feb 2006
Hi Øystein,

Record any macro, say record clicking the B-button on the Standard toolbar,
and be sure to choose the template under 'Store macro in'.
Choose Tools | Macro > Macro's..., select your macro and choose Edit. The
VBA-editor opens.
Replace the entire macro by the following:

Sub AutoNew()
Dim dlg As Dialog

Set dlg = Application.Dialogs(wdDialogFileSaveAs)
With dlg
.Name = "C:\referees\" & Format(Date, "yyMMdd") & "
pesonalmeeting.doc"
.Show
End With

End Sub

Click the Save button in the VBA editor to save the template. As soon as a
user makes a new document based on the template, the SaveAs-dialog appears,
suggesting the standard name.

Note that if "C:\referees" does not exist, the macro suggests to save the
file in My Documents.

Good luck,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"(E-Mail Removed)" wrote:

> Situation:
>
> - Have a template that needs to be saved to a specific location and
> with a specific filename after use. How?
>
>
> Name and location:
>
>
> c:\referees\060222 Personalmeeting.doc
>
>
> 06 = year
> 02 = month
> 22 = day
>
>
> There are a lot of people saving these documents, but hardly any know
> how a file structure is organized.. Problem!
>
>
> Thanks,
> Øystein
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto save Spread sheet as htm to a specific location Saving is tough Microsoft Excel Misc 0 29th Oct 2008 03:46 PM
Save to specific location LB79 Microsoft Excel Misc 2 25th Aug 2005 11:02 AM
Picture/Fax Viewer: Fail to Save to Spec Location =?Utf-8?B?cGFub3JhbWE=?= Microsoft Windows 2000 0 17th Aug 2004 12:15 PM
save to specific location tom robertson Microsoft Frontpage 1 15th Jul 2004 05:29 PM
Hyperlinking a WORD document to a specific location in a reference document on the Web =?Utf-8?B?Q2hhcmxlcyBvZiB0aGUgUmFuZHN0YWFk?= Microsoft Word Document Management 1 25th Jan 2004 01:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:17 PM.