Wait opening file
 

Hello.
I have a macro that need to browse for a file. I'm using GetOpenFilename
method. What i need to do now is to wait until the file is loaded to continue
the execution of the code.
Is this possible?

Thanks.

Wait opening file
 

Luis,

Try this...
Dim strFreshFile as String
Dim wkbFreshFile as Workbook

strFreshFile = Application.GetOpenFileName(what ever paramters you've got)
if strFreshFile < "False" Then
Set wkbFreshFile = Workbooks.Open(Filename:=strFreshFile)
end if

This should do the trick.
Dale Preuss


"Luis" wrote:

Hello.
I have a macro that need to browse for a file. I'm using GetOpenFilename
method. What i need to do now is to wait until the file is loaded to continue
the execution of the code.
Is this possible?

Thanks.