Run-time error '91': Object variable or With block variable not set

[dsheard2015]

Hello,
I have created a worksheet on my windows pc with vba to select a file from the computer. The code runs when I select a button. When I try to use this same worksheet on my Mac and click the button to run the code, I get an error, "Run-time error '91': Object variable or With block variable not set. Help, Continue, End, Debug.

This worksheet and code has always worked from my windows pc and I only get the error when working from a Mac. Any help in correcting this error is greatly appreciated! When I select "Debug" on the error message, the line .Title = "Select Word file to attach" is highlighted. The code is below:

Option Explicit

Sub AddWordTemplate()

Dim WordTempLoc As FileDialog
Dim FirstRow As Long
Set WordTempLoc = Application.FileDialog(msoFileDialogFilePicker)
FirstRow = Sheet2.Range("E101").End(xlUp).Row + 1 'First Available Row

With WordTempLoc
    .Title = "Select Word file to attach"
    .Filters.Add "Word Type Files", "*.docx,*.doc", 1
    If .Show <> -1 Then GoTo NoSelection
    Sheet2.Range("E" & FirstRow).Value = Dir(.SelectedItems(1)) 'Document Name
    Sheet2.Range("F" & FirstRow).Value = .SelectedItems(1) 'Document Pathway
End With

NoSelection:

End Sub

 

[Joe4]

From the computer that works, go to VB Editor, and from the Tools menu, select References. Note all the references that are selected.
Now, repeat the process on the Mac. Are all the necessary references selected? If not, find the missing ones and select them.
Note that there might be slight variations in the version numbers, based on the versions of Office you have. Usually, you just want to pick the most recent one, if there is not an exact match.

 

[RoryA]

To the best of my knowledge, you just can't use FileDialog on a Mac. Check through Ron's site at macexcel.com

 

[dsheard2015]

From the computer that works, go to VB Editor, and from the Tools menu, select References. Note all the references that are selected.
Now, repeat the process on the Mac. Are all the necessary references selected? If not, find the missing ones and select them.
Note that there might be slight variations in the version numbers, based on the versions of Office you have. Usually, you just want to pick the most recent one, if there is not an exact match.

I checked the references from both computers and they match. Thanks for the advice!

 

[dsheard2015]

To the best of my knowledge, you just can't use FileDialog on a Mac. Check through Ron's site at macexcel.com

Thanks for your input. I checked out Ron's site and honestly, it may be a little bit over my head. I couldn't really find anything that matched what I am needing.