Building a Resource Scheduling Database Version: 2000 (9.0)

[Gabe]

Hello --

Can Access develop a report in Excel with shaded areas to denote a used
resource for a given timeframe?

I am building a database that will hold schedules for Trainers and Training
Rooms, along with other related training class data. I'm looking to develop
an excel report that will display the 52-weeks of the year down column A, and
the classrooms across row one. Cell would be color-coded vertically by
department.

I've attached an example:

I have a class beginning on January 1st and ends on February 28th, in
Classroom C. I want Access to generate an Excel spreadsheet that will color
the cells from 1/1 to 2/28 under Classroom C.

Any help would be greatly appreciated. Thanks!

 

[Klatuu]

You can't do any formatting with either the OutputTo or TransferSpreadsheet
methods. For this, you will need to use automation. If you have not used it
before, the learning curve can be intimidating; however, once you understand
it, you can do anything that can be done in Excel.