Browse For a File or Path and enter in a cell
I will try to make my question clearer.
I would like to enter a file name in a cell and the path to that file name
in another to use later is a couple of macros.
I would like to use a browse type window (Like in Excel to find a "Save As"
directory location) to select the file and path to that file and have them
entered into a cell in Excel.
"Dave Peterson" wrote:
You could use:
Dim myFileName as variant
myfilename = application.getopenfilename
if myfilename = false then
'use hit cancel
else
activesheet.range("a1").value = myfilename
end if
But I'm not sure what you're really asking.
D. Jones wrote:
Is it posssible in Excel 2003 to Browse to either select a file name or path
that would be entered in a cell for reference or used in a macro?
--
Dave Peterson
|