I read some threads, and write down this code. The purpose is for combining excel files into one.
For example, I have 10 data files. All of them are in the same format with 2 sheets. I want to use the VBA code to combine them into one excel file.
After testing, lots of data are missing. I use F8 to check it step by step, and found out that the new files data will replace the old one, etc.
What should this code be amended for my purpose?
Please Login or Register to view this content.
Thank you!!
Last edited by Andy910104; 03-18-2014 at 12:11 PM.
You must find the first empty cell in column A. This is the position you want to put your copied data.
Change those 2 lines of codes.
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
I understand the code, but VBA turns out with application-defined or object-definded error. Is there anything i missing?Originally Posted by p24leclerc
You must find the first empty cell in column A. This is the position you want to put your copied data.
Change those 2 lines of codes.
Please Login or Register to view this content.
You must find the first empty cell in column A. This is the position you want to put your copied data.
Change those 2 lines of codes.
Please Login or Register to view this content.
I got the same problem, application-defined or object-definded error.
Is it meaning that VBA cannot define Range("A2").End(xlDown).Offset(1).Resize()?
Then, can I cut down this statement into two to make this work?
Strange, it works well on my computer which also runs Excel 2010. Are you sure the error is on this line of code? If you click on Debug, which line is highlighted?
You can try this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks