Hey all,

I can set a filename with

sFileName = Application.GetOpenFilename

Is there a similar way to set the path as a variable?

Currently I am using a command:

Set oDoc = oAPP.OpenDataDoc("C:\January\File.xls")

with a bunch of editting to File.xls

I would like to change this to

Set oDoc = oAPP.OpenDataDoc(strPATH + "File.xls")

where I have opened some sort of dialog to set the Path for the current month.

Thanks in advance,

Lance