All the sample code I seem to find for VBA withing Outlook is for closed workbooks, open workbook-> post data->save and close book etc

I can't find anything to show any code to reference and write data to an open workbook, I'm simply looking to write say a "y" in cell A1 on workbook test.xlsm sheet1, just can't seem to find any working code.


Thanks