Share Workbook

[Stephen sjw_ost]

I am using the following code to set my workbook in a sharedworkbook mode.

Application.DisplayAlerts = False
'
Windows("JAX_PassCounts_v0.9.8.xls").Activate
With ActiveWorkbook
.ConflictResolution = xlLocalSessionChanges
.KeepChangeHistory = False
End With
ActiveWorkbook.SaveAs Filename:= _
"\\nsusfla90ce01\cost$\OST\PASSCOUNTS\JAX_PassCounts_v0.9.8.xls",
AccessMode:=xlShared
'
Application.DisplayAlerts = True

I keep getting an error "Cannot access 'JAX_PassCounts_v0.9.8.xls'.
I have verified the path and file names are correct and viable. This code
use to work with no problems. What can I do to get it to work now? I have not
changed anything sense I first worte it with help from this forum.

Thanks for your help again!

 

[Bob Phillips]

Try

Workbooks("JAX_PassCounts_v0.9.8.xls").Activate