I've been testing some code on different computers, and on some computers referencing a Workbook through the Worbooks("") class sometimes causes an error while sometimes works perfectly... The below code usually works, but crashes on one of our machines on line Workbooks("NLEAPGIS10").Activate. Is there a more consistent way to reference a Workbook?
Thanks!

vb Code:
  1. Dim sFileName As String
  2. sFileName = Application.GetSaveAsFilename("EVENTS_", "Excel files (*.xls), *.xls")
  3. If sFileName = "False" Then Exit Sub
  4. Application.ScreenUpdating = False
  5. Dim oBook As Workbook
  6. Set oBook = Application.Workbooks.Add
  7. Application.SheetsInNewWorkbook = 1
  8. oBook.SaveAs sFileName
  9. Workbooks("NLEAPGIS10").Activate 'Crash on some machines
  10. Workbooks("NLEAPGIS10").Worksheets("EVENTS").Activate
  11. Dim splicedName As String
  12. splicedName = spliceFileNameEnd2(sFileName)
  13. Worksheets("EVENTS").Copy Before:=Workbooks(splicedName).Sheets(1)
  14. Application.DisplayAlerts = False
  15. Workbooks(splicedName).Sheets("Sheet1").Delete
  16. Application.DisplayAlerts = True
  17. Workbooks(splicedName).Save
  18. Workbooks(splicedName).Close (False)
  19. Application.ScreenUpdating = True