Embedding contents of a cell into a file path

[morris5984]

Hi,

Hoping someone can help me with a challenge I'm facing. I am trying to write VBA code that includes the contents of cell D13 into a path. If you look at the code below, i'm trying to insert the contents D13 where it says "?????" (please also note that D17 is actually going to be the name of the .xls file)

So if D13 = bfg3212, it will save the file using the path C:\Documents and Settings\bfg3212\My Documents\

Thank you in advance!

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.