I want merge all file in folder (.xls) But every file header as same.
I want to create new file (merge all file) ---> create new file name = data.xlsx
and delete file original before merge.
Please guide me about it. (VBA , Macro)
I want merge all file in folder (.xls) But every file header as same.
I want to create new file (merge all file) ---> create new file name = data.xlsx
and delete file original before merge.
Please guide me about it. (VBA , Macro)
Last edited by adamasmay; 05-26-2022 at 12:14 AM.
Any Idea for solve this case?
With power query
It can use macro write power query?
You don't need macro's to use power query
Your Excel version being ? ( Profile indicates version 8??)
I want to solve this case via call macro, vba.
Please guide me about it.
It will be something like this then
Please Login or Register to view this content.
We advise you not to 'bump' (reply to) your own posts too quickly after posting, unless you are posting some sort of clarification. Since bumped threads have replies, they will no longer appear in the "Zero Reply Posts" listing, which many members use to look for unanswered questions. If you do bump, limit it to no more than once every day. Remember that your best helper may be asleep on the other side of the world.
Anyone please guide me for solve this case.
This should work, only for 3 columns.
Please Login or Register to view this content.
After run with your code that you sugggest.
My data have same header.
I don't write same in file 2,3.
and I want wwrite output in new file (Output.xlsx)
Please guide me more about it.
Predefine your header
Please Login or Register to view this content.
1. I want header in first row (highlight yellow)
2. save data in newfile.
3. delete file original.
Please guide me more for solve it.
Last edited by adamasmay; 05-26-2022 at 04:42 AM.
Place all workbooks incl. OutPut in the same folder.
Please Login or Register to view this content.
It good if I can paste output macro.
It error as below.
See if this works,
Please Login or Register to view this content.
Data output as correct.
But If I want delete file orginal and write data to new file.
Please guide me more about it.
What is "Original" file?
I change your code as higlight.
Origanal file mean file in folder that highlight.
No idea about what you are trying to say with that picture.
That's just folder path, not the file.
Now I merge all file in folder as picture.
After merge I want delete files in folder.
Please Login or Register to view this content.
Last requirement.
I want write data after merge in new file.
Why are you asking one by one?
I hate how you ask questions...
I alread told requirement.
Last edited by adamasmay; 05-26-2022 at 06:43 AM.
I am sorry.
But can you help me for last requirement.
Any idea for solve this case?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks