Excel Macro - save as values and email

[Sandwichno1]

Hi,

Does anyone know how to create a macro that will save a websheet with DBRW as values and then email based on a cell reference, I can probably do this bit but stuck on the temporary saving the websheet as values to email.

This is so we can send out budget information to budget holders with them needing a license to view the data.

Thanks

[gtonkin]

Based on your profile, I am assuming that you are using PAfE and not Perspectives.

In PAfE, you can use the Unlink related functions in the API to make any TM1 related functions static for the selection, sheet or workbook.
https://ibm.github.io/paxapi/#unlinksheet

[JohnO]

Maybe use one of the tools from IBM Partners who have put this into their Excel add-in's while IBM has failed to do so.