PDA

View Full Version : extract data from notepad to xls



oracle_coorg
01-12-2007, 05:43 AM
hi
can i import the data from the notepad to xls THROUGH programm
data is like this:==
1986 Records, Jan 10 2007 1:27AM
No Data
60 Records, Dec 20 2004 9:39AM
No Data
1 Records, Jan 11 2007 12:02AM
i need to import this to new xls in column B row 5 6 7 9 10
this process contnious next column C ROW 5 6 7 9 10 NEXT COLUMN D ROW 5 6 7 9 10
TILL CW column load data from .txt file every half an hour
THANXS

mdmackillop
01-12-2007, 06:08 AM
Welcome to VBAX
Results will depend on your source layout. Can you attach an example of a text file? Use Manage Attachments in the Go Advanced section
Regards
MD