Thread
:
get file name inside a macro on Excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
external usenet poster
Posts: 5,441
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
Reply With Quote
Bernie Deitrick
View Public Profile
Find all posts by Bernie Deitrick