Skip to Content
0
Aug 08, 2016 at 10:16 AM

senddata and vba event

67 Views

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