View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kletcho Kletcho is offline
external usenet poster
 
Posts: 36
Default Allowing User to save file

Dim sFilename as string

sFilename = Application.GetOpenFilename()
If sFilename = False Then Exit Sub

Sheets("Census Data").Select
Application.DisplayAlerts = False
With ActiveWorkbook
.SaveAs Filename:=sFileName, FileFormat:=xlCSV, CreateBackup:=False
.Close
End with