Help - open excel files in excel format

[domoputro]

Hi, I have problem with opening excel files in Access.
Should I use macro in Access?
Because all I find in the macro was importing file from excel to access table.

Help?

 

[psemianonymous]

You have to be more specific with what you need.

1. Do you want to open the Excel document like it is an Excel document, by opening Excel itself? This is possible.
2. Do you want to link to the contents of an Excel document to a table, but not necessarily import the data? This is possible.
3. Do you want to be able to see the Excel datasheet inside a form in Access? If so, this is not possible. (unless someone else here tells you it is indeed possible)




--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[domoputro]

Thanks for the reply.
Sorry, for the confusion.

I want option no. 1.
Opening an Excel application in Access. Is there a macro function I can assign to?

 

[psemianonymous]

You can't use a macro to open up an Excel document. You have to use VBA. There are two ways:

1. Use ShellExecute: paste in the module (

http://www.mvps.org/access/api/api0018.htm

) into your database and use fHandleFile("c:\fullpath\fullpath\Your Excel Document.xls&quot to open the excel document.
2. Use the DOS/command-line based "start" command, like:

Shell "start c:\fullpa~1\fullpa~1\YourEx~1.xls"

You can't use long filenames and will have to find the 8.3-equivalent using method #2.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm