View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default get file name inside a macro on Excel


Dim FName As String
FName = Application.GetOpenFilename
MsgBox FName

HTH,
Bernie
MS Excel MVP


"Get a file name inside a macro" <Get a file name inside a wrote in
message ...
I need to insert a pause inside a macro, then browse (throught Insert,
Picture, From file) copy the file name, put inside of a variable and resume
the macro.
Any help will be very appreciated.
Thank you