Export to Excel highlights dates period

[Guest]

Hi,

I have a database of events.
Each event has the fields Code, Name, Description, Start Date and Finish Date.
I want to export the filtered records of a month period to an Excel list
that has,
Code to Column 1, Name to Column 2, Description to Column 3, 1St day of
month Column 4,…..,31st day of month Column 35th
The Code, Name and Description should be placed under the relevant Columns
and the Start and Finish Dates should highlight the cells under the relevant
days.
Do you have any idea how it can be realized?

Thank you
GL

 

[Douglas J. Steele]

I think the only way would be to use Automation and write each piece of data
to the specific cell of the spreadsheet.

http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web" shows a
real simple example, or you can check my July, 2005 "Access Answers" column
in Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html