problem in access with open excel file

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access open excel file 1
Shelling Out 2
Open access file with button 1
opening a specific spreadsheet in excel from an access form 1
Excel activate in excel vba 0
Problem with Call Shell 10
I'm trying to open Excel-sheet via VBA in Access 2003 2
Error with Shell Function 2

Top