GetOpenFileName

sundar k replied to Seth Wolf at 09-May-08 11:02

I hope your macro code is only showing the openfile dialog ( using GetOpen FileName), do you want to hardcode the filename here instead of returning the selected value from browse dialog, then i think it will solve your problem, hope my understanding of your requirement is correct, let me know otherwise,

Sub OpenFile()
    Dim fileName
    
    fileName = Application.GetOpenFilename("Comma Separated Values (*.csv),*.csv")
    
    If fileName <> "False" Then

      //
    End If
End Sub



Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Using Refresh All in Macro - Seth Wolf  09-May-08 03:52 3:52:35 PM
      GetOpenFileName - sundar k  09-May-08 11:02 11:02:59 PM
          Refresh All automation - Seth Wolf  12-May-08 11:20 11:20:12 AM
View Posts