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 OptionsGeneralDefault 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

wrote in message
ups.com...
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