Hi,
I am trying to create a log with a hyperlink to saved data extracts from a
SQL server upon refresh of the data. I refresh the data upon opening the
workbook, so the macro is located/written on This Workbook. However, the log
is in another workbook. I am having trouble setting the log workbook in the
'upon open' macro -- if that makes any sense.

Now this is a problem only because I want to find the last line of the log,
of course. Whenever, and it doesn't matter if I write a separate macro and
call that macro into the 'upon open' macro, I request a count of the rows of
the log workbook I get the row count for the data extract workbook.

Any suggestions?

Thanks,
N