Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Import HTML code from a text file.

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 111
Default Import HTML code from a text file.

Why don;t you save as HTML and then import into Excel as HTML?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Import HTML code from a text file.

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
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
Can I import raw HTML source code into Excel? J Diorio Excel Programming 5 July 11th 08 06:37 AM
How to import html file in excel 2007 AeonBlue Excel Discussion (Misc queries) 2 June 5th 07 11:27 PM
Import VBA Code in Excel-File ? (Export VBA Code to file) Matthias Pospiech Excel Programming 2 March 22nd 05 04:56 PM
Code to Save HTML table as xls file on click Joe Black[_3_] Excel Programming 5 December 9th 04 05:58 PM
Use VBA code to open a text file with the import wizard George Wilson[_2_] Excel Programming 2 September 10th 03 07:55 PM


All times are GMT +1. The time now is 10:02 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"