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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>