Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Multiple lines of text in a single Excel Cel
I sell merchandise on ebay, and have been looking for a faster way t list. What I do is take and Excel Data Source, and run a mail merge o the html code i post on Ebay (via a 3rd party listing company). So, i I have 50 data entries in Excel, I will generate the code utilizin Mail Merge 50 times. This was the easy part. My Problem is, that I am trying to take each instance of my html code and trying to copy or import it into 1 Excel Cell. As you all ar probably aware, utilizing the import utility will span across multipl cells. I would like to take my data, set some type of delimeter, and impor all of my code into one cell, so I can upload easily and quickly. would rather work on this for a few days, then list a bunch of item slowly. There has to be a way of doing this. I am somewhat technical but all I can really do in Excel is a couple of simple calculations. Definitely not an expert! I have a sample text file, with 2 instance of the HTML code. Help!! Best Regards, Natasha Cook +---------------------------------------------------------------- | Attachment filename: formletter.txt |Download attachment: http://www.excelforum.com/attachment.php?postid=376912 +---------------------------------------------------------------- ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Multiple lines of text in a single Excel Cel
this macro will open an html, copy each line into the A1 cell. - modif this to include your other html files Sub gethtml() fn = "c:\test.htm" Open fn For Input As #1 Do While Not EOF(1) Line Input #1, a Cells(1, 1).Value = Cells(1, 1).Value + Chr$(13) + a Loop Close #1 End Su ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing multiple lines into Excel from txt. | Excel Worksheet Functions | |||
How to split wrapped text in a single cell into multiple lines | Excel Discussion (Misc queries) | |||
Importing multiple forms into a single Excel list | Excel Discussion (Misc queries) | |||
two lines of text in a single row? | Excel Discussion (Misc queries) | |||
two lines of text in single row | Excel Discussion (Misc queries) |