macro to input data in a closed file

Hi Ahmed,

The short answer is no. And this applies not only to Excel, but virtually all applications. However, it is quite easy in VBA to open a file, enter data into it, and close it. If the file happens to be a text file and you open, modify and close it with VBA I/O statements it will happen so fast you will not even be aware it is happening, and of course it will not appear on the screen.

I hope this helps.

Damon