Word 2007 Save As

Madison · Guest

Hi There,

I'm using word 2007 and try to Save As then I got message say "Cannot
save the file. 'test.docx' is not a valid short file name (maximum eight
characters, plus a three-character file extension). Type a valid file name,
and then save the file again."

This happened (all templates and words at network) when I open template
which run some macro then the macro will try to Save As that document with
our standard name to some folder in the same network but different folder.
After that the macro still run to collect more information from users. The
interesting is that I created that template, I can run and Save As without
any problems but when one of our programer (with admin right as I am) can not
Save As. We do not have this problem with Word 2003.
We have a lot troubles with Word 2007 which held back our convertion to
Office 2007. We did allow Trusted Location on my network (not recommended)
which we did any way but still not working.
We do not have any troublems if users do manually Save As but when the macro
try to Save As then the error message show up. All our networks have up to
date patched. This problem happened with both Window XP and Vista machines.

Any ideas.

Thanks.

Google · Sponsor

Jay Freedman · Guest

The first thing I would investigate is whether the message you see is
coming from the macro, not from Word or Windows. Word itself doesn't
care whether the filename is in 8+3 format.

Open the code in the VBA editor and search for some part of the
message. I think you'll find it, and the code that checks the name's
format will be just above it.

On Fri, 16 Nov 2007 11:14:02 -0800, Madison
<Madison@discussions.microsoft.com> wrote:

Madison · Guest

Hi Jay,

Thank you for your reply.

The error message came from Microsoft Office Word. Yes, word 2003 did not
care but Word 2007 does care a lot. We got this error message only when we
try to Save As with macro/vba coding if we manually save word document, it
works OK. We been used these coding with templates for many years. All of a
sudden using Word 2007 we got error messages. Could this is Word 2007 bug?
Like I said in my post that "The interesting is that I created that
template, I can run and Save As without any problems but when one of our
programer (with admin right as I am) can not
Save As." what is cause this to happen?

Thank you for any advises.

"Jay Freedman" wrote:

Jay Freedman · Guest

It's possible -- highly improbable, but possible -- that there's
something in the registry hive specific to that user which is turning
off long-file-name handling. I have some vague recollection from
Windows 3.1 and NT 4.0 that there were some things that had to be
enabled in the days when DOS 8+3 was the standard format. But that
should apply to all of Windows, not just Word and not just Word 2007.

Other than that, it may help if you post the part of the macro code
that saves the document. Then I can try to reproduce the behavior.

On Sat, 17 Nov 2007 09:23:00 -0800, Madison
<Madison@discussions.microsoft.com> wrote:

Madison · Guest

Hi Jay,

Thank you for your reply.

Here is my coding
ActiveDocument.SaveAs FileName:="N:\order\pending\myorder .doc"

here is happen, when users create new document using template, the vba run
to open form which allow users to enter information and then click Ok button
to save document in our network drive (the same drive as template). The Ok
button will try to save using code above. The macro will run only the first
time when created new document.

Thank you.

"Jay Freedman" wrote:

Jay Freedman · Guest

Now I'm really confused. That line will _always_ save the document to
exactly the same location and filename, overwriting any previous copy
of the document that was there. Your original post quoted the error
message as saying "'test.docx' is not a valid short file name" which
has nothing at all to do with the filename you showed here. I'm
beginning to suspect there is some other code, either in your macro or
in some add-in, that's doing something you don't know about. Without
access to your machine, there's very little I can do to track that
down.

On Sat, 17 Nov 2007 10:16:01 -0800, Madison
<Madison@discussions.microsoft.com> wrote:

Madison · Guest

Hi Jay,

I'm sorry that I made you confused.

With the line ActiveDocument.SaveAs
FileName:="N:\order\pending\myorder.doc", myorder.doc will change depend on
the case users work on such as '123-wr.doc', '137-wr.doc', or 137-tr.doc' but
location will be exactly at N:\order\pending\
myorder.doc is just the sample of document name. We do not allow any
override the document as the same name.
Yes, the error message said "xxxx.docx" but my code try to save as
"xxxx.doc". We have to produce document as .doc not .docx

Here is exactly error message
Microsoft Office Word
Cannot save the file. 'test.docx' is not a valid short file name (maximum
eight characters, plus a three-character file extension). Type a valid file
name, and then save the file again.
OK

Thank you for your advise.

"Jay Freedman" wrote:

Jay Freedman · Guest

I think you've exhausted all I have to offer. You're going to have to
do your own detective work to find out what's different between your
login, where the code works, and the other user's login where it
doesn't work. That may be a different template with unwanted code in
it, a different registry setting, or an add-in that's only on his
profile. As I said before, without access to your machine I don't have
any way to know.

On Sat, 17 Nov 2007 12:38:00 -0800, Madison
<Madison@discussions.microsoft.com> wrote:

Madison · Guest

Hi Jay,

Thank you very much for your help.

My manager allows me to open the case with Microsoft to figure how to work
with this error. Thank you again for your answers.

Sincerely,

"Jay Freedman" wrote: