Subscript Out of Range

[vtxvtx]

Hi,

I have a macro that i run every day, and every day it has run smoothly no problem for over a month, today however it decided to break.

The issue seems to be Workbooks("workbookname").<Anything> seems to be throwing a subscript out of range error.
If i were to change this to Workbooks("workbookname.xls").<Anything> this seems to work, the question is, why would it now decide it can't run this code when it's been running successfully every day so far.

I can go in and change all this code but i would rather be able to get it running again how it used to.

Regards,

Andy

[:) Sixthsense :)]

Whether the workbook is named as workbookname.xls.xls?

[Norie]

Andy

Can you post the code?

[vtxvtx]

Sixthsense , Thanks for that idea. Its not the problem, but i realized the solution soon as i read it. I altered my computer today to not hide file extensions for know extension types which i didn't previously. I hadn't thought this would change how visual basic treats it's object names, apparently it does.

Anyway, problem solved. Thanks!!

Andy

[vtxvtx]

[Double Posted by mistake]