Code works fine on 2010 but not 2016

cr1999 Posts 4 Registration date Tuesday December 5, 2017 Status Member Last seen December 6, 2017 - Dec 6, 2017 at 03:52 PM
 Blocked Profile - Dec 6, 2017 at 04:32 PM
My company is having an issue we just updated our excel from 2010 to 2016, we have user forms that open a form to enter data but after we submit that data it goes and pulls from another source a template and is supposed to fill in the template. It works fine with 2010 but on 2016 it puts the data onto the workbook that opens the forms not to the template. it opens the template fine its just somewhere in the mix it paste the information onto the wrong excel file. The code to write to the template is below.

1 reply

Blocked Profile
Dec 6, 2017 at 04:32 PM
That code is not complete. There is some stuff that is referenced in the code, that has not been initialized in what was displayed.

So, I am going to delete the duplicate question that you posted yesterday, OK?