problem in access with open excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi i have got following problem. I want open from form excel file. I have got
like this :

stAppName = "Excel.exe C:\neco\neco.xls"
Call Shell(stAppName, 1)

Its fine but this is absolute path and i need relative and i tried this.

pokus = Application.CurrentProject.Path
dbpath = CurrentProject.Path
fpath = dbpath & "\vzorce.xls"

Now i have got in fpath full path to the excel file. But when i write :

stAppName = "Excel.exe" & fpath

Progam said file not found(or something else), please can you tell me how
right i must write it. Thx you
 
Back
Top