Can't assign to read-only property Error on GetSheet

[macki60]

I am trying to combine several workbooks with the same table structure into one worksheet... I tried the below code but it keeps returning Can't assign to ready only property error. can someone help me? Excel 2013

Please Login or Register  to view this content.

Thank you for the help!

[shg]

What line errors?

[macki60]

"path =" errors first line

Thank you

[shg]

Path is not a VBA keyword. You could start by declaring your variables:

Please Login or Register  to view this content.

[macki60]

Thank you this worked!!

[shg]

You're welcome.

[f1r3r41n]

Had the same issue as OP, with the same code:

Please Login or Register  to view this content.

Tried your solution, but it won't even error, just...does nothing? I'm not sure what's happening. Any ideas?

[shg]

Maybe there are no xls files in the directory. What happens when you step through the code?

[f1r3r41n]

If you're referring the step into dialog, I'm not certain how to leverage that (I'm somewhat new to VBA, but programming, as a whole, I'm familiar with).

[shg]

Put the cursor in the sub and press F8 to step into. Hover over variables to see their values.

This is a good time to read http://www.cpearson.com/excel/DebuggingVBA.aspx

[tsq]

Same error as f1r3r41n. After debugging I found out that sPath is ok but sFile doesn't work properly. Didn't back any file but I have 3 .xls files there. Any clue?

EDIT:
I tried with 1 file and again read-only msg but from debugger