View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
keith keith is offline
external usenet poster
 
Posts: 34
Default Unique Tag for Printed Excel Spreadsheet

Tom,

It's pretty easy to just type in the same date and time in
the same location and print it, thus making the time both
reports were printed identical.

Can you be a little more specific?

Thanks,
Keith
-----Original Message-----
You mean something like the date and time?

=Now()

format as mm/dd/yyyy hh:mm:ss

--
Regards,
Tom Ogilvy

"Keith" wrote in

message
...
I am modifying a program that generates a report in the
form of an Excel spreadsheet, prints it, and saves it.

I need to come up with a method so that when the report

is
initially printed by the program, it is unique from all
other printings of the report.

Basically, there needs to be a distinguishing
characteristic on the automatically printed report so

that
it differs from other printings.

If the printed report is not unique from the saved
version, someone could manually alter the data in the
saved version and pass it off as the automatic print

out.

The report is generated by a VB program and I'm new to
programming Excel with VB.

Any ideas?



.