Input information into another workbook on next available row

[ks100]

What I have so far:

Please Login or Register  to view this content.

What I need it to do is input information into columns A - C, using the next available row.

Basically it needs to open logbook.xls and do the following:


Take todays date and copy its value into A(whatever the next available row is) in logbook.xls
Take the filename of curWorkbook (minus its file extension) and copy its value into B(whatever the next available row is) in logbook.xls
Take the value of cell AM3 in curWorkbook and copy its value into C(whatever the next available row is) in logbook.xls

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

I used Sheet1 for both, you'll have too change the actual sheet names if they are different.

[ks100]

Maybe:

Please Login or Register  to view this content.

I used Sheet1 for both, you'll have too change the actual sheet names if they are different.

Worked great, thanks. Is there any way to get it to do one more column and pull the data needed for the column from the documents sharepoint properties? I know the command to edit a sharepoint property is :

Please Login or Register  to view this content.

But how would I tell Excel to take the value of "NameOfProperty" and then following our sequence, put it in column D?

[JOHN H. DAVIS]

I'm afraid I'm not familiar with Sharepoint.