ExcelBanter - Print to file

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Print to file (https://www.excelbanter.com/excel-programming/343247-print-file.html)

JohnUK

Print to file

Hi
Again I am stuck and need some help
I need a piece of code that can bring up the print to file dialogue box, and
if at all possible enter a file name into it ready to save. And this is
really pushing it, saving the file to a specific location.
Regards
John

Vacation's Over

Print to file

VBE Help Built-In Dialog Box Argument Lists

shows full list of the system dialog boxes available

"JohnUK" wrote:

Hi
Again I am stuck and need some help
I need a piece of code that can bring up the print to file dialogue box, and
if at all possible enter a file name into it ready to save. And this is
really pushing it, saving the file to a specific location.
Regards
John

All times are GMT +1. The time now is 11:38 AM.