Poking Database calculated values into spreadsheets

  • Thread starter Thread starter Tom Ross
  • Start date Start date
T

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
 
Back
Top