Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Only files
I have a macro that goes to a specific folder and opens up any Excel file in
that folder. It then does some stuff to each file, closes the file, and repeats this process for each file in the folder. It works great 99 % of the time. Ocassionaly, a user will send in a "read only" file. When the macro opens one of these "read only" files, it causes the macro to fail. Is it possible to select a file and tell if it is "read only" before opening it? Is it possible to tell if it is "read only" after it has been opened and before the macro does any stuff to it? I would like to check if it is "read only" and skip this file if possible. Any suggestions or peices of code to accomplish this would be greatly appreciated. Thanks for the help..... -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read Only files
opens up any Excel file
Open the workbook in the normal way and check its ReadOnly property Regards, Peter T "JT" wrote in message ... I have a macro that goes to a specific folder and opens up any Excel file in that folder. It then does some stuff to each file, closes the file, and repeats this process for each file in the folder. It works great 99 % of the time. Ocassionaly, a user will send in a "read only" file. When the macro opens one of these "read only" files, it causes the macro to fail. Is it possible to select a file and tell if it is "read only" before opening it? Is it possible to tell if it is "read only" after it has been opened and before the macro does any stuff to it? I would like to check if it is "read only" and skip this file if possible. Any suggestions or peices of code to accomplish this would be greatly appreciated. Thanks for the help..... -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to save all files xls says can't - read only | Excel Discussion (Misc queries) | |||
Read From Files | Excel Discussion (Misc queries) | |||
Shared files - read only on the fly | Excel Discussion (Misc queries) | |||
read only files | Excel Discussion (Misc queries) | |||
how can i convert .dxf files to something i can read | Excel Discussion (Misc queries) |