Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to open a file and a hidden file and hidden toolbar | Excel Programming | |||
Hidden personal file not hidden anymore | Excel Programming | |||
PERSO.XLS IS HIDDEN FILE, HOW DO YOU OPEN IT | Excel Worksheet Functions | |||
hidden sheet to record open of file | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) |