Wait opening file

[Guest]

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.

 

[Guest]

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