问题描述
在Excel中为MS Office Professional Plus 2010使用VBA脚本。
Using VBA script within Excel for MS Office Professional Plus 2010.
尝试访问SharePoint站点中文档库中的CSV(逗号分隔文件)(SharePoint 2007 ),使用VBA脚本。
Attempting to access a CSV (comma delimited file) within a document library in a SharePoint Site (SharePoint 2007), using VBA script.
在Excel for MS Office 2003下运行时,VBA脚本成功打开CSV文件。 我正在迁移到Office 2010并尝试评估&更新为Office 2003编写的VBA脚本。
The VBA script successfully opens the CSV file when running under Excel for MS Office 2003. I am in the process of migrating to Office 2010 and trying to evaluate & update VBA scripts written for Office 2003.
用于打开CSV文件的VBA代码行是:
VBA line of code that is intended to open the CSV file is:
工作簿。打开文件名:=" " &安培; " RawData.csv",格式:= 2
问题症状:
我' m得到运行时错误'1004':Microsoft Excel无法访问该文件' RawData.csv"。有几种可能的原因:
I'm getting the Run-time error '1004': Microsoft Excel cannot access the file 'https://www.SPSite.Company.com/RawDataFolder/RawData.csv'. There are several possible reasons:
- 文件名或路径不存在
- 该文件正由另一个程序使用。
我花了大量时间审查寻找解决方案的网站。 我还没有找到解决方案。
I have spend considerable time reviewing web sites looking for a solution. I have not found a solution, yet.
任何人都可以帮我解决这个问题吗? 我应该尝试哪些想法? 我感谢任何帮助。
Can anyone help me with this issue? Any ideas that I should try? I appreciate any help.
推荐答案
这篇关于运行时错误“1004”:Microsoft Excel无法访问该文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!