have you created the new function gsgetfilecontrol()?
If not just copy it to the very end of the code
Public Function gsGetFilename(Optional rsInitialPathFName _
As String = vbNullString) As String
Dim vPath As Variant
vPath = Application.GetSaveAsFilename(rsInitialPathFName, _
"Microsoft Excel Files (*.xls), *.xls")
If vPath < False Then gsGetFilename = CStr(vPath)
End Functio
--
tmor
-----------------------------------------------------------------------
tmort's Profile:
http://www.excelforum.com/member.php...fo&userid=2105
View this thread:
http://www.excelforum.com/showthread.php?threadid=38907