Path Name

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

EqualOpportunities replied

29 September 2005, 10:35
Originally posted by wc2

How about using the old 8.3

path c:\progra~1 etc

It still works on XP etc

Either that, or just map a drive to where you want to save it to - that should shorten your path to about, erm, three characters...
Leave a comment:
wc2 replied

29 September 2005, 07:53
How about using the old 8.3

path c:\progra~1 etc

It still works on XP etc
Leave a comment:
BoredBloke replied

27 September 2005, 15:58
"You could save it to a short filename and then have vba run a batch file to rename it."

That is kind of what I am going to do. Except I'm going to name it - part of the name is a date stamp and save it in a sub dir with a short name. Then run a batch file to move it to its final location. Still a pain in the @rse though.
Leave a comment:
PerlOfWisdom replied

27 September 2005, 15:32
You could save it to a short filename and then have vba run a batch file to rename it.
Leave a comment:
PerlOfWisdom replied

27 September 2005, 15:27
"Create a shortcut to the file and save to that."

is a method that doesn't work

Last edited by PerlOfWisdom; 27 September 2005, 15:29.
Leave a comment:
BoredBloke started a topic Path Name

27 September 2005, 13:56
Path Name

I have a bit of code which specified the path for a file to save to. Unfortunately the path is 166 characters long. The filename is a nifty little 74 characters long. Meaining that the path and filename combined is 240 characters long. Apparantly in Excel there is a limit in VBA of 218 characters for a path and file name string.

Anybody know a quick way around it.
Tags: None