Change of default file location

[Rama]

Hi,

I am looking for help in MS excel:

I have two spreadsheets with names FileA & File B in directory structure:
"D:\Check\"

I wrote a macro in "FileA" to import some specific data from "File B" and
paste in "FileA" and close "FileB".

When i run this macro, I will get a window saying "Select the file you want
to import" pointing to "My Documents" folder. But i want the window to be
pointing to the folder in which i have "FileA" i.e.., to the directory
structure "D:\Check\"..

Expecting your help on this.

Thanks
Rama

 

[John Bundy]

Go to Tools->Options and select the general tab, near the bottom you can
enter any default path you would like beside the 'Default file location'.