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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Path Problem
Hi Todd,
Something like this should work for you: Sub demo() Dim sDir As String sDir = GetDirectory If Right$(sDir, 1) = Application.PathSeparator Then _ sDir = Left$(sDir, Len(sDir) - 1) TextBox6.Text = sDir & "\My Stats.xls" End Sub -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Todd Huttenstine wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Path Problem
thanks, that worked great.
Todd Huttenstine -----Original Message----- Hi Todd, Something like this should work for you: Sub demo() Dim sDir As String sDir = GetDirectory If Right$(sDir, 1) = Application.PathSeparator Then _ sDir = Left$(sDir, Len(sDir) - 1) TextBox6.Text = sDir & "\My Stats.xls" End Sub -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Todd Huttenstine wrote: 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Path Problem
thanks, that worked great.
Todd Huttenstine -----Original Message----- Hi Todd, Something like this should work for you: Sub demo() Dim sDir As String sDir = GetDirectory If Right$(sDir, 1) = Application.PathSeparator Then _ sDir = Left$(sDir, Len(sDir) - 1) TextBox6.Text = sDir & "\My Stats.xls" End Sub -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Todd Huttenstine wrote: 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 . |
Reply |
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) |