Macro to save specific column on specific sheet as xlsx

[MasterBash]

Hello,

Attaching workbook : test.xlsb

I am trying to save Column B of sheet "Excel Tracking" as a xlsx, while also keeping the "Table". In other words, I don't want to paste values only, I want to paste column B, including the header and table so a new workbook.

The file name should be A2 of the "Main" sheet. In this example, it will save as 55667799.xlsx

I currently a vba that saves the file as .txt, but I am trying to save as xlsx. It is not as simple as simple changing the extension. Although it saves as .xlsx, I can't open the file, because it is corrupted.

Current vba code :

Please Login or Register  to view this content.

I really like this, because it is easy for me to save the file to a specific path.

I am wondering how I can modify this code to save it as .xlsx instead of .txt

[jdelano]

You could do something like this:

Please Login or Register  to view this content.

EDIT: if you click no to deleting the exiting file the code exits

[Sintek]

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

[MasterBash]

You could do something like this:

Please Login or Register  to view this content.

EDIT: if you click no to deleting the exiting file the code exits

Thank you !! That works great.