always open an xls with the active cell being at the bottom of a table

Hello,

I've got "scan it to office" connected to my xls sheet.
As soon as I open it "scan it to office" will automatically place the scanned article records in the active cell in the active sheet.

I've got a table so the question is how to make sure the active cell when opening a multiple sheet workbook... is at the first empty row at the bottom of this table.
See attached worksheet:
So how do I get the active cell to be in cell A13 in the records sheet when I open the sheet..... no matter if what the active cell was when I closed the sheet.
Also keep in mind that "A13" changes as soon as new scans are added.

Gonna need some vba here I reckon.

Much obliged in advance,

grts Mr. Hat

Full code in ThisWorkbook module:

Please Login or Register  to view this content.

Artik

Excellent!
Thank you very much. :D