 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Converting Excel to PDF?
I have a huge text (several hundred pages) of Turkish in Excel format. Since some special characters are being dropped or altered when printing the Excel file, I need to convert the file into PDF to get a proper printout. Unfortunately, I am only able to convert on a page per page basis. Is there any "trick" to get the entire Excel file converted in one go? There must be something in the setrtings... Ahem... I have to revise my previous post! These are not "pages" but sheets. I could almost figure that one needs to handle them one by one and not in one go. However, if there is a chance to do the conversion in one go, I'd appreciate to know. >I have a huge text (several hundred pages) of Turkish in Excel format. >Since some special characters are being dropped or altered when printing [quoted text clipped - 3 lines] > there any "trick" to get the entire Excel file converted in one go? There > must be something in the setrtings... I use a program called PDFCreator to make my PDF's. I have a VBA routine at my site that will do this: http://www.excelguru.ca/node/21#MultiSingle HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca > Ahem... I have to revise my previous post! These are not "pages" but sheets. > I could almost figure that one needs to handle them one by one and not in [quoted text clipped - 8 lines] >> there any "trick" to get the entire Excel file converted in one go? There >> must be something in the setrtings... Please explain briefly how to use your VBA routine. I've gone to your website and downloaded PDFCreator and it works fine, but I can't figure out how to make your routine work with it. I'm kind of VBA semi-illiterate! Thanks. > I use a program called PDFCreator to make my PDF's. I have a VBA > routine at my site that will do this: [quoted text clipped - 17 lines] > >> there any "trick" to get the entire Excel file converted in one go? There > >> must be something in the setrtings... Okay, I'll walk you through as if you're totally VBA illiterate, just in case. :) -Copy the code for the "Print Multiple Worksheets to a Single PDF File" routine -Go into Excel and Press Alt+F11 to enter the visual basic editor (VBE) -If you don't see a windows explorer tree at left, press Ctrl+R to expose it -Navigate until you find your project -Right click your VBA Project and choose Insert|Module -Paste the code in the screen that shows up -Go to the Tools menu and choose References -Scroll down the long list until you find PDF Creator. Check that box -Close the VBE and save your workbook Just for reference, you will now get a macro warning every time you open this workbook. Now, to run it, press Alt+F8 and a list of macros will pop up. Choose "PrintToPDF_MultiSheetToOne_Early", sit back and wait. Your completed document will end up in the same file as your workbook, and will be called Consolidated.pdf HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca > Please explain briefly how to use your VBA routine. I've gone to your website > and downloaded PDFCreator and it works fine, but I can't figure out how to [quoted text clipped - 10 lines] >> Ken Puls, CMA - Microsoft MVP (Excel) >> www.excelguru.ca THANK YOU, THANK YOU, THANK YOU FOR THE CRYSTAL CLEAR DIRECTIONS. Much appreciated!! > Okay, I'll walk you through as if you're totally VBA illiterate, just in > case. :) [quoted text clipped - 38 lines] > >> Ken Puls, CMA - Microsoft MVP (Excel) > >> www.excelguru.ca Why not make it simpler? Just select all sheets by right-click on any of the sheet tab. Once selected - convert to pdf. No need for these fancy VBA stuff :)) I converted 34 sheets into one file in 2 minutes. Vous a la. Good luck! Cheers. > THANK YOU, THANK YOU, THANK YOU FOR THE CRYSTAL CLEAR DIRECTIONS. > [quoted text clipped - 42 lines] > > >> Ken Puls, CMA - Microsoft MVP (Excel) > > >> www.excelguru.ca Hi gumyrbek, What program do you use for PDF creation? With PDF Creator, nothing comes up on the right click for the sheets that will let you convert to PDF. In addition, when you select "Entire Workbook" in the print dialog, it still prints to multiple files. With PDF Creator, the only way I have found to do this is via VBA. Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca > Why not make it simpler? > [quoted text clipped - 6 lines] > > Cheers. Ken I use the method by Dale Nurden that I posted to this thread. Here it is again.......... http://www.rcis.co.za/dale/info/pdfguide.htm Just group the sheets and print to file with the PS printer you have installed per Dale's instructions. Convert the *.ps file to *.pdf Longer way around but successful. Gord >Hi gumyrbek, > [quoted text clipped - 18 lines] >> >> Cheers. Gord Dibben MS Excel MVP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.