View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default Function to open file

In Excel2000, I have the following function:

Function WC_Name(ByVal WC)

WC_Name = Application.WorksheetFunction.VLookup(WC,
Workbooks("master.xls").Worksheets("fall06").Range ("b4:n500"), 13,
False)

End Function

The problem is that it does not work if the "master" file is not open.
How can I have the function open the file if it isn't already?

Thanks