Calling an Excel macro from QV or vice versa

[burgersurfer]

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!

[biester]

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