Default Folder for Import/Export Module

  • Thread starter Thread starter robotman
  • Start date Start date
R

robotman

Is there a way of changing the default folder that VBA uses when I try
to import/export vba modules or userforms? It seems to always default
to the MSO install folder.

I found a couple posts asking about this, but no answers.

Thanks!

John
 
John,
I have both XL2000 & 2002 installed on W2K.
XL2002 defaults to the Office10 folder.
XL2000 defaults to the Desktop.
with Options>General>Default File Location="C:\Documents and Settings\<User
name>\Desktop" for both.

How I managed this I cannot tell you, but it is obviously possible.
A registry setting I would guess or may be because of both version on the
same machine.

A couple more Office apps default to:
Word2002: C:\Documents and Settings\<User name>
Word2000: C:\Documents and Settings\<User name>
Access2002: Desktop

How/why I can't tell you though.

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default folder for VBA modules 1
Excel 2011 Mac - Import Worksheets into a Single File 0
Changing Default Module Location 1
Can you write VBA to export objects 1
Export Code Module 5
Programmatic export/import code modules 2
export location 2
Export a module to .bas file -> No Password 2

Back
Top