Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop up Read Only and Existing User !
Dear Expert,
Need to open a file from share drive. Normally, it would pop a READ ONLY message if there is someone usigng it already. But I use VB script to open and run that file. I can't see the read only warning ... Is it possible to force read only windows (if any) as well as pop up a windows saying who is using it Thanks Elton |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop up Read Only and Existing User !
This will open the file in read only:
Workbooks.Open Filename:=MyFile, ReadOnly:=True I'm not sure why you would need to see who has the file open if you want to open it as read only but make sure you have display alerts turned on (Application.DisplayAlerts = True) and step through the code to see what happens when someone else has got the file open. You can also add a Notify to the File Open command: Workbooks.Open Filename:=MyFile, ReadOnly:=True, Notify:=True But that kinda defeats the purpose of opening as Read Only to start with. "Elton Law" wrote: Dear Expert, Need to open a file from share drive. Normally, it would pop a READ ONLY message if there is someone usigng it already. But I use VB script to open and run that file. I can't see the read only warning ... Is it possible to force read only windows (if any) as well as pop up a windows saying who is using it Thanks Elton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can Excel user preferences be imported from an existing PC? | Setting up and Configuration of Excel | |||
How do I read unknown values from an existing chart? | Charts and Charting in Excel | |||
Set as read only based on user name. | Excel Programming | |||
Set as read only based on user name. | Excel Programming | |||
Can I set up a worksheet as read only for one user | Excel Programming |