OK I'm getting there! I've now got the function in the same place as the sub, so it can see the variable.

The code

MsgBox "You selected: " & ahtCommonFileOp enSave(InitialD ir:="K:Finance\ ", _
Filter:=strFilt er, FilterIndex:=3, Flags:=lngFlags , _
DialogTitle:="P lease locate the Connect file you previously saved")

This produces a message string "You selected...

Thanks Jeff,

I tried to declare the varaible at module level as Public Shared, however, VB just changes it to Public (module code below). The variable holds the correct value until it steps out of the module and back into the function that called it. I'm using Access 2000 unfortunately, would this be causing the issue?

Thanks for your help.

Public Function GetOpenFile(Opt ional varDirectory As Variant,...

Hi everyone,

I am a newbie to VB and making great use of various web resources to find answers. However, the simple topics don't seem to be covered anywhere.

Here goes. I have some code that opens the windows open file dialog box and prompts the user to locate the file. The file string is then stored in the variable varFileName. So far so good. I then want to use the file name in a DoCmd.TransferT ext command to get the...