Thread: Share Workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Share Workbook

Try

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


--
__________________________________
HTH

Bob

"Stephen sjw_ost" wrote in message
...
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_PassCoun ts_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!
--
Stephen