| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA code for "Save as PDF"
I have developed a reporting tool in excel, where I need series of worksheets
to be saved as PDF one after another through a click of button (VBA macro-enabled). I need VBA code to save my print-area as PDF where it only once asks "where to save" and then saves current series of PDFs. It should take file name from a fixed cell too. Regards, Pritesh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA code for "Save as PDF"
Check out this link...
http://www.excelguru.ca/node/21 -- HTH... Jim Thomlinson "Pritesh" wrote: I have developed a reporting tool in excel, where I need series of worksheets to be saved as PDF one after another through a click of button (VBA macro-enabled). I need VBA code to save my print-area as PDF where it only once asks "where to save" and then saves current series of PDFs. It should take file name from a fixed cell too. Regards, Pritesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
![Pritesh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
