I did it. its's not very effective way but the result is what i want. Method is before paste text use Find function in excel to find first head of column ("Member code") close Find window arrow down one time and paste. //Data Sorting: Word to Excel V4 //Complete //set file destination Let>OPfilename...

thank you for advice. I changed method to "after copy text, use GetClipBoard to get data and put into excel by XLSetCell". It work but something still off. the text data has 3 lines. when i put it with XLSetCell, all of 3 lines was put into single cell. are there a ways to put those 3 line in diffre...

Topic: how to select excel's cell via Macro Scheduler I'm writing a script to copy text message from docx file to excel file. the method i used is "use select all and copy all text in docx file and paste it in excel" my script is work except one thing, i can't select which cell in excel to paste the...