VBA语法错误 [英] VBA Syntax error
问题描述
您好,
VBA新手;
我有以下代码:
公共函数runEPMRefreshWorkSheet()
Dim lsstr As String
$
  ;   Dim epm As New FPMXLClient.EPMAddInAutomation
  On Error Resume Next
  epm.OpenBookPublicationWizardOnSpecificTemplate(" CTL_ISP_DRAFT","")
  epm.RefreshActiveSheet
结束功能
Public Function runEPMRefreshWorkSheet()
Dim lsstr As String
Dim epm As New FPMXLClient.EPMAddInAutomation
On Error Resume Next
epm.OpenBookPublicationWizardOnSpecificTemplate("CTL_ISP_DRAFT", "")
epm.RefreshActiveSheet
End Function
我在OpenBookPublicationWizardOnSpecificTemplate上收到错误,说"预期:="
I am getting an error on OpenBookPublicationWizardOnSpecificTemplate saying "Expected: ="
您能指导我如何解决这个问题吗?
Can you please guide me on how i can fix this?
推荐答案
我的朋友,
这个问题很容易解决。
删除(和)
使用VB(或VBA),()表示你有一个返回值
Using VB (or VBA), () indicates that's You have a return value
那么你的代码可能是:
Then Your code could be:
epm.OpenBookPublicationWizardOnSpecificTemplate "CTL_ISP_DRAFT", ""
祝你好运!
Anderson
这篇关于VBA语法错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!