LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Running macro with parameter

I am trying to run a VBA macro on excel with 5 parameters

I have base my design on example found here, but I keep getting an error message

 

 

Exception occured in Microsoft Excel: 
Impossible d'exécuter la macro 'PVC-A305-05-MACRO-MULTI.xls!MACRO_Multiposition.MACRO_Multiposition'.
Il est possible qu'elle ne soit pas disponible dans ce classeur ou que toutes les macros soient désactivées.
Help Path is xlmain11.chm and context 0 dans TEST_RunMacro.vi

 It basically say : impossibility to run the macro.... it possible than it is not available or every macro are disable...

 

on the Macro input I am putting "PVC-A305-05-MACRO-MULTI.xls!MACRO_Multiposition.MACRO_Multiposition" am I wrong ? I try several variation of the name and design

 

I lurk on the site but didnt found any example matching exactly what I was try to do .....

 

0 Kudos
Message 1 of 3
(2,823 Views)

I'd probably guess the latter: macros are disabled. Did you try the Excel macro example that ships with LabVIEW? Does that work? Have you checked to see what your macro security settings are in Excel?

 

0 Kudos
Message 2 of 3
(2,814 Views)

I manage to run the Macro I was Wrong about the name of the macro I add only to write the last part (xxx!yyy.zzz => zzz)

 

I will post a complete VI later

0 Kudos
Message 3 of 3
(2,808 Views)