Getting Syntax error in opening Excel file.

[laks143]

Hi
I am trying to open an excel through Excel VBA.
I am getting Sytax error at

sheet.workbooks.open "C:\Documents and Settings\"&sapid&"\Desktop\mysheet.xls" ,true,false


Here is my code

Dim sheet
Dim sapid
sapid = InputBox("Enter your SAP ID :")
Set sheet = CreateObject("excel.application")
sheet.Visible = True
'sheet.workbooks.open localpath ,true,false

sheet.workbooks.open "C:\Documents and Settings\"&sapid&"\Desktop\mysheet.xls" ,true,false

Can any one help me in this.

Thanks in Advance,
Lakshmi...

 

[YP99TJF]

I tried your code and it worked, well I did insert a couple spaces around the ampersands "&"...
sheet.Workbooks.Open "C:\Documents and Settings\" & sapid & "\Desktop\mysheet.xls", True, False