What can I do to get the data from the external workbook without saving it?
Ans: Probably nothing
The Excel workbooks should all be saved with the following code, nevertheless, if your plan is to retrieve the data in those workbooks.
Dim wbk As Workbook
For Each wbk In Excel.Workbooks
Consider adding the code on the line below Sub uebergebene_wo() here, like this:
' Fragt die Daten für Übergebenw WO ab
If you need to know more about SQL, it is recommended to go for the SQL Online Course today.