FileCopy命令 - Excel VBA中的运行时错误52 [英] FileCopy command - run time error 52 in Excel VBA

问题描述

我正在尝试将文件从SharePoint位置复制到网络文件夹。我可以将文件打开并另存为，但我真正需要做的就是复制它。


代码看起来像这样：

I''m trying to copy a file from a SharePoint location to a network folder. I can get the file to Open and save as but all I really need to do is copy it.

Code looks like this:

展开 | 选择 | Wrap | 行号

推荐答案

从Excel中打开文件使用的机制与使用文件系统复制文件的机制不同。虽然Excel知道如何连接到SharePoint，但文件系统本身却没有。

Opening a file from within Excel uses a different mechanism than using the file system to copy a file. While Excel knows how to connect to SharePoint, the file system itself does not.

啊......所以我不能在这里使用Filecopy命令而且会有打开并保存为。谢谢！

Ahhh... so I''m not going to be able to use the Filecopy command here and will have to open and save as instead. Thank you!

去年我有一个非常相似的问题

我在另一个论坛上遇到过这个问题。

Last year I had a very similar problem
I ran across this in another forum.

展开 | 选择 | Wrap | 行号

这篇关于FileCopy命令 - Excel VBA中的运行时错误52的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！