Hello,
I am trying to get this code to work for either CutePDF printer or Adobe PDf printer. But I am not able to get it right, also I want to specifiy the pages that need to be printed.
If B49 is filled then all pages should be printed
If B49 is empty then page 1 and 3 should be printed.
Please Login or Register to view this content.
Thanks,
Aadesh Gandhi
Upate
I changed the code from this
Please Login or Register to view this content.
To this ONLY DIFF Filename -----> PrToFileName
Please Login or Register to view this content.
This does create a PDF file on the desktop for me but I cannot open it, get an error saying its corrupted.
I am still trying to look for a solution for the second point; Print page num 1 and 3.
Thanks,
Aadesh Gandhi
Okay, so the code below works for me for the Adobe PDF printer... This should work for other people as well if they have the Adobe PDF Printer. I did not check it for CutePDF as of now but would do that later.
----->>> Excel gurus, correct me on the comment below if I am missing something or misspoke<<<---------
Also one thing that I got to know is MS Excel 2007 and 2010 do not support printing of individual pages like earlier. If I want to print say 1,3,5,9 I cannot do that now in Excel 2010. In earlier versions one was able to add individual pages to print seperated by a comma. Excel 2007 and 2010 just merge the numbers up. The workaround for this is to set a page range and then print.
Please Login or Register to view this content.
Thanks,
Aadesh Gandhi
Last edited by aadeshgandhi; 03-20-2013 at 12:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks