Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a macro running in Excel to finalise a couple of things after my QV export. At the moment, i need to run the QV macro, then run the Excel macro manually after that
How can I call the Excel macro from within QV, or maybe even call the QV code from Excel?
Tried to do a TestFn(param1, param2) type code in Excel, and then in QV I did TestFn(Field1, field2) but QV does not like the brackets.
Thanks!
Actually, it's not QV which doesn't like brackets, it's VBScript. You should either use
Call TestFn(Field1, field2)
or
TestFn Field1, field2
Perhaps that is the solution. See e. g. http://wiki.mcneel.com/developer/scriptsamples/parentheses
Rgds,
Joachim