View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree23[_2_] scrabtree23[_2_] is offline
external usenet poster
 
Posts: 25
Default Code for Opening a Closed Workbook

I am trying to open a closed workbook using VBA code. I
used this code:

Workbooks("Functions.xls").Open

In the "ThisWorkbook" Object using a Workbook_Open () and
got a "Subscript out of range" error.