Consulting

Results 1 to 2 of 2

Thread: Application.Workbooks("try.xls").Close problem

  1. #1

    Application.Workbooks("try.xls").Close problem

    Hi,

    I'm trying to close an open excel using the code :

    Application.Workbooks("try.xls").Close

    This above line works in Excel 2007 but not in Excel 2003. It gives me this error: "Subscript out of range"

    Can anyone give me a suitable code that would work in Excel 2003?

    Thanks
    Justin

  2. #2
    Got the answer!!

    Justin

Posting Permissions

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