if you retriving execel data in ado recordset then you can set progress bar max property to adorecordset.recordcount you may have to set cursorlocation property set to client side of recordset if recordcount =-1