Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share Workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Share a workbook | Excel Worksheet Functions | |||
How can I share and un-share a workbook using a macro? | Excel Programming | |||
Share workbook | Excel Programming | |||
Can't share workbook. The "Share Workbook" option is off. Why? | Excel Discussion (Misc queries) | |||
Share workbook | Excel Worksheet Functions |