Hi Garry
the XPS macro is perfect, just what I need.
I am having trouble getting the Sub ConvertToValues() to function, keeps looking for the timestamp and I am not sure where to go from here. I am not very clever when it comes to macros.But XPS is great and much appreciated.

regards
Ditchy

On Friday, May 9, 2014 6:27:31 PM UTC+10, wrote:
Hello,

I have a macro which will print (A1:F20) with XPS, is there a way to save with a filename automatically, with the filename taken from (B2). It will be the same path just a different name each time.



all help much appreciated

regards

Ditchy

Ballarat

Australia