Run Macro on OneDrive survey input LIVE

[spacebouncer]

Just found out about OneDrive's Excel Survey feature. Great...

Is it possible to run some code to process the data as surveys are completed. Live and online that is, rather than having to do from desktop excel.

Advice much appreciated.

 

[Smitty]

Unfortunately not with VBA. You might be able to do something with the Excel Services JavaScript API, but it's not very robust at this point.

I have code in my surveys in the backend workbook and generally run it as needed.

 

[spacebouncer]

Great. Thanks. No problem just to run on the backend workbook as you say. Will keep an eye on this for future reference.