I have one file which download data from web and format that data. need to add few more step in existing CommandButton2 after all process done.
Step 1 In .csv file - cell P1 past this text "<TICKER>,<DATE>,<OPEN>,<H
Step 2 in cell P2 past this formula till end "=A2&","&TEXT(K2,"YYYYMMDD
Step 3 Copy column P and past to new open .txt file and save as .csv file name
Step 4 Delete original .csv file
Step 5 Next .csv
In attached I am talking about A4 Cell Button.