VBA code to generate new workbook and save

[SamarthSalunkhe]

Hi All,

I am using below code to create new workbook using current sheet data, but in addition I want to generate 3 files (.xlsx & .cvc (Comma delimited) & .txt (Tab delimited))

also, I want to save generated files on beside the current workbook, or it should ask where we want to save all 3 files.

Sub Make_File()

Dim WbNew As Workbook

Sheet2.Copy

    Cells.Copy
    
    Application.CutCopyMode = False

End Sub

Thank you in advance.

 

[SamarthSalunkhe]

@Akuini

Looking your help on this.

Thank you in advance.