topic Re: how to find a path of a file? in VBA Forum

how to find a path of a file?

Anonymous — Fri, 25 Mar 2016 12:57:47 GMT

In the USERFORM of vba in acad, I have a button to find a file path by choosing it through the window, here is my codes, and it said, Object does't support this property or method. I have load the reference of Microsoft office library, and I can't find the reference of msofiledialog. Can you help me with this?

Dim fd As FileDialog
    Set fd = Application.FileDialog(msoFileDialogFilePicker)
    Dim vrtSelectedItem As Variant
    With fd
        .AllowMultiSelect = True
        If .show = -1 Then
            For Each vrtSelectedItem In .SelectedItems
                MsgBox "Selected item's path: " & vrtSelectedItem
            Next
        Else
        End If
    End With
    Set fd = Nothing

Re: how to find a path of a file?

Alfred.NESWADBA — Fri, 25 Mar 2016 23:36:18 GMT

Hi,

>> I have load the reference of Microsoft office library

This is a 32bit library, so in case you are running 64bit AutoCAD (>=2013 or >=2014, not sure at the moment) you'll have to search for a 64bit alternative (or search in Google for msoFileDialogFilePicker 64bit

Good luck, - alfred -

Re: how to find a path of a file?

Anonymous — Tue, 05 Apr 2016 03:01:49 GMT

Dear Alfred,

Sorry to reply late...

I am using the 2016 edition. Do you mean I need to download the msoFileDialogFilePicker 64bit? But I didn't find this file in Google or in our community. Do you have other solutions?

thanks.

Re: how to find a path of a file?

Alfred.NESWADBA — Sat, 09 Apr 2016 08:21:09 GMT

Hi,

>> Do you mean I need to download the msoFileDialogFilePicker 64bit?

I meant you will need to find an alternative to that.

- alfred -