Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to save as a data input by user file name from a designated | Excel Discussion (Misc queries) | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Opening a file with User Input | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
INDEX, user input? | Excel Worksheet Functions |