MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro to input data in a closed file


Posted by Ahmed on December 01, 2001 11:21 AM

Is there any way to enter data in a closed file from another open file/userform?


Posted by Damon Ostrander on December 01, 2001 10:14 PM

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