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".Worksheets("Sheet1".Activate
now requires
Workbooks("CONSOLIDATION.xls".Worksheets("Sheet1".Activate
for it to work.
Does anybody know why??