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

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

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

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