i have diff excel files in a folder with diff name-what i want to do-i need a vba macro-by which i can add data of one excel after another-wht i am doing manually-jst made i excel and doing copy paste -after opening each excel workbook-cnt it be autmated..
i want that some vba macro jst pck data of sheet 2 of everywook-jst after another ....
Shall i explain it further-i was to merge the data of all xlsx file in a folder in a singl xlsx file-but for there second sheet only-and data will be merged vertically-i mean paste next data below row wise....
You have not clearly explained your issue. I urge you to not use texting language in this forum. Not everyone understands what you are saying. Using complete English sentences enhances the solving of your problem. Additionally, your explanations are not clear. Suggest you provide examples of what you have and what you expect for an outcome. Perhaps some sample data with your explanation would encourage others to respond.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Add second sheet data of diff excel in a folder
I have workbooks like A , B .....Etc in a folder-two sample files are attached-result file is also attached..
Here is some generic code to loop through a known folder and open each file and copy the data from a specified sheet and then paste into a master file. Change up the code as needed to meet your specific case.
Please Login or Register to view this content.
snap shot of run time error is aatched kindly assist:
the code which i am using as you suggested sir:
here in red line it says to debuggPlease Login or Register to view this content.
Last edited by ROHAN999; 04-19-2015 at 02:19 AM. Reason: code is not wrapped
Please Login or Register to view this content.
Workbooks.Open (MyFile)
here it says to debugg sir
snap shot of run time error is aatched kindly assist:
the code which i am using as you suggested sir:
snapshot.jpg
Potential issues: http://www.runtimeerrorsfix.com/how-...rror-1004.html
Potential Issues: http://webmasterfacts.com/runtime-error-1004/
Read Post 11 here: http://www.mrexcel.com/forum/excel-q...or-1004-a.html
Potential Issues: http://www.speedypc.com/articles/fix...error1004.aspx
It appears from these documents, that there may be an issue with your PC. Read through and see if any of the solutions offered fix your issue. It is not a coding issue.
No sir i have tried everything-also tried on various other computers too-the same error persist-kindly help-plz check it at your end by making a folder with name "CLUB MASTER" in d drive and then save the three files attached by me-in that folder and check the same error comes or not? Plzzz..
Will be travelling for the next week. Will not have time to analyze. Hopefully, someone else may jump in. If not, I will explore at the end of travels or as time permits.
Anybody else kindly assist-I am making folder in d drive with the name "Club Master" ,pasted all my xls files into it-from which i want to copy data-then using this code -as said above-wht is wrng-why this error is cming-my project is imp and i have 1543 files-plz assist.
Anybody-any idea-what is going wrong-any other way or something.
Hello ROHAN999,
I have added the macro below which has tested on the files you provided to the attached workbook. Change the folder in the macro to where your files are saved.
Module1 macro code
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
thnx alot sir
Hello ROHAN999,
You're welcome. Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks