Pass Parameters via button in MES to excel / VBFORM Button to send data to Excel

Hello,

I would like to know if it’s possible to have a customization on the start activity button in MES that will pass the job number in to a excel worksheet. Then once end activity button is click the excel file is deleted.

ideally a VBFORM Button to send data to Excel

Reason: I am looking to write some vb code in excel to so some stuff for a report as for testing.

I am not sure of the code to pull data from the job no. field.