Hi,
i'm looking for a macro to copy several rows of workbooks in a folder and then paste them to the workbooks in another folder that the workbooks in source folder and destination folder have the same name.
thanks in advance
Hi,
i'm looking for a macro to copy several rows of workbooks in a folder and then paste them to the workbooks in another folder that the workbooks in source folder and destination folder have the same name.
thanks in advance
Can you please be little more specific?
Folder A has workbooks a:z, Workbook a has sheets 1:n
Folder B has workbooks with same name. You want to copy from A to B
Incase Workbook in B does not exist: Create it?
Please elucidate!
bart
Thank you gave the answer
Folder A for example has 300 workbooks, these workbooks are in folder B also ,and all worbooks have one sheet.
I want copy only some parts of workbooks in folder A in worbooks in folder B, for example i want copy cell A3 up to BI20 of worbooks in folder A into workbooks in folder B .
I hope I have explained clearly .
http://vba4all.com/various-ways-to-p...mulas-and-vba/
Hope this helps a little.
I have no 100% solution for you! You need to open the workbook otherwise you cannot copy Data.
However you cannot open workbooks with the same name!
So I guess you must work via a Master workbook like:
1. Create Master workbook with the MACRO
2. Open and Copy Range from FILEa to temporary location in Macroworkbook.
3. Close FILEa
4. Open FILEb and copy Range from MacroWorkbook.
5. Close FILEb
6. Do this with all remaining workbooks!
success
Ok thanxs
I'm trying to write this macro .
Thank you to guide .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks