No, changing closed excel files I would not recommend, although it is
possible using ADO!

You need to code ADO with VBA to actually change a value in a closed
workbook.
But this means you will be accesing your workbook as a database and as
Tom states, you might have less worries if you did everything in a
real database.

DM Unseen