I invoke MS Excel and MS Word 2013 from IBM Notes R9 to perform a mail merge to PDF. After the merge (and before creating the PDF) I need to run a macro on the merged data. I have the macro working. My problem is I cannot invoke it via lotusscript. It is in the Word Merge Template and also in Normal.dotm.
I get errors like
Instance member SHADE does not exist
Instance member MODULE1 does not exist
Microsoft Word: 'Run' is not a property.
depending on how I attempt to invoke it.
If I invoke manually it works fine.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …