I need a macro so when the user hits a button in excel it subracts 50 from an external spreadsheet. For example there is a go button on the powerpoint. Once the user clicks it I want it to subtract 50 from the cell A3 in a spreadsheet located at C:\temp.xlsx.
I cant seem to find a way anywhere on how to do this. Any ideas?