msoFileDialogFilePicker Throws Error: object variable with block variable not set

[arveearv]

Hi:

I'm trying to use this standard bit of code:

Dim fd As Office.FileDialog
Dim strFile As String

Set fd = Application.FileDialog(msoFileDialogFilePicker)

With fd
    .AllowMultiSelect = False

    If .Show = -1 Then
        strFile = .SelectedItems(1)

    End If

End With

But I'm getting the error message:
object variable with block variable not set

Any idea what might be going wrong? [Note that when I am entering the code, "msoFileDialogFilePicker" does not pop up from the References Library. Is it possible my system is missing this operation? If so, how would I add it to my resources? I'm a newbie to VBA -- please be kind!]


Arv

 

[arveearv]

Makes sense. Thanks so much, Fluff!

(I might just migrate this whole project to a PC and save the headache.) Thanks for finding the root of the problem.


Arv

 

[Fluff]

Glad to help & thanks for the feedback.

 

[arveearv]

I haven't tried this suggestion, but future users with the same problem may like this solution. It's VBA file-picking code that operates on both Mac and PC. I think it uses AppleScript code when it detects that the user is on a Mac:

Excel for Mac - Get File Dialog - Jasinski Technical Wiki

www.jasinskionline.com