Clever-Excel-Forum

Hallöchen,

dann must Du auf das entsprechende Dokument irgendwie verweisen, z.B.

Workbooks("xxx.xlsx").Sheets("yyy").Cells(z,1) = ...
Workbooks("xxx.xlsx").Sheets("yyy").Cells(z,11) = ...
Workbooks("xxx.xlsx").Sheets("yyy").Cells(z,111) = ...


oder

With Workbooks("xxx.xlsx").Sheets("yyy")
.Cells(z,1) = ...
.Cells(z,11) = ...
.Cells(z,111) = ...
End With

Oder

Set myBook = Workbooks("xxx.xlsx")

mybook.Sheets("yyy").Cells(z,1) = ...
mybook.Sheets("yyy").Cells(z,11) = ...
mybook.Sheets("yyy").Cells(z,111) = ...

oder ...