查询tables.add连接上运行时错误-1004 - 需要帮助。 [英] Run time error-1004 on query tables.add connections - need help.

问题描述

展开 | 选择 | Wrap | 行号

推荐答案

这说的是某些东西没有正确格式化。


只是为了确定，这是在工作表级模块中使用的完全相同的代码吗？我在这里做的不是引用活动表格而是我会通过名称或索引来引用工作表。表单加载后，表单可能不会被视为活动状态。

what this is saying is that something isn''t formatted correctly.

Just to be sure, this is the exact same code that works in the worksheet level module? What I would do here is instead of referencing "activesheet" I would reference the worksheet either by name or index. It''s possible that the sheet is not being seen as active when the form has loaded.

不工作。我会得到运行时错误''-2147024809（80070057）'';

目标范围不在创建查询表的同一工作表上。


我正在努力实现的目标是刮擦craigslists URL第1页，它将其粘贴到工作表中，然后转移到为新的数据创建新工作表。


谢谢。


-Al

Not working. I would get the run-time error ''-2147024809 (80070057)'';
"The destination range is not on the same worksheet that query table is being created on."

What I''m trying to accomplish is as it scrapes craigslists URL 1st page, it pastes it in a worksheet then moves to creating a new sheet for the new scraped data.

Thank you.

-Al

不要在另一个应用程序上使用活动表要求excel。

替换ActiveSheet.Cells（I，2）.Value

，其固定名称链接到您的范围。

类似于另一个使用活动表的代码。


如果你在另一个应用程序的后台运行代码，不要使用.ActiveSheet或.ActiveWorkbook ==

don''t use activesheet on another application that call for excel.
replace "ActiveSheet.Cells(I, 2).Value"
with fixed name that link to your range.
similar to another code that use activesheet.

if you run code in background of another application, don''t use .ActiveSheet or .ActiveWorkbook ==

这篇关于查询tables.add连接上运行时错误-1004 - 需要帮助。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！