VBA_projects

This is to store some of the VBA scripts written for different purposes

Unmerge_all_cells.txt

This is to unmerge all the merged cells in excel for better post-processing.

Please follow the steps:

1. please be noted files will be directly saved at the same path
2. for .xls files they need to change to .xlsx, we cant process .xls file at current stage
3. u may put all the target files into one folder
4. change the folder path in the VBA text file
5. create a new empty excel --> open the developer mode --> open visual basic --> copy paste the script in the editor and run the script
6. when the program is done, the empty excel file will jump to the froremost in the screen