VBA:打开指定路径的文件

得鹿梦鱼·人间无事

于 2024-10-22 20:38:53 发布

阅读量683

点赞数 2

文章标签： excel

本文链接：https://blog.youkuaiyun.com/qq_40569163/article/details/143167809

版权

都是一些代码片段，忘记了方便查

Function MQ(dict As Scripting.Dictionary, filePath As String)
    Dim fso As Object, modelFile As Object
    Dim ws As Worksheet
    Set fso = CreateObject("Scripting.FileSystemObject")
    Set modelFile = Workbooks.Open(filePath)
    Set ws = modelFile.Sheets(1)
    ....后续的逻辑
End Function