Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting the html code of a wab page in a variable which I have
written to a file and saved as a .txt file. I am importing these code in excel for further processing. Is there a better way to write these code to excel sheet? Each line for code should be in new row in column A. Currently opening the file in excel writes the code in other columns if the code has indenting. Also if I can avoid creating a text file and then importing in Excel, it would be better and faster I belive. Can I perse the html code directly from the variable and write each line of code in col A new rows? Thanks. Nathpai |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why don;t you save as HTML and then import into Excel as HTML?
|
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for reply.
I have tried it just now. If I import the html in excel, Nothing is imported. Excel just shows the blank sheet. The same file if I open in IE, it opens after giving few script errors. But still for the same HTML file when opened in excel, shows a blank sheet. I have no idea why it happens this way. Thanks, Nathpai. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I import raw HTML source code into Excel? | Excel Programming | |||
How to import html file in excel 2007 | Excel Discussion (Misc queries) | |||
Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming | |||
Code to Save HTML table as xls file on click | Excel Programming | |||
Use VBA code to open a text file with the import wizard | Excel Programming |