I do not understand why Excel works this way, and would like help please to
understand it, and how I can work around it. I am using Excel 2003.

I have 2 workbooks. My test workbook (to understand how this is working)
has a macro behind a button that calls... Workbooks.Open
Filename:="E:\Address and Telephone Book.xls".

Now this works fine except that when the "Address and Telephone Book.xls" is
opened, the active cell happens to be the last active cell location from the
last time the "Address and Telephone Book.xls" was saved. This is very
annoying if I am in a workbook that has 1000+ rows and I attempt to open
another workbook frim it, and it opens at cell location F1003, but the newly
opened workbook has rows 1 thru 50 have actual data, then I have to scroll up
to where I want my active cell to be.

Can someone please explain why this happens and how I can get my second
workbook to open in a specific cell, such as A1 or S35?