I am saving a .xls file which is created through code in a sharepoint path.
With wNewBook
.Sheets(1).Activate
.SaveLinkValues = False
.SaveAs gt_AllFiles.sApprovalFile, FileFormat:=51, AccessMode:=xlExclusive, ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges
.Close
End With
but when ever I open this file and close, its keep asking to save changes even though there is no changes to save ..Please help
With wNewBook
.Sheets(1).Activate
.SaveLinkValues = False
.SaveAs gt_AllFiles.sApprovalFile, FileFormat:=51, AccessMode:=xlExclusive, ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges
.Close
End With
but when ever I open this file and close, its keep asking to save changes even though there is no changes to save ..Please help