open spreadsheet

**hvisa** · 02-02-2007, 10:07 AM

what is the command to say to open a excel spreadsheet in vba?
is there a way to open the spreadsheet without specifying the path , but the file to be opened will be in the same directory only .

the problem is the file which has the macro will be copied to other folders so, i can;t specify the whole path .

Thanks

**whisperinghill** · 02-02-2007, 10:12 AM

Sorry, tried to delete the post but to set the same folder use the Dir("") command This works, assumes same folder

[CODE]
Dir ("")
Workbooks.Open Filename:= _
"xxxxfilename.xls"
[CODE]

**hvisa** · 02-02-2007, 10:18 AM

it does not find the workbook... it says file cannot be found.

**jasoncw** · 02-02-2007, 10:22 AM

It should find it if you use the full path.

**whisperinghill** · 02-02-2007, 10:26 AM

Originally Posted by jasoncw

It should find it if you use the full path.

Jason, he doesn't want to set a path, that was his problem, I found the Dir("") command in the help file.

Worked for me, other wise if you don't set a path, then whatever your PC's default folder is, is where it looks, for most its the "My Documents" folder