VBA Code required to generate files from current worksheet .xlsx .csv (Comma delimited) & .txt (Tab delimited)

[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.


VBA Code:
Sub Make_File()

Dim WbNew As Workbook

Sheet2.Copy

Cells.Copy

Application.CutCopyMode = False

End Sub

Really appreciate someone help on this.

 

[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.


VBA Code:
Sub Make_File()

Dim WbNew As Workbook

Sheet2.Copy

Cells.Copy

Application.CutCopyMode = False

End Sub

Really appreciate someone help on this.

@Akuini

Looking your help on this.

Thank you in advance.

 

[Peter_SSs]

Duplicate to: VBA code to generate new workbook and save

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.