ActiveWindow.ScrollWorkbookTabs Sheets:=1
    ActiveWindow.ScrollWorkbookTabs Sheets:=1
    ActiveWindow.ScrollWorkbookTabs Sheets:=1
    ActiveWindow.ScrollWorkbookTabs Sheets:=1
    Sheets("z_Ablage").Select
    With ActiveSheet.QueryTables.Add(Connection:=Array( _
        "OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User" & _
        "ID=Admin;Data Source=D:\Dokumente und" & _
        "Einstellungen\Moschner\Desktop\CC_VER_A0" _
        , _
        "1.xls;Mode=Share Deny Write;Extended Properties=""HDR=YES;"";Jet" & _
        "OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Dat" _
        , _
        "abase Password="""";Jet OLEDB:Engine Type=35;Jet OLEDB:Database" & _
        "Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Globa" _
        , _
        "l Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet" & _
        "OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False" _
        , _
        ";Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact" & _
        "Without Replica Repair=False;Jet OLEDB:SFP=False" _
        ), Destination:=Range("A1"))
        .CommandType = xlCmdTable
        .CommandText = Array("Bündelerfassung$")
        .Name = "CC_VER_A01"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = True
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .PreserveColumnInfo = True
        .SourceDataFile = _
        "D:\Dokumente und Einstellungen\Moschner\Desktop\CC_VER_A01.xls"
        .Refresh BackgroundQuery:=False
    End With

MfG Lord_Duke
a.k.a. Loki

Design is 4 your Life and not for the others

________________________________________________________________
Windows XP Prof. SP 2 @ 2X 3,45 GHz P4 D ( 830) // DDR2 1024 MB //
GeForce 6600 GT Silent Pipe // 500 GB HDD