Hello All,
I need a macro that copies the data from the notepad and pastes it onto an excel workbook.I have hundreds of data.
Presently the data is in the below form:
Name:
ABC
Age: 14 Country:India
I need the script to copy the above data from notepad and paste it to excel in the below format:
Name Age Country
Hello Vidya_1,
Welcome to the Forum!
This macro will parse a single text file for data you require and output that data to cells A2:C2 down to the last file entry. It is assumed cells A1:C1 contain column headers.
Change the variable Filename to match the path and name of the text file to parse.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks