Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $95

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

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page