Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

open excel files

Discussion in 'Information Technology' started by sandra sic, Jul 28, 2006.

Tags:
  1. sandra sic

    sandra sic
    Expand Collapse
    Guest

    hi, i would like to create a button in a form that when i click it, it will
    open a specific excel file. i think it has to be done using code. does any
    one have code for that? thanks
     
  2. Loading...


  3. Allan Murphy

    Allan Murphy
    Expand Collapse
    Guest

    Sandra
    You can use the SHELL command

    In the click event of your button put similar coding to the following
    example

    Dim app_name As String
    Dim file_location_name As String

    file_location_name = "file location\filename"
    app_name = "c:\program files\microsoft office\office\excel.exe " &
    file_location_name
    Call Shell(app_name, 1)

    file_location is the subdirectory of the file, you MUST NOT have a space in
    the subdirectory
    e.g. "d:\my_folder\excel1.xls will work but d:\my folder\excel1.xls will not

    --
    Allan Murphy
    Email: allanmurphy@unwired.com.au

    "sandra sic" <sandrasic@discussions.microsoft.com> wrote in message
    news:D031B534-8C07-4723-AFAE-52A7AEC89DC2@microsoft.com...
    > hi, i would like to create a button in a form that when i click it, it

    will
    > open a specific excel file. i think it has to be done using code. does any
    > one have code for that? thanks
     
  4. sandra sic

    sandra sic
    Expand Collapse
    Guest

    hi Allan,

    this was great! now it works. i can do wonders here. thanks!

    "Allan Murphy" wrote:

    > Sandra
    > You can use the SHELL command
    >
    > In the click event of your button put similar coding to the following
    > example
    >
    > Dim app_name As String
    > Dim file_location_name As String
    >
    > file_location_name = "file location\filename"
    > app_name = "c:\program files\microsoft office\office\excel.exe " &
    > file_location_name
    > Call Shell(app_name, 1)
    >
    > file_location is the subdirectory of the file, you MUST NOT have a space in
    > the subdirectory
    > e.g. "d:\my_folder\excel1.xls will work but d:\my folder\excel1.xls will not
    >
    > --
    > Allan Murphy
    > Email: allanmurphy@unwired.com.au
    >
    > "sandra sic" <sandrasic@discussions.microsoft.com> wrote in message
    > news:D031B534-8C07-4723-AFAE-52A7AEC89DC2@microsoft.com...
    > > hi, i would like to create a button in a form that when i click it, it

    > will
    > > open a specific excel file. i think it has to be done using code. does any
    > > one have code for that? thanks

    >
    >
    >
     

Share This Page