Macro to print to PDF

O

OM

How do I get a macro to stop for input from the user ? I want the user to be
able to click on a button, to print a soreadsheet to a pdf file (using
PDF995). The macro must stop for the user to enter the file name, and then
continue.

Thanks,

Rob Lepper
 
S

Stan Brown

Sat said:
How do I get a macro to stop for input from the user ? I want the user to be
able to click on a button, to print a soreadsheet to a pdf file (using
PDF995). The macro must stop for the user to enter the file name, and then
continue.
Click to expand...

Look in VBA help for InputBox.
 

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

PowerPoint Printing PPT to PDF without losing quality 1
Excel Macro to record word and pdf page count in Excel 2
How to record a macro within a macro 9
Printing to File (PDF) 6
Modification of a macro 4
PDF Macro 2
Create Fillable PDF Forms With LibreOffice Writer 3
Print Macro - PDF Issue 1

Top