Hello,

I am using the below to save a file to a drive. I want it t
automatically save it in the folder (textbox1) based on what is entere
into a userform. But I am getting an error when it is saving the file.
It say's the folder name has already been created so it won't save th
document there. How can I bypass this? The form is going to b
entered on a daily basis, and I need it to save the files in th
specific folder based on the textbox1 input.

newFolder$ = "\\Pkcfp009\mait_e&d\NewHireDocumentation\Transiti on t
Success Plans\" & TextBox1.Text
MkDir newFolder$
newFile$ = newFolder$ & "\" & TextBox2.Text & ".xls"
ThisWorkbook.SaveAs newFile

--
Message posted from http://www.ExcelForum.com