Allow User to Open File, but Do Not Allow to Save in Folder

[MatthewR]

I'm trying to write VBA that would allow users to open a file- but I don't want them to be able to save the file in the folder I have it in.



In other words, if they open a Word document and click Save, the Save As dialog will open and prompt them to save in another folder. But I don't want to make the files read only.

In other word, I want these files to function like files you download from an e-mail attachment. When you open a file from an attachment and hit save, it prompts you to Save As, even though the file is not read only.

Any idea how I do this with VBA? Thanks.

Matt

[MatthewR]

Oh, wait. E-mail attachments are read-only. So, I'm guessing if I don't want the user to save a file with the same name in the same folder, I have to make it read-only. Okay, nevermind.