将数据从Internet Explorer导出到Excel工作表
问题描述:
大家好,
我有一个保存的Internet Explorer文件,在这里我的要求是我需要使用Excel VBA宏将IE文件中的某些特定数据提取到Excel工作表中.我是这个vb脚本和excel的新手,我在Google中进行了搜索,但不知道要在excel宏中做任何事情.
任何帮助将不胜感激.
谢谢.
Sathish.
Hi All,
I have an saved internet explorer file , here my requirement is i need extract some particular data from IE file to an excel sheet using Excel VBA Macros. I am new to this vb script and excel, I searched in google but I dont get any idea of doing in excel macros.
Any help is greatly appreciated.
Thank you.
Sathish.
答
通过我有一个保存的Internet Explorer文件",您是说您现在有一个.html文件?如果是这样,您应该能够使用DOM来解密内容.查找XMLDocument及其用法.
HTH
By "I have an saved internet explorer file", do you mean you now have a .html file? If so, you should be able to use the DOM to decipher the content. Look up XMLDocument and its usage.
HTH