InputFile like the first pictuer
i want to result like the second pictuer,how to do?
@Luo ,
You can acheive this using VBA, write a macro in a text file and using exccel application scope open the target excel and run the VBA code activity with that text file macro.
For the macro check this link:
Thank you. It’s been settled
1 Like