使用宏时报错：Compile Error Syntax Error This workbook 20:0 之后弹出一个

<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="21

Mac 再要你命3000[office2007].xlsm 无法使用宏 about fly_us HOT 3 OPEN

kennedy-han commented on August 18, 2024

Mac 再要你命3000[office2007].xlsm 无法使用宏

from fly_us.

Comments (3)

kennedy-han commented on August 18, 2024

control + alt + T 和 control + alt + O 可以用
control + alt + up | down 不可用

from fly_us.

F4bwDP6a6W commented on August 18, 2024

如果宏报错一般是excel版本的问题。

from fly_us.

Maecenas commented on August 18, 2024

#4
检查发现是宏中的 Declear 语句在64位系统上的适用性问题，已经检查修复，发了一个 Pull request。

from
Private Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long
to
Private Declare PtrSafe Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As LongPtr) As LongPtr

References:
https://msdn.microsoft.com/en-us/library/office/ee691831%28v=office.14%29.aspx?f=255&MSPPError=-2147217396

from fly_us.

Recommend Projects