Some of my macros that have been running fine for the last few months have stopped working rescently. I have worked out that it is because they now require .xls at the end of a filename where previoulsy they had not. I don't know what i have changed (nothing to my knowledge) but i am getting error messages without the Ext. My concern is that something has changed without my own obvious 'doing' that has caused the macros to stop working.
e.g.
Workbooks("CONSOLIDATION"
.Worksheets("Sheet1"
.Activate
now requires
Workbooks("CONSOLIDATION.xls"
.Worksheets("Sheet1"
.Activate
for it to work.
Does anybody know why??
e.g.
Workbooks("CONSOLIDATION"
now requires
Workbooks("CONSOLIDATION.xls"
for it to work.
Does anybody know why??