Pulling data from word control drop boxes into specific excel sheets

[Artik]

Someone's gone crazy! I do not know if it's my computer, Excel or Word. In any case, the Change Tags procedure does not save the file! I do not know why.
To take it a step further, change the end of the BBB procedure so that the file and the Word application are not closed. After the macro completes, save the file manually and close it.
Change in the BBB procedure to

(...)
        Next CCtrl
        
        '.Close True
    End With


        'If Not boolIsWdRun Then
        '    wdApp.Quit
        'End If
        
        Set wdDoc = Nothing
        Set wdApp = Nothing


        MsgBox "Done"
End Sub

After changing the Tags, you can run [Download log data].


The attachment contains the correct file after changing the Tags.

It can not be ruled out that you will receive an error on line:

dDate = CDate(Split(CCtrl.Range.Text, ",")(1))

This may be due to the fact that Excel can not convert text in Date_Mon, Date_Tue, Date_Wed controls etc. If you will to receive an error in this line, change the date format in all controls on the first one in the list (see picture, sorry in Polish )

Artik