For instance, if a cell in one worksheet has a sales number, you can display that value in another worksheet by adding a reference to that cell.

The cell in another worksheet that contains data to which the link refers is called a precedent cell. Dependent cells automatically change if the precedent cells change.

I need to be able to get a date value stored in an Excel spreadsheet (say, C Temp\file.xls) in cell B28, and put that value into a variable to then use it in a VBA module in MS Access. <BR><BR>I ...

You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your own cell references? This is where the INDIRECT function comes in handy.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.