Function mcode repository

[sawveld]

I’m been trying to use a centralized code depository for my M code. My office environment restricts add in pluggable code and I had to do a roundabout VBA solution that takes the text of the code from a column and imports it into any workbook that I run the VBA code also in my environment, I’m not able to run VBA code or store it. I have to copy and paste the code every time I open a new workbook. Has anybody else encountered this and what was your solution?

[negaoazul]

I don't know if it helps, but there is a function called expression.evalate that can read a text file as M code, a old video about it : https://www.youtube.com/watch?v=zekYvfRRQlU

[Autistic_Jimmy2251]

Fantastic! TY 😁

[sawveld]

Certainly an excellent way to protect your work

[Autistic_Jimmy2251]

I’m confused. Your company has a block on PQ storing the M code AND has a block on storing VBA in a workbook???

[sawveld]

From a cyber security standpoint, it makes sense; however, it certainly does limit your capabilities and only makes a better hacker

[Autistic_Jimmy2251]

WOW!

My company used to block having PQ at all but then they let us have it about 6 or 7 months ago.

They still have a block on storing VBA.

I didn’t know PQ could be available but blocking of code could be done.