View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kem kem is offline
external usenet poster
 
Posts: 1
Default User Input File Name

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