View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
tmort[_6_] tmort[_6_] is offline
external usenet poster
 
Posts: 1
Default Save As File Control


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