Default location for adding attachments

[tommytxt]

Hi,

I apologise if this is a really simple request. I am quite new to this.

I have build a form that allows users to add an attachment to the table. I am just wondering how I can set the control to always open at a default location. For example, when a user clicks 'Add', it goes to c:\templates first?

I don't want to lock it down, just allow users to simply start at a default location.

Thanks in advance

Tom

 

[Gasman]

https://www.automateexcel.com/vba/open-file-dialog/

 

[arnelgp]

the default behaviour is look at MyDocuments.
for your purpose, you need a FileDialog and not use the built-in menu.
use command button and FileDialog.