Filename Test

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leckie - 14 Dec 2006 00:22 GMT

New to vb macros - hope this isn't a stupid question - but can't seem to find
it.

I have a template that on closeing saves the file with a particular filename
(they all start with the same text) and protects the file with a password it
prompts you for. My problem is when you reopen the file - it prompts and
resaves (of course).

I'd like to use an if-then statement to test the filename. If it begins
with certain characters - I just want it to save and close the file. I don't
know how to test the filename. Help!

Thanks, in advance, for any help you can provide!

Reply to this Message

Greg Maxey - 14 Dec 2006 00:35 GMT

Leckie,

If a file has never been saved, then its filepath is null. You could use
something like:

Sub Test()
If ActiveDocument.Path = vbNullString Then
ActiveDocument.SaveAs "C:\Test.doc"
Else
ActiveDocument.Save
End If
ActiveDocument.Close
End Sub

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> New to vb macros - hope this isn't a stupid question - but can't seem to
> find
[quoted text clipped - 13 lines]
>
> Thanks, in advance, for any help you can provide!

Reply to this Message