Poking Database calculated values into spreadsheets

[Tom Ross]

Hi

My production database calculates labor and progress values for our various
jobs by JobID.

I have a query thats liste JOBID, SatusDate, Hours, Progress for all active
jobs

I have a set of spreadsheets one for each job named by JOBID

I want to loop through the query and poke the values for StatusDate, Hours,
Progress into cells D3, H11 and H12 in each spreadsheet.

I think I can do the looping through the recordset but don't know how to
open the spreadsheets and insert values into the desired cells.

I DON'T want to have the spreadsheets look up the values in the Access
query. I want to insert the data by batch.

Tom

 

[PC Datasheet]

Look at Excel automation in the Help file. Also google for Excel automation.