How to automatically populate table fields with excel hyperlinks

[snwbrder01]

Hi,

I am a new user to this site, but I have looked at it before and it has been very helpful. So thanks for that everyone. Back to my question, is it possible to automatically populate table fields with hyperlinks to all worksheets within one excel file? For example:

Say I have Excel File "Client_Names.xls" with these worksheets; Sheet1, Sheet2, Sheet3, Sheet4, etc..

Can I automatically populated table fields with a hyperlinks to each Sheet1, Sheet2, and so on?

I am currently entering hyperlinks manually into each table field for each worksheet, which is time consuming because I do this monthly with multiple files that each contain multiple worksheets.

I enter the Client Name, then copy the datapath and paste, and then copy and paste the sheet name to create the hyperlink as follows;

Client Name#H:\Accounting\Tax\Sales\Client_Names.xls#Shee t1#

Is there a quicker way than this? Can VBA help with this process? I did not see any posts. Thanks!

PS I am using Access 2007.