Solved: opening excel file using VBA

[maddiashok]

Hi Friends,
I am New to VBA.

I have a query.
I am trying to open an excel file using VBA.
Excel file is in server.
am writting following code

[VBA]Sub openworkbook()
Workbooks.Open Filename:="\\server\exc\book1.xls "
End Sub[/VBA]

but am not able to open excel file.

Please help me in this issue.

Thanks in Advance

[p45cal]

it wouldn't be that extra space at the end of:
Filename:="\\server\exc\book1.xls "
would it?

[maddiashok]

Hi,
Thanks for reply.
Actually there is no space. I tried it.
i kept exc folder also in shared mode...

[p45cal]

what's the error message?

[maddiashok]

\\server\exc\book1.xls cannot be found. Check your spelling, or try a different path.

I already checked spellings

Thanku!

[maddiashok]

Hi,
My issue has been solved.
The problem is with Sharing Permissions.
Thanku!

[rbrhodes]

mark it 'Solved' pls