get file name inside a macro on Excel
 

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

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

get file name inside a macro on Excel
 

Thank you very much for your help, was very useful simple and elegant.