TransferText运行时错误3011 [英] TransferText runtime error 3011
问题描述
当我尝试将查询导出为HTML时,以下VBA代码失败:
The following VBA code fails when I try to export a query as HTML :
DoCmd.TransferText acExportHTML ,,"myQuery"," X:\出口.html"
DoCmd.TransferText acExportHTML, , "myQuery", "X:\export.html"
错误是:
运行时错误'3011'
Run-time error '3011'
Microsoft Office Access数据库引擎找不到对象'export.html'。确保该对象存在,并且您正确拼写其名称和路径名。
The Microsoft Office Access database engine could not find the object 'export.html'. Make sure that the object exists and that you spell its name and the path name correctly.
它确实存在*,我不能看到任何拼写错误。显然,这个错误还有其他原因。
Well it *does* exist, and I can't see any spelling mistakes. So obviously there is some other cause for this fault.
有没有人知道这可能是什么?
Does anyone have some kind of clue what this might be?
推荐答案
Hallo,Dave,
$
Dave Ballmer:
> DoCmd.TransferText acExportHTML ,,"myQuery"," X:\ export.html"
此代码适用于此。
您是否拥有X的书面许可:\?
标记
Hallo, Dave,
Dave Ballmer:
> DoCmd.TransferText acExportHTML, , "myQuery", "X:\export.html"
this code works here.
Do you have write permission on X:\?
Mark
这篇关于TransferText运行时错误3011的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!