View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_11_] Dave[_11_] is offline
external usenet poster
 
Posts: 41
Default write cell values to a closed file

Hi gang,
I am on Excel 2003

I have a problem I am trying to solve . I am trying to keep a log of
all invoices that are processed by the invoice clerks in a given
period. I would like to populate a spreadsheet M-log from the cell
values (H6,O6,P6,H7,H15 & O14 from " Invoice1". I would like this to
insertion to
occur when the " Invoice1" spreadsheet is closed .


The spreadsheet M-log will not be open at this time &, its path
would be c:\excel\m-log. I would like to insert the values into
"Sheet1" of M-log and into the cell range B8,B9,B10,B11,B12,B13


thanks,