FlexPro Forum – Discuss Your Topic!

VBA File Browser

Home > Community > Automation and VBA > VBA File Browser

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 15, 2016 at 1:39 pm #12902
    HerveM1234HerveM1234
    Participant

    Hi,

    Why the syntax : 

    
fileToOpen = Application _
    .GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen  False Then
    MsgBox "Open " & fileToOpen
End If

    returns “error 438” ?

    How to browse directories using FlexPro VBA ?
    Thanks

    February 15, 2016 at 1:39 pm #8562
    HerveM1234HerveM1234
    Participant

    Hi,

    Why the syntax : 

    
fileToOpen = Application _
    .GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen <> False Then
    MsgBox "Open " & fileToOpen
End If

    returns “error 438” ?

    How to browse directories using FlexPro VBA ?
    Thanks

    February 16, 2016 at 12:08 pm #9430
    Bernhard KantzBernhard Kantz
    Participant

    GetOpenFilename() is (as the error 438 states) no part of the FlexPro object model. It is a function from the Win32 API (and also mimicked by MS Office applications).
    You may use the FileDialog property to display a file chooser. An example can be found in the online help (Index: FpFileDialog (object), follow Example link).

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.