Cannot find path!

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

I recently moved from Excel 2003 to Excel 2010. My VBA application reside on a network. At the beginning I define global constant like this:
Public Const pathSAP As String = "K:\Indic_Entr\interne\SAP\"

With 2003 everything worked fine. Now I get an error message saying that it cannot
fine the path. I'm the only one?
Is there a solution for this?
thank's ahead!
 
Bobby said:
I recently moved from Excel 2003 to Excel 2010. My VBA application
reside on a network. At the beginning I define global constant like
this:
Public Const pathSAP As String = "K:\Indic_Entr\interne\SAP\"

With 2003 everything worked fine. Now I get an error message saying that
it cannot fine the path. I'm the only one?
Is there a solution for this?
thank's ahead!
Click to expand...

Post your code. More than just one line.
 
I recently moved from Excel 2003 to Excel 2010. My VBA application reside on a network. At the beginning I define global constant like this:

Public Const pathSAP As String = "K:\Indic_Entr\interne\SAP\"



With 2003 everything worked fine. Now I get an error message saying that it cannot

fine the path. I'm the only one?

Is there a solution for this?

thank's ahead!
Click to expand...

I found the reason and the solution to this situation. For an unknown reason I did not fully qualified the name of a Workbook with the VBA function Workbooks.Open Filename.
E.I: Workbooks.Open Filename:=test
The funny part is that it worked well with Excel 2003 VBA and not with Excel 2010. I just added the extension of .XLS and everything when fine!

E.I: Workbooks.Open Filename:=test.XLS
Hoping this will help somebody!
 
Back
Top