problem in access with open excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REDIK - 31 Aug 2007 06:32 GMT

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

Reply to this Message

Alex Dybenko - 31 Aug 2007 08:16 GMT

Hi,
try to use ShellExecute API:
http://www.mvps.org/access/api/api0018.htm

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi i have got following problem. I want open from form excel file. I have
> got
[quoted text clipped - 15 lines]
> Progam said file not found(or something else), please can you tell me how
> right i must write it. Thx you

Reply to this Message