help with closing csv file

[avishain]

hello there,

i got a macro which located in a xlsm file ,the macro is:

ThisWorkbook.SaveAs "c:\
("Username") & "_" & Format(Now, "ddmmyyyyhhmm") & ".csv", xlCSV
End Sub

when i hit the macro - my xlsm file turns into a csv file.

i want -once i hit the macro that both the xlsm and csv - will be closed automatically ...

now ,when i hit the macro - only the xlsm is closed (actually it turns to csv file) and i need to close the csv manually...


thank you

 

[AlphaFrog]

ThisWorkbook.SaveAs "c:\"
("Username") & "_" & Format(Now, "ddmmyyyyhhmm") & ".csv", xlCSV
[COLOR="Red"]ThisWorkbook.Close False[/COLOR]
End Sub

 

[avishain]

thank you very much!!