View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jodleren jodleren is offline
external usenet poster
 
Posts: 49
Default Open file and keep it hidden

Hi all

Is there a way I can open a file, and keep it hidden?
I need to open some file, and change them then save them - the problem
is when excel is open, and I get a new window - it appear for 1-2 secs
in the task bar, and might be shown excel.
Can I avoid that?

if VarIsEmpty(ExcelApplication) then
try
ExcelApplication := GetActiveOleObject('Excel.Application');
except
ExcelApplication := CreateOleObject('Excel.Application');
//ExcelApplication.Visible := True; {enable this line for
debugging}
end;
ExcelApplication.DisplayAlerts := wdAlertsNone;
// ****** keep this hidden: *******
ExcelApplication.Workbooks.Open(ExtractFilePath(Pa ramStr(0)) +
'test.xls');

WBR
Sonnich