我有一个存放在服务器上的宏,需要能够从连接到该服务器的不同工作站上运行。
目前我正在执行以下操作:
Application.Run ("L:\database\lcmsmacro\macro1.xlsm!macro_name")
我收到的错误信息是“在此工作簿中可能无法使用该宏#1004”。
我已经确保我的安全设置处于最低水平。
我如何从托管在不同服务器上的另一个工作簿运行宏?
使用加载项是否有帮助?
我认为您的语法缺少单引号:
Application.Run ("'L:\database\lcmsmacro\macro1.xlsm'!macro_name")
如果你需要向它传递参数,语法将是这样的:
Application.Run ("'L:\database\lcmsmacro\macro1.xlsm'!macro_name","param1","param2")
Dim relativePath As String, programFileName As String
Dim selectedProgramsFiles() As String, programsArrayLastIndex As Byte, I As Byte
For I = 0 To programsArrayLastIndex 'Loop through all selected programs
programFileName = selectedProgramsFiles(I)
relativePath = ThisWorkbook.Path & "\" & programFileName
Workbooks.Open Filename:=relativePath
Application.Run ("'" & relativePath & "'!ModuleName.Main")
Workbooks(programFileName).Activate
ActiveWorkbook.Close SaveChanges:=False
Next I 'For I = 0 To programsArrayLastIndex 'Loop through all selected program