word/excel question

i tried to google this, but i had zero luck.

i have a running excel file inside a word document on my work PC. (win 7 i think). it is getting quite long as i use it to record my daily tasks quickly before enterning them into a much more difficult database. anyways, whet i want to do is this:

when i save, then close the file, i want to go back to where i was when i closed it the next time i open it. instead of searching for the section i was last in, i want it to just go back to where i left off (sort of like a bookmark in a novel). is this possible? im not always looking for the bottom, either. usually its someplace in the middle, and with about 30 pages now, and growing about 3 pages per week, this little feature would be nice.

any ideas?

-J0N

I literally typed 'bookmark' into Word's help and there is a bookmark feature.

Its possible to write a Macro to name a specific cell as a variable "bookmark" ( or whatever you want to name that variable.). The Macro will record that cell, and then next time you open, run the "bookmark" macro, and it will activate that specific cell.

Why do you have it "inside" word?

Second the question about why it's embedded in a word doc.

In the Excel spreadsheet, once you have your block of data active, you can do Ctrl-down arrow to get to the end of the contiguous block of data (which sounds like what you have).

szeis4cookie wrote: Second the question about why it's embedded in a word doc. In the Excel spreadsheet, once you have your block of data active, you can do Ctrl-down arrow to get to the end of the contiguous block of data (which sounds like what you have).

jmthunderbirdturbo wrote: im not always looking for the bottom, either. usually its someplace in the middle,

If you have Excel embedded as an Excel object in a Word document. You should just see a portion of the Excel document in Word. The easiest way to do this is: 1. Copy a rang of cells from Excel 2. In Word, select Paste -> Paste Special -> Microsoft Excel Worksheet Object from your Edit menu or Home menu depends on your version

If you double-clock on the spreadsheet, you will enter into the Excel object and you can move up and down in the Excel, once you move to the rows/columns that you are looking, you can click out of the Excel object and Word keeps your place in the Excel. If you save now and open again, you should see where you were before.

slow wrote: If you have Excel embedded as an Excel object in a Word document. You should just see a portion of the Excel document in Word. The easiest way to do this is: 1. Copy a rang of cells from Excel 2. In Word, select Paste -> Paste Special -> Microsoft Excel Worksheet Object from your Edit menu or Home menu depends on your version If you double-clock on the spreadsheet, you will enter into the Excel object and you can move up and down in the Excel, once you move to the rows/columns that you are looking, you can click out of the Excel object and Word keeps your place in the Excel. If you save now and open again, you should see where you were before.

that works PERFECTLY! thanks! it also means the entire frigging thing doesnt have to load every time, and the file opens 4x as fast. awesome guys!

-J0N