Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to Create Input Box To Select a File
I am looking to crate an input box that will allow the user to select a file.
This will be like the browes option. The file selected will not need to be opened, just have the full path entered in the cell. This will be used to formualte a VLOOKUP form the selected closed file. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to Create Input Box To Select a File
You could use code similar to this...
Dim FileName As String FileName = Application.GetOpenFilename Range("A1").Value = FileName but you should look up the GetOpenFilename method in the help files as there are some optional arguments available that will let you customize things a little bit. Rick "Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message ... I am looking to crate an input box that will allow the user to select a file. This will be like the browes option. The file selected will not need to be opened, just have the full path entered in the cell. This will be used to formualte a VLOOKUP form the selected closed file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
Code for Select a file and save it in a different location | Excel Programming | |||
Pause code, wait for input, no input received, carry on with the code | Excel Programming | |||
Copy cells into another workbook with an input box to select the file | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |