print pre-printed forms

O

osuarezf

Is the any way to use excel to print pre-printed
forms ( invoices , etc ) after all datas are entered?
Is there any way to design a template for that ?
Tks !!
Osvaldo
 
O

Otto Moehrbach

Osvaldo
I take it that you have a printed form to start with, and you want to
put this printed form in the printer and have Excel fill in the blanks. Is
that right?
You can write a macro to do this but it will be a lot of trial and error
to get the code to place the data in the blank spaces correctly. It would
be much easier if you design the form in Excel first, then have Excel fill
it in with a macro, then have Excel print the entire form. In some cases
you can do the filling in with formulas and you wouldn't need a macro. HTH
Otto
 
Top