Hi experts,
I face troubles while trying to use SAVEWORKSHEETDATA with Excel/VBA event Worksheet calculate -> excel crashed each time.
my codre below :
Private Sub Worksheet_Calculate()
Dim EPMExample As New FPMXLClient.EPMAddInAutomation
If Range("G22").Value = "SUBMITTED" Then
MsgBox ("senddata") '-> works correctly
EPMExample.SaveWorksheetData -> leads to excel crashed
'Call SEND_DATAWS '-> leads to excel crashed
End If
End Sub
Note: in G22 cell, there is an Excel Formula
Tks for your help,
Olivia