hi all

is it possible to update the value of a cell in an unopened work book, im
sure i have read it somewhere but cant seem to get the code right. i seem to
remember you have to use the full path something like

c:myfolder\myworkbook\myworksheet\mycell.value=10

cant rememberif it requires application.execl in front of it

does anyone known how to do this as im feedup of waiting for workbooks to open

many thanks


pete