On Friday, May 9, 2014 10:28:54 PM UTC+10, GS 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



Well.., couldn't you just pass the value in B2 when you specify the

filename in the SaveAs action? ..perhaps!



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

Hi Garry,
not sure what you mean, would you be able to explain it to me.
I would like it to be done through a macro when I click a button on
the sheet.

regards
Ditchy

Best if you record a macro to 'grab' whatever code it generates while
doing the task manually. See what it gives you to work with. Post back
the code if you need further assistance...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion