1. The sheet name for all workbook is "owssvr"
2. i have changed the columns in code based on my requirement, and ensure the columns are matching both in code and in all the files. I have done a check for one column by giving extra space to know whether it copy or not. But it is not copy all other columns because of one column error. I thought the code would pick other columns without the wrong column.
Bookmarks