Hello, i have following Code:
Path ist already set and workbookwith this path opens
If i Debug step by step then at "*1" iam inside workbook AusS, meens the start workbook.
If i execute it, then it switch to the new open workbook at a random point in (*1)
what can i do?
thx
Code:
'Quelle definieren
Dim AusS As Workbook
Set AusS = ThisWorkbook
'noch prüfen, dass die Zieldatei nicht bereits geöffnet ist
If Datei_Geoeffnet(Path) Then
MsgBox "File blocked!"
GoTo ende
End If
'Ziel öffnen
Set WB_Urlaub = Workbooks.Open(Filename:=Path)
AusS.Activate
*1 .... many code
...
ende:
Path ist already set and workbookwith this path opens
If i Debug step by step then at "*1" iam inside workbook AusS, meens the start workbook.
If i execute it, then it switch to the new open workbook at a random point in (*1)
what can i do?
thx