Excel isn't updating the cells when I Close the worksheet with VBA

Good afternoon,
I am currently on writing a vba code that does the following sequence:
1. Open a Userform
2. Open a second Excel Sheet
3. Copy userform input data to second excel sheet
4. Copy/Paste data from initial excel sheet to second excel sheet
4. Update the second Excel Sheet
5. Close and save the second excel sheet


Now my problem is that when i have the line: "Workbooks("test.xlsm").Close SaveChanges:=True " in my code, it doesn't update the cells. I need to update the cells because that data is getting transferred to a CAD software.
When I take out the Close and Save line, it updates the variables just fine, which triggers the CAD software to update.

I have tried multiple options like Application.Volatile or writing a VBA code to simulate hitting F2 and Enter in the specific cells


Thanks,






Below is the code:

Please Login or Register  to view this content.