View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Just12341234 Just12341234 is offline
external usenet poster
 
Posts: 2
Default "Subscript out of range" error for: Workbooks("Test1.xls").Save

I am trying to save an open workbook (Test1.xls) using code in a second open
workbook (Test2.xls). I can not figure out why the following line generates
a "Subscript out of range" error. As far as I can tell My syntax is exactly
as the help indicates that is should be.

Workbooks("Test1.xls").Save

I am stuck! Any help would be much appreciated.

Thanks,
Dave