Hello,

I am using a form to gather information and assigning some of the
information to a variable to use as a file name. My problem is that I need
to unload the form before I can pragmatically save the file. But if I
unload the file, I lose the variable value "strCSVFile". Is there a way to
save the value even if you unload the form?

Private Sub cmdOK_Click()
...
strCSVFile = "some file name"
Unload Me
Call BuildCSVFile(strCSVFile)
...
ActiveWorkbook.SaveAs Filename:=strPath, FileFormat:=xlCSV,
CreateBackup:=False
End Sub

Any help would be appreciated.

--
Thanks in advance,

Steven