 |
 | 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 / Printing / May 2005How To Print An Acrobat Form From Within Excel
Greetings, I need to print an Acrobat form and would like to do it from within Excel 2003 with a macro Any one have any clues as to how this is done? Any help would be appreciated. -Minitman Do you have the means already to print a PDF file, you do not have to purchase Adobe Acrobat just to print a pdf file. http://www.mvps.org/dmcritchie/excel/pdf.htm Basically you set the printer to a PDF writer, once you can print, Simply do the same thing while recording a macro. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Greetings, > [quoted text clipped - 6 lines] > > -Minitman Hey David, I am afraid I didn't give enough details in my question. I have an Excel workbook which I use to figure sales tax. The state has their forms available in .pdf format. I usually print out the form (both front and back) and the reprint on this form the information I have extracted from in my workbook. I tried to record an Excel macro to go outside of Excel, open the .pdf file, print the .pdf, close the .pdf and then print on the resulting form the information that is displayed in the Excel accumulating sheet. (I have a button set up to go to a sheet that is formatted exactly like the form with only the data visible, print this sheet to a specified printer and then return focus to the accumulating sheet - this is working with only a slight problem with alignment) I need a way to click on a button and have it print the .pdf form, close the .pdf and return to Excel. Is there a way to do this with a macro or VB? Any help would be appreciated. -Minitman >Do you have the means already to print a PDF file, you >do not have to purchase Adobe Acrobat just to print a pdf file. [quoted text clipped - 18 lines] >> >> -Minitman smoke and mirrors and playing with fire would be my opinion. Any change by your state to the PDF form, your version of Excel, your printer, your printer setup, your fonts would require maintenance to your overlay printing onto a printed PDF form. It's going to require a lot of work on your part or someone else's to keep it synchronized. I know of a company that sold such "technology" and I expect they put a lot of their customers out of business who bought into it. Instead of making a conversion simpler they added more layers of obscurity. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hey David, > [quoted text clipped - 42 lines] > >> > >> -Minitman Hey David, Agreed! That is why I downloaded a copy that is NOT linked to the states copy. My copy is sitting in the same directory as the Excel workbook. What I am looking for is the procedure to actually do the printing. What would you sugest? -Minitman >smoke and mirrors and playing with fire would be my opinion. > [quoted text clipped - 61 lines] >> >> >> >> -Minitman I can't see Excel printing a PDF layer and then Excel's regular printout. I would think you would have to load the printer with the preprinted forms -- your previously printed PDF sheets and then print with Excel like you've been doing. If you convert the PDF to .jpeg you might be able to print it as a watermark. see Robert Rosenberg 2001-01-08 excel.misc http://groups-beta.google.com/group/microsoft.public.excel.misc/msg/6aad0c937bf5b1da watch for wrapped lines of code. You might consider Intuit "QuickBooks" or whatever would actually print that form with your data in the software's own database. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hey David, > [quoted text clipped - 74 lines] > >> >> > >> >> -Minitman Hey David, How do I convert a pdf to a jpeg? What products would you recommend? -Minitman >I can't see Excel printing a PDF layer and then Excel's regular >printout. I would think you would have to load the printer [quoted text clipped - 93 lines] >> >> >> >> >> >> -Minitman On second thought it would have to be better resolution than what you see on the screen with a page completely in view. There are some hits with this search, the only one I found was not free, based on the blue banner at top has a "purchase" link. I saw three items that had price or purchase http://www.google.com/search?q=%22convert%20pdf%20to%20jpg%22 adding the word free came up with some hits http://www.google.com/search?q=%22convert%20pdf%20to%20jpg%20free%22 http://www.clickcat.com/cpp2/convert_pdf_to_jpg_+_free.html  Signature--- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hey David, > [quoted text clipped - 101 lines] > >> >> >> > >> >> >> -Minitman If you know someone with access to it, Adobe Photoshop can open PDFs and save them in just about any format you like. Paul C, Signature> On second thought it would have to be better resolution than > what you see on the screen with a page completely in view. [quoted text clipped - 28 lines] >>> If you convert the PDF to .jpeg you might be able to print it >>> as a watermark. see Robert Rosenberg 2001-01-08 excel.misc http://groups-beta.google.com/group/microsoft.public.excel.misc/msg/6aad0c937bf5b1da >>> watch for wrapped lines of code. >>> [quoted text clipped - 99 lines] >>>>>>>> >>>>>>>> -Minitman |
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.