Changing Default Module Location

[Ron Dahl]

When I right click on a module and choose "Export File", it defaults to a
specific folder on Drive C.

How can I change that default location for exporting and importing a module
file to a specific network folder?

I would prefer that it not change the default folder for opening and saving
workbook files.

Thanks in advance for any help.

Ron

 

[Bob Kilmer]

Don't know how do exactly as you ask w/o code. If you want to make your own
tool, take a look at http://www.cpearson.com/excel/vbe.htm and write a
utility that gives you this option.