Create a new and empty Excel file within your macro
Code:
Sub create_new_empty_excel_file()
Dim myNewFile As Workbook
'open a new and empty Excel file
Set myNewFile = Application.Workbooks.Add()
End Sub
-------------------------------
NEED HELP?
-------------------------------
Leave a comment with your questions, issues or projetcs and I will try to answer with a video.
-------------------------------
THANK YOU
-------------------------------
For watching my videos,
Your shares
And your comments!