Results 1 to 2 of 2

Thread: [RESOLVED] Workbook referencing inconsistent?

  1. #1

    Thread Starter
    Hyperactive Member pgag45's Avatar
    Join Date
    Mar 2007
    Location
    Colorado
    Posts
    262

    Resolved [RESOLVED] Workbook referencing inconsistent?

    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

  2. #2

    Thread Starter
    Hyperactive Member pgag45's Avatar
    Join Date
    Mar 2007
    Location
    Colorado
    Posts
    262

    Re: Workbook referencing inconsistent?

    Actually figured it out...

    Just requires a .xls to be added to

    Workbooks("NLEAPGIS10").Activate

    so it would look like Workbooks("NLEAPGIS10.xls").Activate

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width