Andy,

Use a chdir statement.
ie
ChDir ("C:\My Excel Files")
TxnFilename = Application.GetOpenFilename("All Files (*.*), *.*", 1, "ImportTransaction Details for List")

Dan E

"Andy" wrote in message ...
Hi I apologise if I am asking a commonly question this newsgroup has
answered before.

I pick up a file selected by the user. I want to specify a default folder
from where my user can select his transaction file. Is this possible?

This is what I am currently doing.
TxnFilename = Application.GetOpenFilename("All Files (*.*), *.*", 1, "Import
Transaction Details for List")

Thanks
Andy