如何将数据从网站复制到Excel [英] How to Copy Data From Website to Excel

问题描述

我对VBA比较新，但是我试图从网站上复制数据（这个网站目前正在运行并且将是相同的）并粘贴到Excel中定义的工作表。下面是我到目前为止的代码，但是，我收到错误对象''IWebBrowser2'的'方法''ExecWB'''失败'。

Hi,

I''m relatively new to VBA but I am trying to copy data from a website (this website is currently running and will be the same) and paste to defined sheet in Excel. Below is the code that I have thus far, however, I am receiving an error "Method ''ExecWB'' of object ''IWebBrowser2'' failed".

展开 < span class =codeDivider> | 选择 | Wrap | Line数字

推荐答案

您是否设置了对库Microsoft Internet Controls的引用？

Have you set a reference to the library "Microsoft Internet Controls"?

是的，该引用已设置

确定更改此行

OK change this line

展开 | 选择 | Wrap | 行号

这篇关于如何将数据从网站复制到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！