write cell values to a closed file

D

Dave

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,
 
D

Dave Peterson

Check your earlier post.
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,
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write to a closed excel spreadsheet 2
Retrieving a range of values from a closed file 6
Format linked workbook cells (updated) 2
Repeat Cell Based on the Value-Excel 2003 3
Array Declaration Problem ?? 21
application-defined or object defined error 1
Cell Values from a Closed Workbook 4
Move multiple values in single Cell To Cells of there own? 3

Top