View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Mogy Rich Mogy is offline
external usenet poster
 
Posts: 19
Default Print report based on criteria

Hi all,
I need to print a report on the work day (Monday through Friday) that is
closest to the 15th of the month. Which means that in April I would print
in on the 13th, May is Tuesday, 15th, June Friday 15, etc. The VBA program
that controls this report also controls others that are run everyday.

How can I code this, probably by setting a variable called PrintReport to
true on the right day.

Any thoughts would be appreciated.