update cells in unopened workbooks
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 |
update cells in unopened workbooks
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 -- Please remember to indicate when the post is answered so others can benefit from it later. "pete the greek" wrote: 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 |
update cells in unopened workbooks
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" wrote: 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 -- Please remember to indicate when the post is answered so others can benefit from it later. "pete the greek" wrote: 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 |
update cells in unopened workbooks
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. -- Please remember to indicate when the post is answered so others can benefit from it later. "pete the greek" wrote: 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" wrote: 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 -- Please remember to indicate when the post is answered so others can benefit from it later. "pete the greek" wrote: 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 |
All times are GMT +1. The time now is 08:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com