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. |
All times are GMT +1. The time now is 02:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com