fast macro to export table (not range) from file to another in the same folder

Hi Guys
I search for way to my project to export table name "TABLE1" from open file in RESULT sheet to closed file in sheet TABLE
two both files are existed in this directory "C:\Users\Hasson-PC\Downloads\REPORT"
when export to close file should not be open after run the macro and every time run the macro should replace data in TABLE sheet for closed file
thanks

Hi,

why do not use the classic VBA Copy method ? …

Originally Posted by Hasson

... to export ... from open file ... to closed file ...

There is no such thing as "export"/"writing" to a "closed file".
Each file on the disk, in order to read or write something from it, must be opened in the appropriate mode (with the appropriate data structure defined by the program that supports it).
The fact that sometimes you can't see that the file has been opened is only due to the fact that the given mechanism for accessing the file does not launch the appropriate graphical interface for it.

why do not use the classic VBA Copy method ? …

if I have idea I don't post here .

Each file on the disk, in order to read or write something from it, must be opened in the appropriate mode (with the appropriate data structure defined by the program that supports it).
The fact that sometimes you can't see that the file has been opened is only due to the fact that the given mechanism for accessing the file does not launch the appropriate graphical interface for it.

Thanks for this clarification !
I know it , just I wanted confirmation (no need keeping opened file after export data).

Please Login or Register  to view this content.

thanks guys !
this is exactly what I want it .