May 23rd, 2005, 10:55 am
Hi everybody,I've been using Excel and VBA for various tasks for the past couple of months. Many of the macros I have written use data from a variety of workbooks. I have always changed from one open workbook to another- lets say the other is AnotherWorkbook.xls- by using Workbooks("AnotherWorkbook").ActivateI installed various new pieces of software a couple of days ago and afterwards when I tried to run some of the same macros, I got error messages. After a little investigation, I've discovered that VBA is now demanding that I include the .xls extension in the filename, so that I now have to doWorkbooks("AnotherWorkbook.xls").ActivateThis new fussiness on VBA's part is a real problem because it seems to be affecting some external DLLs over which I have no control. Has anyone encountered this problem before? Does anyone know how to fix it?Thanks in advance for any help.