File Save - Properties 1

[dunkyn]

Any tips on how to save an Excel file and not let the user know the file name or where the file was saved?

I am thinking about saving a file on the network in a hidden folder, but I don't want the file to be accessible by the File menu.

TIA

 

[kylua]

Any files saved thru code do not come up on the recent files list or the documents menu on the start menu.

So it is just

Activeworkbook.saveas (mypath)

Of course, you would have to close the file immediately, or they can saveas and find the path. ( I tried Chdir and it didn't work.)
Whilst the file is open, it is very easy to find out where it is.

 

[GoodOmens]

If you can not close the file after the save, you could do the following:

Activeworkbook.saveas (mypath)
Activeworkbook.saveas (mypath2)

where mypath2 is a directory on the local computer, perhaps in Windows temp directory.

 

[dunkyn]

Great ideas. Thanks for the help.

Now that will throw them off track. I like it!

Thank you.