I can't work out if i'm missing something, but i need to get a Velixo function to calculate within a macro.
Essentially I'm inserting an SI.QUERY into a cell, then I want to copy the range and paste as values so I can then insert subtotals.
SI.QUERY doesn't execute until after my macro has ended despite trying application.calculate.
Any thoughts?
0 Votes
1 Comments
H
Harry Lewisposted
about 17 hours ago
Ben -
Currently Velixo NX is not able to integrate with VBA. We will discuss options with our Development team and get back to you. That process might be easier if you create a support ticket by contacting [email protected].
0 Votes
I can't work out if i'm missing something, but i need to get a Velixo function to calculate within a macro.
Essentially I'm inserting an SI.QUERY into a cell, then I want to copy the range and paste as values so I can then insert subtotals.
SI.QUERY doesn't execute until after my macro has ended despite trying application.calculate.
Any thoughts?
0 Votes
1 Comments
Harry Lewis posted about 17 hours ago
Ben -
Currently Velixo NX is not able to integrate with VBA. We will discuss options with our Development team and get back to you. That process might be easier if you create a support ticket by contacting [email protected].
0 Votes
Login or Sign up to post a comment