Saving a non-Excel separate file and recording the URL

[Rocky Beach]

I am developing a small VBA program and I am looking for an easy way for my users to "attach" a source file to a table record. Ideally, I would like the user to be able to click a command button which brings up some kind of save as dialog box. The user could then drag and drop a file from their local computer or even an attachment straight from Outlook. When the dialog box is closed, I would rename the file with the record ID, save the file in a specific folder and add the URL to a field in the record. The user can then simply click on the URL to see the "attached" file. I know this is basically how the attachment process works in Outlook, but is there a way to do it in Excel?