kem

One method(among others).

Dim RawDataSheet As String
RawDataSheet = InputBox("What is the name of the file_
that contains the raw data?")
Application.Workbooks(RawDataSheet & ".xls").Activate
Range("A1").Select
End Sub

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Mon, 14 Jul 2003 13:28:35 -0700, "kem" wrote:

I want to be able to call a workbook (to copy data from)
based on the file name that the user inputs. The workbook
to be called would be already open (but there would likely
be other workbooks also open at the same time).

I tried something like this:

Dim RawDataSheet As String
RawDataSheet = InputBox("What is the name of the file
that contains the raw data?")
Windows("RawDataSheet").Activate
Range("A1").Select

Thanks in advance