宏来复制数据 [英] Macro to copy data

问题描述

您好，

我正在开发一个宏，它将从另一个文件中复制不同的信息。我的问题是这些文件安排在每月文件夹中，并且新的文件一直在添加。如果数据始终来自同一个文件
会很容易，但事实并非如此。每隔四天左右，根据生产情况，会添加一个新的Excel文件，其中包含不同的名称，数据必须来自。

I am after developing a macro which will copy different pieces of information from another file. My issue is that these files are arranged in monthly folders, and new ones are being added all the time. It would be easy if the data came from the same file all the time but it doesn't. Every four days or so depending on production, a new excel file is added with a different name that the data has to come from.

可以这样做吗？或者这是不可能的，因为信息来自的文件每天都不一样？

Can this be done? Or is it not possible because the file the information comes from isn't the same one every day?

谢谢，

Alex

推荐答案

re："这可以吗？或者这是不可能的，因为信息来自的文件每天都不一样？"
$


是

re: "Can this be done? Or is it not possible because the file the information comes from isn't the same one every day?"

Yes

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