Page 1 of 1

Copy specific rows from a notepad to excel.

Posted: Fri Dec 27, 2013 3:43 pm
by Anuj Dhawan
Hi,

I've been trying to write a vb-script to work for me as a tool - copy some "specific lines" from notepad to excel and put them in specific columns. With initial hiccups I believe that - there seem to be some products available in market for this very purpose and it feels like I'm trying to reinvent the wheel - said that, have someone of you has used something of this sort and have some pointers. If you do - please suggest - it''ll be a great help.

Regards,

Re: Copy specific rows from a notepad to excel.

Posted: Mon Dec 30, 2013 12:08 pm
by zprogrammer
Just trying to understand ..

How many lines you have in notepad?

Re: Copy specific rows from a notepad to excel.

Posted: Mon Dec 30, 2013 1:04 pm
by Anuj Dhawan
Thanks for the interest Pk. :)

Notpads are unload of STROBE report - so they vary in "number of lines" they have. It can start from 100 lines to 1 million.

I'm trying to pick up "CPU" time related information from the notepad.