access open excel file

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

Guest

Hi all, I have got little problem. I want open excel file from form in
access. I have got button and in VB code i have : this is some from code

stAppName = "Excel.exe C:\DBPrametTOOLS\vzorce.xls"

its absolute path, but i want make relative path because i want in future
move databaze with excel file to another computer.

here is my idea how to make it:
dbpath = CurrentProject.Path
fpath = dbpath & "\vzorce.xls"

and now i want use stAppName="excel.exe" & fpath

but its wrong, program said cannot found file, please can you help me set
right relative path ? thx you
 
Instead of using the excel.exe ... you should use the followhyperlink method

application.followhyperlink "c:\temp\test.xls"

try something like

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

application.followhyperlink fpath
 
Back
Top