View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron[_13_] Ron[_13_] is offline
external usenet poster
 
Posts: 9
Default 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