Saving Excel file

[kenguru]

Hello,

I have an excel file, which i open with a common dialog box and then i write some things in it and i want to save it and close it.
It seems easy, but the problem is the excel generates a "resumes.xlw", and i don't know how to exclude this.
My code is the following (shorted):
dlg.ShowOpen
Workbooks.Open dlg.FileName

...
Set xlSheet = Worksheets.Add
xlSheet.Range("B" & 3).Value = xlSheet_adatok.Range("B" & 1).Value
...
...
Application.SaveWorkspace
Application.Quit
Unload Me

Thank you

 

[HughLerwill]

in place of;

Application.SaveWorkspace

I suggest you try the .Save and .SaveAs methods; see VBA help.

HTH Hugh

 

[kenguru]

I tried, and it creates that "resume.xlw" file, which is a problem because at the second running of the program it's asking to overwrite it. I don't need that question

 

[HughLerwill]

'see VBA help' again

Application.SaveAs Filename:="MyFile.xls", FileFormat:=xlNormal

will save it as an .xls