I don't know if this is a change in the version, but in 2003 this used to work in Access VBA:
Dim xlSheet As Excel.Worksheet xlSheet.Range("RangeName").Value = 100
Previously I did not need to identify the worksheet because "RangeName" was unique. Is Excel 2007 not considering this a unique value and requires that the worksheet be specified?
[EDIT] Here is the error in Access 2007 VBA: "Error 1004 (Method 'Range' of object '_Worksheet' failed." Trying to avoid naming the worksheet.
I used the Name Manager in Excel. The name is unique and the scope is workbook.
When I tried to Edit Name, it does not allow the scope to be changed.
Note: This workbook is Template that allows macros and the names are a mess.