Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Read-only message
I have a macro that will open a read-only file - is there a code so that the
pop-up "this file is a read-only file, etc." doesn't pop up? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Read-only message
Set parameter 7 of the Open command to True to open read/write
Call Workbooks.Open("MyFile", , , , , , True) or to simply surpress the message set Application.Displayalerts = false (don't forget to turn back on again) DQ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Read-only message
Take a look at VBA's help for Open and you'll see:
Opens a workbook. expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad) So you'd do: dim wkbk as workbook set wkbk = workbooks.open(filename:="C:\something.xls", readonly:=true) .... CV323 wrote: I have a macro that will open a read-only file - is there a code so that the pop-up "this file is a read-only file, etc." doesn't pop up? Thank you -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read only message caused by camping out in file | Excel Discussion (Misc queries) | |||
Unable to read message | Excel Discussion (Misc queries) | |||
Saving spreadsheet gives read only error message | Excel Discussion (Misc queries) | |||
Help Read-Only message, Discussion group ideas all used | Excel Discussion (Misc queries) | |||
Message--MEMORY COULD NOT BE READ | Excel Programming |