Reference for Office folder picker

[kirkm]

There's a line in Excel I'm trying to use in Access
Set BrowseForFolder= Application.FileDialog(msofiledialogfolderpicker)
But I get Variable not defined.

In Excel its definition says 'Member of Office.MsoFileDialogTypeDo I need to add a reference ? If yes, which?
Thanks

 

[arnelgp]

Go to VBE, on Tools>Reference, add Microsoft Office Xx. X Object Library.

 

[kirkm]

Thank you, all working