| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a ReadOnly file in Excel VBA
hi people - hope you can help with this seemingly simple
bit of code! i have the line... Application.Workbooks.Open (JobListPath) which obviously opens a workbook. but the workbook it opens is readonly and i want to disable the "Readonly dialog box" that pops up. so i added... Application.DisplayAlerts = False Application.Workbooks.Open (JobListPath) but this does not seem to work, so i changed the line to... Application.Workbooks.Open (JobListPath,IgnoreReadOnlyRecommended:=true) but the syntax checker is complaining! what am i doing wrong!?!?! thanks in advance... demon ^waaaah^ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
| Excel thinks a file is ReadOnly but it is not. How to fix? | Excel Discussion (Misc queries) | |||
| Changing file from readonly | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| How do I use VC++6.0 to protect a excel file to readonly | Excel Worksheet Functions | |||
Threaded Mode
