TransferText Method

[VBA Dabbler]

I've used the TransferText method many times before, and have at times run
into a length limitation for the "FileName" parameter. What I'm finding is
that the length is limited to 153 (Magical isn't it?), including the server
name, path, file name, and file extention. For example:

"\\servername\path\filename.ext"

Does anyone know of a limitation on this parameter? I haven't seen anything
in the Help facility on this issue.

 

[jahoobob via AccessMonster.com]

If you map the path where these files exist on the network to an alias (C:\,
D:\, etc.) the the path becomes D:\filename.ext. I only recommend this if
you are the only one that uses this transfer unless other users map the path
to the same alias.