| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenating Variables into file path name
I can't seem to place a variable in the file path, other
than the file name at the end of the path. I've tested the code with text rather thn the variable, but when I try to reference a cell for a text value, I get a "cannot find path" error. What is the syntax for adding a variable in the middle of the path? E.g. ActiveWorkbook.SaveAs FileName:="E:\subfldr1\subfldr2\" & ActiveSheet.Range("E25")& "\Subfldr4\"& stFileName |
| 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) | |||
| Reference a file by concatenating cell variables | Excel Worksheet Functions | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Concatenating cells to produce a cell ref from another excel file | Excel Worksheet Functions | |||
![Ron[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
