急盼高手解答，谢谢了

Question

设置TDatabase的LoginPrompt属性为False就可以了

Answer 1

database.LoginPrompt：＝false;
设好user name ,password 就可以不跳出密码框了！打开excel:
var  ExcelApp,workbook:variant;
  begin
      ExcelApp:=Createoleobject('Excel.Application');
      ExcelApp.Visible:=false;
      Workbook:=ExcelApp.WorkBooks.Add;
      Workbook.Worksheets[1].Cells[i,j].value:=‘          ’;
      WorkBook.Saveas('Path');
      WorkBook.Close;
      ExcelApp.Quit;
      ExcelApp:=Unassigned;
  end;

Answer 2

用ADOConnection控件结合ADO数据访问组件可调用Excel数据,
TDataBase的LoginPrompt属性设为False