View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
matt matt is offline
external usenet poster
 
Posts: 92
Default Opening a Workbook

I'm trying to write a subroutine that opens a saved
workbook that resides in the same directory of my active
workbook, so that I can pull data from worksheets in that
workbook. My subroutine looks like this:

Sub Try()
Workbooks.Open "saved workbook"
End Sub

When I run this, however, i get an error saying that the
workbook cannot be found. I tried using the full path and
anf file extensions as well, but no luck. Has anyone run
into this problem as well?