Printing A PDF From A CommandButton

[Minitman]

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

 

[Bob Phillips]

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?

 

[Minitman]

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

 

[Bob Phillips]

Sorry, I didn't quite mean that, I meant build an Excel form by typing all
of the heading into Excel etc.

 

[Minitman]

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