i am looking for some vb code to open an existing workbook in a ne
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 boo
whilst keeping the form open. cannot seem to do this but thought i
might work if i could get it to open it in a whole new bookseparate t
the one with the form.

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

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=39016