29th November 2011, 10:05 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
|
|
Oh, forgot to mention in the "Copy" and "Copy2" macro the part in red on this line needs to be changed.
fName = "F:\Files\Form Ratings 2010\Form Factor Ratings 2011" & Sheets("MainSheet").Range("AA16").text & ".txt"
it refers to where the file is stored, stick it in your C drive and replace the line with this.
fName = "C:\Form Factor Ratings 2011" & Sheets("MainSheet").Range("AA16").text & ".txt"
|