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

Hi All,

I'm having a problem opening a file i VB.
VB seems to want the full path name and I just want it to look for the file
the is in the local folder that I'm running the VB from, but I don't know how
to do this.

I try: Workbooks.Open "test.xls"
&
VB wants: Workbooks.Open "C:\Folder\Test.xls"

Can I get around this?