Skip navigation

Topic

VBA File Browser

Home page › Community › Automation and VBA › VBA File Browser

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Beiträge
  • 15.02.2016 at 13:39 #35224
    Her…234
    Participant

    Hi,

    Why the syntax : [code]
    fileToOpen = Application _
    .GetOpenFilename(“Text Files (*.txt), *.txt”)
    If fileToOpen <> False Then
    MsgBox “Open ” & fileToOpen
    End If
    [/code]
    returns “error 438” ?

    How to browse directories using FlexPro VBA ?
    Thanks

    15.02.2016 at 13:39 #35226
    Her…234
    Participant

    Hi,

    Why the syntax : [code]
    fileToOpen = Application _
    .GetOpenFilename(“Text Files (*.txt), *.txt”)
    If fileToOpen False Then
    MsgBox “Open ” & fileToOpen
    End If
    [/code]
    returns “error 438” ?

    How to browse directories using FlexPro VBA ?
    Thanks

    16.02.2016 at 12:08 #35225
    Ber…ntz
    Keymaster

    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
    Beiträge
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.