Hi Forum. Good morning.

I would like to know how best to reference a workbook and a table object from within a called function or procedure. I have the calling procedure within the worksheet module (named as Libby) and the called function is within the Modules (named as module1).

What I want to be able to do is update a row on a table held on the worksheet 'Libby' after I create a new workbook via a called function within "module1". Within this called function I execute some commands and it's here that I want to update the table. I know I can pass back the result from the function and I'm doing that already. I just want more control over updating the calling workbook.

Is it best to store the workbook name and table as public variables so they are visible within the called procedure?

Just really want to know what is the best way to handle this scenario. Any code samples would help too.

Many thanks as always.