update cells in unopened workbooks

[pete the greek]

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

 

[KC Rippstein hotmail com>]

The old XLM language can retrieve a value from a closed workbook
(ExecuteExcel4Macro) and can be run via VBA, but it does not write to a
closed workbook.

Ron deBruin has a site which discusses using ADO to accomplish
reading/writing with closed files.
http://www.rondebruin.nl/ado.htm

 

[pete the greek]

thanks for the pointer, not sure if you mean its not possible to write to a
closed workbbok as rons page is about retrieving from a closed book,not quite
what i was looking for but some interesting stuff on rons page. im sure ill
be back there in the future. i also today found the text i had read and
believe i had miss read it anyway

thanks for taking the time to respond

 

[KC Rippstein hotmail com>]

No, according to Ron you can use ADO to both read and write to closed files.
I've seen this topic specifically discussed in other forums, I just don't
know anything about ADO myself so unfortunately I cannot elaborate further.