Code to download information from notepad and copying info to the excel

**deepikabalaji** · 09-19-2007, 07:19 PM

Hi all

Everyday system generates a notepad with the information.. from the notepad i ve to copy paste the info to the excel manually.

Can a code be written where (after downloading information to the excel from the notepad) it automatically fill the information in the excel.

For your reference i ve attached both notepad and excel with dummy datas.
(how i do manually)

**deepikabalaji** · 09-20-2007, 09:02 AM

Any updates ??

**dominicb** · 09-20-2007, 09:16 AM

Good afternoon deepikabalaji

It's not usually too tricky to extract data from a notepad (.txt) file. The problem in this case is that the data is formatted by having spaces inserted - there is no real handle or control character which you could build into some code to tell Excel when to move from one cell to the next.

All the sheet tab names at the top of each section would also be problematic.

Can your system provide some other form of output (eg .csv file etc).

DominicB

**deepikabalaji** · 09-20-2007, 09:37 AM

Hi

I am not sure, wat u mean by that..

Still i tried doing tat..
Just check the attached file if that helps..

Wat i know is..

I can download informations from notepad to excel in a seperate worksheet and delimit it... From tat i ve to copy paste information to the excel i ve as per the order manually...

I think macro code can do that

**dominicb** · 09-20-2007, 10:04 AM

Hi deepikabalaji

OK. By using the Text Import wizard, something like this will bring the text into Excel :

Please Login or Register  to view this content.

However, you want it splitting into several sheets. Will each group always consist of the same number of lines? Otherwise we'll have to use the header in column E to determine where to break from to transfer information to other tabs.

HTH

DominicB

**deepikabalaji** · 09-20-2007, 10:16 AM

No.. Sometimes it may increase and sometime it may decrease...

**deepikabalaji** · 09-20-2007, 12:13 PM

Any updates pls?

**deepikabalaji** · 09-20-2007, 02:48 PM

See if the attached one helps...........

I ve copied the information from the notepad and pasted in the attached excel - sheet 1. I ve also bolded the columns i am looking for daily.
1) Daily indexing (Row 49)
2) Daily Reveiwing (Row 80)
3) Daily Re index errors (Row 633)

Also there are 3 other sheets index-prod for indexing
Review prod for reviewing
Errors for Re index errors
where i need to fill the notepad information.

Kindly provide me the code for this.....

Let me know if this one is not clear

**deepikabalaji** · 09-21-2007, 07:41 AM

No updates? I hope the attached one is very mush clear.

**dominicb** · 09-21-2007, 09:09 AM

Hi deepikabalaji

OK. Try using this code. It should open your .txt file, sort it into three tabs according to the title of each chunk of data :

Please Login or Register  to view this content.

Obviously, you're going to have to change the path (marked in blue) to reflect where the .txt file will be on your system.

HTH

DominicB

**deepikabalaji** · 09-21-2007, 10:35 AM

Hi

I am getting error on the below one

a = Selection.Find(What:="Reviewing", After:=ActiveCell, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row

**deepikabalaji** · 09-21-2007, 01:22 PM

Hi
Thanks for your code.. actually the code is not providing the output i am looking for..

So, I ve again attached the excel sheet with the required output..

sheet 1 contains the information (i copy, pasted from notepad to the excel)
Its not in an aligned order
Now from sheet 1 i ve to copy paste the indexing, reveiwing and errors datas to the the respective worksheets. These datas i ve bolded in the sheet 1.

In the index-prod sheet i ve filled information for one user.. similarly for reveiw prod and errors.

Can anyone tell me how to make this automatically?

**VBA Noob** · 09-21-2007, 02:30 PM

Closed for cross posting.

Please read forum rules below. If you agree to these rules PM and I will unlock this thread. Once unlocked please add the link to the other post or posts

VBA Noob

**deepikabalaji** · 09-24-2007, 10:13 AM

Any thoughts??????????

**deepikabalaji** · 09-24-2007, 04:19 PM

No thoughts?????

(My hands are getting damaged by doing this manually)

**deepikabalaji** · 09-25-2007, 07:17 AM

Is that the thread not clear?

**deepikabalaji** · 09-25-2007, 01:03 PM

Is this task is very tough??

**deepikabalaji** · 09-27-2007, 07:48 AM

Can anyone help me out with this issue?

**deepikabalaji** · 09-28-2007, 01:29 PM

I am really in a need of your helps?

Anyone please comment on this

Code to download information from notepad and copying info to the excel

LinkBack

Thread Tools

Rate This Thread

Display

Code to download information from notepad and copying info to the excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions