View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Browse For a File or Path and enter in a cell

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