View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Steph[_6_] Steph[_6_] is offline
external usenet poster
 
Posts: 92
Default browse to find file

Thanks guys!

"Bob Phillips" wrote in message
...
Check out GetOpenFilename in VBA help to show how to browse a file.

If you open it, you can then saveas to the new location and close it
immediately, after saving the name

ActiveWorkbook.SaveAs Filename:= ....
ThisWorkbook.Range("A1").Value = ActiveWorkbook.FullName
ActiveWorkbook.Close

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steph" wrote in message
...
Hello. Is it possible to have excel via vba allow a user to browse

through
folders (like when a user clicks on FileOpen), but instead of actually
opening the file they select, I would like the file to be copied to a
specified location (variable called infopath) AND also have the name of

the
file selected inserted into cell A1?

Thanks!