Automatic Printing

[neilwebb]

HELP!!!!!

I want to be able to automatically print a label from excel when
input data.

the data will be sent to excel automatically from a software packag
called winwedge.

once this data arrives in excel i need excel to do three things wit
it.

firstly, i need it to log this data with all the other data to for
graphs - this isnt a problem.

secondly, i need excel to take a copy of this data and paste it into
pre defined area ready to print.

and thirdly, once the information is inpuuted into the predefined area
i need it to print automatically.

this seems unlikely to me, but im sure there is someone out there wh
can tell me if it is possible or not??????

many thanks

nei

 

[Guest]

if your data in in a range named 'Source' and th eprint table is called
'Target' then

Sub Main()
dim rSource as Range
' copy the data
SET rSource = Range("Source")
With Range("Target").Resize(rSource.Rows.Count,rSource.Columns.Count)
.Value = rSource.Value
End With
' now print it
rSource.PrintOut
End Sub