Accessing Excel object methods through COM, how to skip optional positional arguments
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I am using the Component Ojbect Model (COM) interface to Excel. The following is a protoype of a method that accepts both positional and named arguments, all of which are optional [1].
expression.Add (SourceType, Source, LinkSource, XlListObjectHasHeaders, Destination, TableStyleName)
expression A variable that represents a ListObjects object.
The above is the "Add" method. If I invoke it from VBA, I can use named arguments to specify a subset of the arguments in the prototype.
Is there any way to do this via COM? From all that I've found online, positional arguments are used to invoke methods via COM.
NOTES
[1] https://learn.microsoft.com/en-us/office/vba/api/excel.listobjects.add
0 commentaires
Réponses (0)
Voir également
Catégories
En savoir plus sur Use COM Objects in MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!