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. |
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. |
All times are GMT +1. The time now is 08:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com