I run several macros in Excel that captures data from a Bluezone Display and pastes the data into Excel.
I run these on several computers, recently we purchased a new laptop, Windows 10, Excel 2016, 32Bit. and the macro will run in excel, I can watch it running in the BlueZone display and it all works correctly however at the end it does dot paste any data into the workbook.
Any Ideas?
I have tried another computer that is newer running the same versions and it works fine.
We have enabled the macro setting in the trust center.
PS. No errors are displayed, it runs like normal but just won't copy the data.