Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write data in a closed file?
Nicholas:
Look at my reply yesterday. As I said my have to open the file to write to it. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Nicolas" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write data in a closed file? | Excel Programming | |||
Extract Certain Data from closed file | Excel Programming | |||
How to write to the VBE of a closed workbook? | Excel Programming | |||
Write no closed workbook ? | Excel Programming | |||
Write to Array from other closed Excel file | Excel Programming |