| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change directory
Hi,
I was using the ChDir = "C:\Temp" to change the directory Is there anyway to specify the directory, and then save the path as a string. I was trying. myFileName = Application.GetOpenFilename("Excel Files, *.xls") y = Dir(myFileName, vbDirectory) but y was just set to the filename, I wanted the path like "C:\Temp" Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| How can I change list into a directory format? | Excel Worksheet Functions | |||
| Formula Link References Change to Startup Directory | Links and Linking in Excel | |||
| Takes too long for Filedialog to change directory | Excel Discussion (Misc queries) | |||
| change directory for refresh data | Excel Discussion (Misc queries) | |||
Threaded Mode
