Open the file in the path. Do text to columns to the entire sheet. Delete the Range (1 to 8 rows). Insert value zero in columns G1, I1, L1, N1, P1 only if they are balnk. Now do text to columns to Column G, L, N & P. Save the file as

Need macro for this. Please help.