ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open file and keep it hidden (https://www.excelbanter.com/excel-programming/439550-open-file-keep-hidden.html)

jodleren

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



All times are GMT +1. The time now is 03:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com