Tejas Kore
Board Regular
- Joined
- Nov 2, 2017
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Hi Friends,
I have a .csv file. Due to some requirements I added 4 new columns with each having different formula applied to it.
Now the actual problem starts. After making this change I want to save this .csv file in .xlsb format as size of this .csv file is approx. 1.7GB.
After saving , the .xlsb file has cells which have resized to its actual content.Because of this every time I run the macro , I have to click on wrap text option in Home to make cells in default/normal size, that too two times.
The following is the code snippet of saving the file -
wb.SaveAs CSVPath & Split(wb.Name, ".")(0) & ".xlsb", FileFormat _
:=50, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Can anyone suggest me which step I am missing or where I am commiting mistake.
I have a .csv file. Due to some requirements I added 4 new columns with each having different formula applied to it.
Now the actual problem starts. After making this change I want to save this .csv file in .xlsb format as size of this .csv file is approx. 1.7GB.
After saving , the .xlsb file has cells which have resized to its actual content.Because of this every time I run the macro , I have to click on wrap text option in Home to make cells in default/normal size, that too two times.
The following is the code snippet of saving the file -
wb.SaveAs CSVPath & Split(wb.Name, ".")(0) & ".xlsb", FileFormat _
:=50, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Can anyone suggest me which step I am missing or where I am commiting mistake.
