View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default xl 2002 date problem

On Sat, 18 Nov 2006 01:47:49 -0500, "Gary Keramidas"
wrote:

i took out the header, saved it, then put the date header back in for all of
the reports. i think it's ok. maybe something was keeping the date from
being set in those 2 reports, so it was storing whatever the last date the
report was printed, i don't know.

i think that may cause it. let's say i set report header to print the date
in 4 reports. in 2 reports i omit the date header. what would happen?

thanks for the replies


There could be a difference depending on exactly how or when you set the Date
header.

But if you omit the date header, there shouldn't be any header.

Perhaps in your code you subtract 1?

IF the header is set on the date the report is run, and if they run some of the
reports before midnight and some after, and then printed out on the same date,
they could have different dates in the header.

--ron