| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress dialog while opening a write protected Excel document from VBS
The workbooks.open command allows you to specify how you want the workbook
opened. If you use those arguments, you won't get prompted. expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU) See help for details. -- Regards, Tom Ogilvy "Stefan" wrote in message om... 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) | |||
Threaded Mode
