Macro which converts all the columns into text with given conditions

[sat1591]

Hi All,

I need a perfect coding for the below query.

Query:

There are two excel sheets one with greater than 500,000 rows, 52 columns(consider WB1.xlsx) and less than 500,000 rows, 52 columns(consider WB2.xlsx).

I need one VBA code such a way that all the columns in the workbooks should convert to text, Paste Special all the rows and columns and autofit itself.

But the condition is,
*If we are using WB1.xlsx the macro should do the above task and split into half, save in the some directory which i specify the path with some different names.

*If we are using WB2.xlsx the macro should do the above mentioned task and save in the some directory which I specify the path. No need of splitting the workbook.

This is the coding which i have recorded. But unable to create with above conditions. I do not know VBA but i can understand the steps

Please Login or Register  to view this content.

Please note: My file size is around 100MB because of lots of rows and columns so thats why I am attaching the small sized sample file.
Please Help!!