macro to print xps then save with name value in (B2)

[stephen.ditchfield]

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

 

[GS]

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

 

[stephen.ditchfield]

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

 

[GS]

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