Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing A PDF From A CommandButton
Greetings,
I have a workbook that has a sheet that is spaced to print on a government form. This form is in my computer as a PDF. Is there anyway to call up this form, print it and then print the information into it, with a CommandButton? I tried to record a macro, but the recorder would not see anything outside of Excel. Anyone have any ideas? TIA -Minitman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing A PDF From A CommandButton
If the form maps exactly onto the form, use Adobe to print a number of blank
forms, load this into your printer, and then print the completed Excel doc. Or perhaps, re-do the form in Excel? -- HTH Bob Phillips "Minitman" wrote in message ... Greetings, I have a workbook that has a sheet that is spaced to print on a government form. This form is in my computer as a PDF. Is there anyway to call up this form, print it and then print the information into it, with a CommandButton? I tried to record a macro, but the recorder would not see anything outside of Excel. Anyone have any ideas? TIA -Minitman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing A PDF From A CommandButton
Hey Bob,
Thanks for the reply, printing the form out each time is what I have to do at present. As to the other idea, how would I import a PDF file into EXCEL? Any other thoughts, ideas or suggestions? TIA -Minitman On Tue, 18 Jan 2005 09:15:24 -0000, "Bob Phillips" wrote: If the form maps exactly onto the form, use Adobe to print a number of blank forms, load this into your printer, and then print the completed Excel doc. Or perhaps, re-do the form in Excel? -- HTH Bob Phillips "Minitman" wrote in message .. . Greetings, I have a workbook that has a sheet that is spaced to print on a government form. This form is in my computer as a PDF. Is there anyway to call up this form, print it and then print the information into it, with a CommandButton? I tried to record a macro, but the recorder would not see anything outside of Excel. Anyone have any ideas? TIA -Minitman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing A PDF From A CommandButton
Hey Bob,
No problem. I appreciate the reply However, the question still remains, is there a way to import the pdf form as a picture into excel? Or is there a way to import the excel data into the pdf fields in some other program? One or the other will work for me. TIA -Minitman On Tue, 18 Jan 2005 16:01:26 -0000, "Bob Phillips" wrote: Sorry, I didn't quite mean that, I meant build an Excel form by typing all of the heading into Excel etc. -- HTH Bob Phillips "Minitman" wrote in message .. . Hey Bob, Thanks for the reply, printing the form out each time is what I have to do at present. As to the other idea, how would I import a PDF file into EXCEL? Any other thoughts, ideas or suggestions? TIA -Minitman On Tue, 18 Jan 2005 09:15:24 -0000, "Bob Phillips" wrote: If the form maps exactly onto the form, use Adobe to print a number of blank forms, load this into your printer, and then print the completed Excel doc. Or perhaps, re-do the form in Excel? -- HTH Bob Phillips "Minitman" wrote in message .. . Greetings, I have a workbook that has a sheet that is spaced to print on a government form. This form is in my computer as a PDF. Is there anyway to call up this form, print it and then print the information into it, with a CommandButton? I tried to record a macro, but the recorder would not see anything outside of Excel. Anyone have any ideas? TIA -Minitman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I do it??? (OnAction with CommandButton) | Excel Programming | |||
CommandButton | Excel Programming | |||
CommandButton | Excel Programming | |||
CommandButton | Excel Programming | |||
Commandbutton | Excel Programming |