Run-time error '1004': VBA code fails to read and copy data from the files

Hi

I've copied the code for looping through the files in the folder from a web site and included my own code to capture the data from the worksheets.Initially, it worked find when I was reading data from multiple sheets and write in row-wise in one sheet.Then I changed the code to write column-wise and the error starting to pop-up - Run-time error '1004':Application-define or object-defined error.And now its giving the same error for row-wise writing data.

It may be simple thing but it is giving me a lot of grief.

Please refer to the code below and many thanks in advance.

Please Login or Register  to view this content.

When the error occurs, select Debug. Which line of code is highlighted?

What parts of the code did you change?

Try checking what value variable "j" holds when the error is generated (either by stepping through, or using Debug.Print).
My suspicion is that it holds some invalid value (string, 0 etc), since it's supplied by Inputbox.