Button to print XLS file as PDF

J

johan

Hello,

Can somebody help me out.

Within a xls file I want to create a button with a macro which will
print the printarea as a acrobat pdf file with the filename as
registered in datafield A2.
If this is, for example "testtest" than after push the button the
macro should give the printpreview as pdf file with the name
testtest.pdf

I also like to have a macro which shows me the ;save as; box with file
name mentioned the same as above. The ;save as; box shows then
filename testtest.xls

Somebody knows the solution........ thanks.

regards,
Johan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Print as pdf and save as xls with filename from a datafield 0
Images are pixelated when saving to PDF 0
To make pdf to work as word 1
Descenders clipped 0
macOS Office365 Word 0
Print (physical or pdf) not respecting format of source document 0
VBA Export to PDF 0

Top