Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
theo.bot
in reply to: dibujocad

This worked for me in the past:

 

Dim oExcel As Object
oExcel = CreateObject("Excel.Application")
  ' If there is more than one macro called TestMacro,
  ' the module name would be required as in
  '
  ' oExcel.Run "Module1.TestMacro"
  '
  ' to differentiate which routine is being called.
  '
  oExcel.Run "TestMacro"