ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing Default Module Location (https://www.excelbanter.com/excel-programming/311752-changing-default-module-location.html)

Ron Dahl[_2_]

Changing Default Module Location
 
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

Changing Default Module Location
 
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.

"Ron Dahl" wrote in message
...
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







All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com