I ned a code for copy a table in another workbook without open this another workbook.
I ned a code for copy a table in another workbook without open this another workbook.
You can have the macro open that workbook, copy the contents and close it again. Otherwise, its not possible to do the copy paste.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
So, in this case, can I copy a table from a closed workbook?
Yeah you can provide the path where the file exists and then the macro can open it, copy and then close it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks