Sub WriteLink()
ActiveCell.formula = "='c:\Mydocuments\Myfolder\[Book1.xls]Sheet1'!$A$1"
End Sub

--
Regards,
Tom Ogilvy

"bkey01 " wrote in message
...
Tom Ogilvy wrote:
*If the workbooks will be closed, you will have to have your macro
hard code
a reference to them. If they will be open, you can use the indirect
worksheet function.

--
Regards,
Tom Ogilvy

"bkey01 " wrote in message
...
Can someone please help me with linking multiple workbooks to a
listbox?
I have 32 excel workbooks full of charts and I want to link each
to
selection in a listbox on a master sheet.

Help!!
Thanks

I have 32 excel workbooks that have over 32 sheets in each. I have
created a 'Home' page that includes multiple list boxes. Each list
box
has 4 selections. I want to link the 4 selections to sheets that
are in
different workbooks.

i.e. Product ttl is in productttl.xls (sheet product tttl) and
size
1.75 is in productttl1.75.xls (sheet procutttl 1.75).

Hope this makes more sense.


---
Message posted from http://www.ExcelForum.com/
*

Thanks for the information. Can you provide me with an example of the
code for a hard code macro?

Thanks


---
Message posted from http://www.ExcelForum.com/