Forum Discussion
Solved
need help with saving a sheet to a new workbook csv
i found this code nomFichier = ActiveWorkbook.Path & "\" & "_" & ActiveSheet.name & Format(Now, "_yyyymmdd") 'ActiveSheet.Copy 'ActiveWorkbook.SaveAs nomFichier Application.DisplayAlerts = ...
No,
It copies the active sheet to a new workbook.This new workbook is now the active workbook.
This will be saved as a .csv file and then closed. You are left with the original, unchanged workbook.
will that just close my workbook ?
No,
It copies the active sheet to a new workbook.This new workbook is now the active workbook.
This will be saved as a .csv file and then closed. You are left with the original, unchanged workbook.
- Thank you so much