VBA Saved csv is retaining the Control Buttons - Not a "Real" csv file?

[Shiseiji]

Suggestions? I was rather surprised to open the csv file and see the control button's on the screen . . .

Sub m_copy_save_close()
    Sheets("Start Page").Select
    Sheets("Start Page").Copy
    Dim fname
fname = Application.GetSaveAsFilename(InitialFileName:="AtHoc_SP_", fileFilter:="Excel Files (*.csv), *.csv", Title:="Save As")
If fname = False Then Exit Sub
    ActiveWorkbook.SaveAs Filename:=fname
    ActiveWorkbook.Close False
End Sub

TIA

Ron

 

[starl]

Just because you call the file a csv doesn't mean it's a csv. You have to include the fileformat argument

    ActiveWorkbook.SaveAs Filename:=fname, fileformat:=xlCSV

 

[Shiseiji]

Thank you. I learn as I go as needed. I learned a long time ago I'll never be a "real" programmer. So I have to ask and borrow . . .

Ron

 

[starl]

Hey Ron - we're all learning here (yes, even I post questions. No one person can know it all)
The requirement of a file format is still relatively new, especially for users who are used to classic Excel.
Glad you asked (better than hitting your head against the keyboard. I don't recommend it )