View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicolas[_3_] Nicolas[_3_] is offline
external usenet poster
 
Posts: 4
Default Write data in a closed file?

I want to make a Macro that reads data from a Workbook, and writes the data
in another group of Workbooks. I'd like that the destiny files remain closed
while the macro is running.
I tried to do with the open(instruction) but I have no luck.

The macro can be done if I open all the Workbooks, but this way is not very
comfortable.