Printing Macro
Hi,
I'm new to Macro, so most of the codes that you may provide may not be
comprehendable by me. In which case, i shall use the code as you provide.
What i need :
1) i have 3 pieces of information on a single worksheet, it's called "Sheet1"
range a15 : b25 .... i call it range 1
range a115 : b125 .... i call it range 2
range a215 : b225 .... i call it range 3
2) On the top of the page, i have put 3 command buttons, for each range,
namely,
"print range 1 to pdf", "print range 2 to pdf", "print range 3 to pdf".
3) The driver that i use to print to PDF is AMYUNI print driver.
4) If i click command button "Print range 1 to pdf", it should
i) print the range a15 : b25 using the Amyuni pdf print driver, row 15
(cells a & B are merged) contains text. use the text in row 15 as the
filename. the pdf document should be saved in a folder called "My work
folder" within My documents. Address is
C:\Documents and Settings\abcdef\My Documents\My Work Folder
Likewise the same procedure should be followed for the other 2 data ranges.
Please do let me know if you require any more information.
Appreciate your help.
|