Getting Subscript Out of Range

**bbmak** · 08-26-2014, 12:16 PM

I don't know why my VBA code got Subscript Out of Range. Can anybody please look at my code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**6StringJazzer** · 08-26-2014, 02:57 PM

There is nothing obviously wrong with the code, so it may be the data. When this runs, and the error occurs, show the value of filepath in the debugger. If it is null then Split will return an empty array and you will get that error trying to index it.

**bbmak** · 08-26-2014, 08:08 PM

Thank you so much looking my code, and I have found the problem.

Please Login or Register  to view this content.

If InStr(filename, DealFileNames) <> 0 Then
DealFileNames ---> should be DealFileName

anyway, really appreciate you spending time look at the error.
Thanks