"Spencer Hutton" wrote in message
...
i have a workbook called book1. is there a way to put a value in sheet1,
cell A1 without opening the workbook? TIA.

Notr really, You could write a macro that opens the workbook, inserts a
vale, saves it and then closes it. This wway, the openinng of the workbook
wouldn't have to be made manually. There are also programs tha understands
the interanls of an xls file that can do this. A workbook is a file and it
has to be opened in order to make some change to it

/Fredrik