Dim bk as Workbook
set bk = workbook.open( "C:\flder1\folder\excel.xls")

Not sure what you mean by link. But that creates a reference to the
workbooks which you can use to refer to it.

--
Regards,
Tom Ogilvy


"ceemo" wrote in
message ...

i am looking for some vb code to open an existing workbook in a new
workbook.

i have been using the following code

workbook.open "C:\flder1\folder\excel.xls"

but i would like to create a link on a VB form to open a new work book
whilst keeping the form open. cannot seem to do this but thought it
might work if i could get it to open it in a whole new bookseparate to
the one with the form.

the reason for this is i want to create a shortcut to the workbook the
user will pul information from the complete the form.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=390164