data entry to closed excel file

[mahaveer]

i want to put data entry in closed excel file from open excel file userform. but how?

 

[Luke M]

You can't write to a closed file. You can read from one...but not write.

 

[Colin Legg]

Provided the closed workbook is not password protected, you could write to it using ADO. This however, is not a simple task - particularly because using ADO with Excel files has many 'features' and bugs - and you will only be able to insert or update datarows (not delete them) so, if you need a data store, perhaps you should consider writing to a proper database instead?