| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress dialog while opening a write protected Excel document from VBS
Hello all,
I have the following problem: I have a VBS script which opens an Excel document using the assignment "Set objExcel = CreateObject("Excel.Application")" to access the VBA API for Excel2000. The script opens the workbook, fills in some attributes, saves the book and closes it. When the workbook is protected with a password, the VBS script displays a dialog in which I have to confirm to open the workbook with read permissions only. How can I suppress this dialog? Thanks Stefan P.S.: I am using the same mechanism for Word2000 and have the same problem with some dialog boxes. Is there a general way to disable this dialogs in office applications? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I write a macro to show the find dialog box in excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2000: suppress new document on excel startup | Excel Discussion (Misc queries) | |||
| Suppress dialog from regserver command | Excel Discussion (Misc queries) | |||
| how to suppress office assistance dialog | Excel Discussion (Misc queries) | |||
| Opening Protected XL Document | Excel Discussion (Misc queries) | |||
![Stefan[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
