insomniac53
Board Regular
- Joined
- Sep 3, 2013
- Messages
- 104
I've written the code for a form which dynamically creates (and later removes) rows of text boxes. I now want either to print it or produce a pdf using vba - I don't want to use ALT-PRTSCR to copy and paste into another program. I would like a command button that does the trick. Previously, I've used:
and this printed the underlying data tied to a worksheet. In this case, there is no single underlying sheet - the data is taken from various sheets and manipulated in memory. When I tried this earlier and used the Print Dialog command, Excel stopped working and just kept beeping at me. I've looked at other threads, such as:
but before I get too deep, I would like to know if the experts here think this is possible, and if it is, what's the best way of tackling it?
Thanks.
Code:
Application.Dialogs(xlDialogPrint).Show
HTML:
http://www.mrexcel.com/forum/excel-questions/737916-visual-basic-applications-save-userform-pdf.html
Thanks.