copy cell value instead of inputing text

[scrambledeggs]

First off, you folks rock. You have helped me create a sweet dynamic program that has made my job so much easier, I have one small problem that i need your help on, I have a template sheet that i create new job sheets from. Everything is working but this,,,,,,, I use this formula to create a new file folder that contains pertinent files to the job,,,,,
Sub blah()
Set Fobj = CreateObject("Scripting.FileSystemObject")
Fobj.CopyFolder "C:\Users\chris\Documents\Tracker\zzz", "C:\Users\chris\Documents\Tracker\aaa"


End Sub

"zzz" is the template, "aaa" reps the new folder.
works great every time. The problem,,,,,I need the macro to assign the new folder a name that exists in A1 of the template, not text ie(aaa) the number changes sequentially with each new job sheet. so it must be value. not formula, please help. this the last step to an awesome program. thank you in advance for your assistance..... chris

[arlu1201]

Hello scrambledeggs,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.