Hi Norie,

Thanks for your quick reply
I use range references for both the file name and path because both vary depending on the month (we save in to month folders to make finding things easier later on)
For example:
myFilename = Range("AH1").Value
myDir = Range("AH2").Value
When I try to use the filename range for the active reference though it always errors.
Not sure if that’s what you mean though…?
Craig...