Jeff, Dave

Many thanks for your answers

Jeff -the variable one worked well to save the name, thanks - a bit of
a stupid error on my behalf!

However, now a file saves but it is not in pdf form even though when I
go through the same process manually and go through the "Save As"
dialog box it saves as a pdf. The resultant file I get can't be opened
even though the name is now right

Any ideas would be gratefully received

thanks

Joe


--
jlejehan
------------------------------------------------------------------------
jlejehan's Profile: http://www.excelforum.com/member.php...o&userid=33950
View this thread: http://www.excelforum.com/showthread...hreadid=547403