Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Path Problem
Below is a code that attaches "\My Stats.xls" to the end
of values in textbox6. It works fine, accept when a user selects only a drive and then clicks OK. For example, if I were to select the C drive it puts 2 // in front and this makes the path invalid(C:\\My Stats.xls), however it works fine if I select a drive and then a folder. TextBox6.Value = GetDirectory & "\My Stats.xls" How should I fix this? Thank you Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
UNC Path length problem opening a file in excel 2002 or 2003 | Excel Discussion (Misc queries) | |||
Path\File name length problem Excel Crash on save as | Excel Discussion (Misc queries) |