一段监听点击shape形状,获取形状位置的VBA代码,想换到JS宏,一直搞不定,请教一下写法

一段监听点击形状,获取形状位置的VBA代码,想换到JS宏,一直搞不定,请教一下写法 Dim folderPath As String Dim clickShp As Shape Dim shpPosition As String Dim fileName As String Dim dateNum As Integer Set clickShp = ActiveSheet.Shapes(Application.Caller) shpPosition = clickShp.TopLeftCell.Address folderPath = Range(shpPosition).Offset(0, 1).Value fileName = Range(shpPosition).Offset(0, 2).Value dateNum = Range(shpPosition).Offset(0, 3).Value Dim filesToOpen As Variant Set filesToOpen = FindFiles(folderPath, fileName, dateNum)
上海
浏览 73
收藏
1
分享
1 +1
1
+1
全部评论 1
 
wils
wils Lv.4 核心创作者

Lv.4 核心创作者

const clickShp = ActiveSheet.Shapes(Application.Caller()) const shpPosition = clickShp.TopLeftCell.Address()
   海南省
举报
0
0