Hello all,

I'm trying to open a shared workbook, do some manipulations to it that can't be done if in shared mode, then save it as shared once again...My thought process was this:
1) Open and unshare
2) Perform necessary steps
3) Save again as shared

For some reason in a XL 2007 code module when I use this code I get an error saying I can't access the workbook:
Code:
''''''''''''VARIOUS CODE  
Workbooks.Open(MyFolder & "\" & MyDate & _
"_Monthly_BS_Review.xls").ExclusiveAccess  
''''''''''''VARIOUS CODE  
ActiveWorkbook.SaveAs Filename:=MyFolder & "\" & MyDate & _  
"_Monthly_BS_Review.xls", AccessMode:=xlShared, FileFormat:=xlExcel8
But if I do this, it works just fine:
Code:
''''''''''''VARIOUS CODE  
Workbooks.Open(MyFolder & "\" & MyDate & _
"_Monthly_BS_Review.xls").ExclusiveAccess  
''''''''''''VARIOUS CODE  
ActiveWorkbook.SaveAs "TESTWORKBOOK.xls" ''''''UNNECESSARY STEP?  

ActiveWorkbook.SaveAs Filename:=MyFolder & "\" & MyDate & _
"_Monthly_BS_Review.xls", AccessMode:=xlShared, FileFormat:=xlExcel8
Any ideas?