Default import/export path

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,786
Office Version
  1. 2010
Platform
  1. Windows

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,527
Hi shg,

I can't see what's posted in that other forum. Apparently you have to login. I've given up on that forum along time ago. :)

Anyway, I think you can set the default path as follows...

Code:
File >> Options >> Save >> Default local file location

...no???
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,786
Office Version
  1. 2010
Platform
  1. Windows
I can't see what's posted in that other forum.

Alas, no joy there.

Thanks for that, Domenic, but no -- that's C:\Users\shg\Documents.

The path I mean is where the VBE takes you when you go to import or export a code module.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,527
Oh I see, you mean via the menu, not code, correct? If so, in my limited testing, it seems that the default path when exporting is the last exported path. If it no longer exists, then it uses the "Default local file location" specified in the settings. I didn't test importing, but probably the same thing applies.
 
  • Like
Reactions: shg

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,786
Office Version
  1. 2010
Platform
  1. Windows

ADVERTISEMENT

I exported a module to my preferred directory, closed and restarted Excel, and the default for import and export was back to Office14. Annoying.

Thanks for the suggestion.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,527
Yeah, very annoying, to say the least. So it looks like you have a Mac version of Excel. I guess, why keep behaviour consistent.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,786
Office Version
  1. 2010
Platform
  1. Windows
No, Excel 2010 on W7.

I need to buy a new computer this year, because W7 is EOL this winter, and I find the prospect daunting. My computer is configured exactly as I want, and I expect it will take a while to get its W10 successor the same.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,527
At one time, I too had Excel 2010 and Windows 7. It was great. I wish I could have stayed with them indefinitely. I only upgraded due to other considerations. Oh well. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,130,278
Messages
5,641,279
Members
417,202
Latest member
AndyVBA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top