'ActiveWorkbook.SaveAs Filename'

Is there a maximum number of charactors that VBA will recognize for
'ActiveWorkbook.SaveAs Filename'?

I have code which used to update several (excel) files then save them to a
network file server. We have recently been required to migrate to a new
network directory/folder structure which contains 160 plus charactor naming
convention. I have made the appropriate changes to point to the new location,
but now I get an error which shuts down Excel.

Could the length of the file server/folder name be too long for Excel/VBA to
recognize?

Thanks for any insights

- -TB- -

Path length File

I think the limit is 255 or perhaps less. Apparently less based on the
following

http://support.microsoft.com/default...b;en-us;131464
"Filename Is Not Valid" Error Saving or Opening File
--
Regards,
Tom Ogilvy


"TOMB" <[email protected]> wrote in message
news:[email protected]...
> Is there a maximum number of charactors that VBA will recognize for
> 'ActiveWorkbook.SaveAs Filename'?
>
> I have code which used to update several (excel) files then save them to a
> network file server. We have recently been required to migrate to a new
> network directory/folder structure which contains 160 plus charactor
naming
> convention. I have made the appropriate changes to point to the new
location,
> but now I get an error which shuts down Excel.
>
> Could the length of the file server/folder name be too long for Excel/VBA
to
> recognize?
>
> Thanks for any insights
>
> - -TB- -
>

Tom,
Thanks for the help.

"Tom Ogilvy" wrote:

> Path length File
>
> I think the limit is 255 or perhaps less. Apparently less based on the
> following
>
> http://support.microsoft.com/default...b;en-us;131464
> "Filename Is Not Valid" Error Saving or Opening File
> --
> Regards,
> Tom Ogilvy
>
>
> "TOMB" <[email protected]> wrote in message
> news:[email protected]...
> > Is there a maximum number of charactors that VBA will recognize for
> > 'ActiveWorkbook.SaveAs Filename'?
> >
> > I have code which used to update several (excel) files then save them to a
> > network file server. We have recently been required to migrate to a new
> > network directory/folder structure which contains 160 plus charactor
> naming
> > convention. I have made the appropriate changes to point to the new
> location,
> > but now I get an error which shuts down Excel.
> >
> > Could the length of the file server/folder name be too long for Excel/VBA
> to
> > recognize?
> >
> > Thanks for any insights
> >
> > - -TB- -
> >
>
>
>