Open an Excel-file from Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

laurasesma18@gmail.com - 29 Oct 2007 10:34 GMT

Hi,

I have a program in Access 2003 and written in Visual Basic. At some
point I would like to open an
Excel file automatly from Access 2003. So that the user can do some
changes in this file and then
close it. I don't want any connection with the program, only that it
open the file on its own.

If you have an idea of how I can do that It would be great.

Thank you,

Laura

Reply to this Message

lyle - 29 Oct 2007 11:08 GMT

On Oct 29, 5:34 am, laurasesm...@gmail.com wrote:

> Hi,

> I have a program in Access 2003 and written in Visual Basic. At some
> point I would like to open an
> Excel file automatly from Access 2003. So that the user can do some
> changes in this file and then
> close it.

You could run this code:

Application.FollowHyperlink "C:\Documents and Settings\Lyle Fairfield
\My Documents\HDSB\Temp.xls"

> I don't want any connection with the program, only that it
> open the file on its own.

Few files open "on their own". They require an executable program to
read and modify their contents.The command above will open the
executable file assoicated with the ".xls" extension and direct it to
open "temp.xls". In my case the temp.xls file will be opened within MS
Excel.

Reply to this Message

laurasesma18@gmail.com - 29 Oct 2007 13:53 GMT

Thank you. It has worked.

Reply to this Message

Dorothy - 29 Oct 2007 22:03 GMT

On Oct 29, 2:34 am, laurasesm...@gmail.com wrote:

> Hi,
>
[quoted text clipped - 10 lines]
>
> Laura

Hi Laura. Here's a good example of some code that opens up Excel from
Access. You can cater it to what you need, add a button and assign
this macro to it.

http://www.excelguru.ca/node/10

Good luck!

Reply to this Message