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