Have you tried the macro recorder? It may not work as cutepdf is external to
Excel but it may add methods that allow you to do it - I don't know how the
program works.

Jeff

"jlejehan" wrote in
message ...

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