Thanks, works perfectly.
Now what if I wanted to copy two seperate sheets to two different folders? Would i just replicate the code but insert
Sheets("Sheet2").Select
and also change
FP = "C:\Test\" so it now reads FP="C:\Saved\"
Thanks, works perfectly.
Now what if I wanted to copy two seperate sheets to two different folders? Would i just replicate the code but insert
Sheets("Sheet2").Select
and also change
FP = "C:\Test\" so it now reads FP="C:\Saved\"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks