Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_Open
I need help with this code
I get the error message "runtime error '1004'" Private Sub Workbook_Open() ConflictResolution = xlOtherSessionChanges End Sub When i try to set the option manually from the thisworkbook property field i get the error message "Invalid Property Value". Can some please help me with this situation? Are there any alternatives to turn to?? thanks in advance Ernie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_Open
How about:
Private Sub Workbook_Open() ActiveWorkbook.ConflictResolution = xlOtherSessionChanges End Sub -- Gary''s Student - gsnu200728 "ernie" wrote: I need help with this code I get the error message "runtime error '1004'" Private Sub Workbook_Open() ConflictResolution = xlOtherSessionChanges End Sub When i try to set the option manually from the thisworkbook property field i get the error message "Invalid Property Value". Can some please help me with this situation? Are there any alternatives to turn to?? thanks in advance Ernie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_Open
Hi,
Thanks for responding. I tried what you suggested but unfortunately i get the same error message: Run-time error '1004' Application-defined or object-defined error Any other suggestions? Ernie Thanks "Gary''s Student" wrote: How about: Private Sub Workbook_Open() ActiveWorkbook.ConflictResolution = xlOtherSessionChanges End Sub -- Gary''s Student - gsnu200728 "ernie" wrote: I need help with this code I get the error message "runtime error '1004'" Private Sub Workbook_Open() ConflictResolution = xlOtherSessionChanges End Sub When i try to set the option manually from the thisworkbook property field i get the error message "Invalid Property Value". Can some please help me with this situation? Are there any alternatives to turn to?? thanks in advance Ernie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_Open
The workbook is shared ?
There was a recent post regarding this. I did a quick test in XL2002 and this setting (xlOtherSessionChanges) always fails for me. As there is no way to set this manually, maybe MS forgot to implement it, but the enum exists. NickHK "ernie" wrote in message ... Hi, Thanks for responding. I tried what you suggested but unfortunately i get the same error message: Run-time error '1004' Application-defined or object-defined error Any other suggestions? Ernie Thanks "Gary''s Student" wrote: How about: Private Sub Workbook_Open() ActiveWorkbook.ConflictResolution = xlOtherSessionChanges End Sub -- Gary''s Student - gsnu200728 "ernie" wrote: I need help with this code I get the error message "runtime error '1004'" Private Sub Workbook_Open() ConflictResolution = xlOtherSessionChanges End Sub When i try to set the option manually from the thisworkbook property field i get the error message "Invalid Property Value". Can some please help me with this situation? Are there any alternatives to turn to?? thanks in advance Ernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open doesn't run | Excel Programming | |||
Workbook_Open | Excel Programming | |||
Workbook_Open | Excel Programming | |||
How to use workbook_open()? | Excel Programming | |||
Workbook_Open | Excel Programming |