Opening standard file folder while selecting file

[MrMyagiii]

Hi i`m using the following macro to import data from one sheet to another :

Please Login or Register  to view this content.

however this always opens library\documents so then i have to browse towards my folder where the input files are located. Is there a way to let this macro always open with for example C:/Program Files ?

[buran]

Use InitialFileName property of fd, e.g.

Please Login or Register  to view this content.

[MrMyagiii]

Perfect ! just what i was looking for. Thnx