LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 11
Default extract text from html files

okay, I have a file in microsoft excel. I have a column in there for a
description. However, my resource of all the descriptions are in html files.
All that is in the file is the description., I also need to be able to match up either the name of the html file or one
of the numbers in the html file to a catalog number in excel so that the
right description gets put on the same line as the item. The title of the
html file is the same as the item # inside the html file. Is there anyway to
pull the text out of the html files, with still keeping the model # or
whatever in excel?

(i.e. file number is 12345, and I have a column in excel with the same number 12345. I would like to be able to match the neumbers up so they would be in different columns but on the same line.

I will send anyone the files, if they want to take as look at the files, etc... Please let me know if you understand what I am
talking about. I know there may be othe rprogs out there, or even excel . I
kjnow its pretty powerful.

the column I want the description to go into would either be column F or G.

I would ike it if the # in the column for images could be matched up to the number of the file, or # inside of file, to column F or G. SO I do not have to sort all of these 1 by 1.
But be able to paste them all in the oprder of that #.

Also, if this is possible, to be able to take as many of ther html files at
one time, SO I do not have to do all of them 1 by 1. I have around 22,000
products I have to do this with. So I am looking for the easiest way to get
all of these in there.

someone told me there might be away to do this using macros, but I have no idea.

Thanks for any help you can give me.

Glowinafuse
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM
EXTRACT TEXT FROM A DATE Ronbo Excel Worksheet Functions 5 February 1st 05 07:39 AM
multiple text files URGENT tasha Excel Discussion (Misc queries) 1 December 19th 04 05:44 PM
importing multiple text files URGENT!!! HELP tasha Excel Worksheet Functions 0 December 19th 04 04:26 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"