VBA File Browser

SupportCommunity Automation and VBA VBA File Browser

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #12902
    HerveM1234HerveM1234
    Teilnehmer

    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

    #8562
    HerveM1234HerveM1234
    Teilnehmer

    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

    #9430
    Bernhard KantzBernhard Kantz
    Moderator

    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).

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.