Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The first thing I did to try this was manually open a file read-only
while in record-macro mode and save the macro. There is nothing in the macro to indicate the file should be opened read-only. In fact, if I then reopen the file using the macro it is NOT opened read-only. So, the big question is is there no way to open a file read-only via a macro OR is the 'record macro' function busted. btw - I did check the open methods and there are no parameters documented to control this either. I also discovered a 'permissions' object that sounds like if might help, but there has been nothing recorded in my macro and so don't see any good examples of how I might use it. -mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
read only file-need to write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
How do I write an Excel macro to open a file using the CommonDial. | Excel Programming | |||
Open file to write and read at the same time | Excel Programming |