Change of default file location
 

Hi,

I am looking for help in MS excel:

I have two spreadsheets with names FileA & File B in directory structu
"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

Change of default file location
 

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'.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rama" wrote:

Hi,

I am looking for help in MS excel:

I have two spreadsheets with names FileA & File B in directory structu
"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