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