I recently upgraded from Excel 2003 to 2010. I have a macro I ran on a regular basis in an Excel 2003 file. When I converted the file to 2010 and ran the macro, I got an "Application-defined or object-defined error" when the macro tried to enter the following forumla:
Range("R1").FormulaR1C1 = "=VLOOKUP(RC17,'[Aged FG Tracking Report.xlsm]Zero Sales Value'!C4,1,FALSE)"
The only thing I changed was the extension on the file from ".xls" to ".xlsm". I cannot fix it. I even manually entered the formula into Excel and it was fine. I tried to copy and paste it back into the VBA and it still gave me the error.
Range("R1").FormulaR1C1 = "=VLOOKUP(RC17,'[Aged FG Tracking Report.xlsm]Zero Sales Value'!C4,1,FALSE)"
The only thing I changed was the extension on the file from ".xls" to ".xlsm". I cannot fix it. I even manually entered the formula into Excel and it was fine. I tried to copy and paste it back into the VBA and it still gave me the error.
