Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read MHTML document from Macro
Hi All,
I need to write a macro in which I am required to open a MHTML file and read its contents. I am currently using the following code - file_name = sPath & "\" & file.Name 'I am able to get the name of the file correctly in file.Name Open file_name For Input As #1 Do While Not EOF(1) Input #1, Mystring If InStr(1, Mystring, "<TD bgColor=#cae3e3<B") < 0 Then MsgBox Mystring End If Loop I am not able to figure out from where exactly does the value in Mystring gets populated from. I tried doing "view source" in IE on the mht file, but it doesn't exactly read all the contents from there. Any pointers?? Thanks much! Satish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove read ony from document | Setting up and Configuration of Excel | |||
How did my document become read-only? | Excel Worksheet Functions | |||
Save as mhtml loses custom document properties. | Excel Programming | |||
Save As MHTML loses custom document properties. | Excel Programming | |||
Why can't I write in a document that is not read only? | Excel Worksheet Functions |