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

"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

Spencer

Bit cryptic, but really no. You could open the book hidden and place it
there. If it is a value from another workbook then you could link it.

Perhaps a little more info may help to give you some guidance

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"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.