losing variable after "unload me"

[Steven K]

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.

 

[JE McGimpsey]

One way:

Hide rather than Unload the userform:

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