Welcome to SPN

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

Sign Up Now!

Opening Microsoft Excel from within Lotus Notes

Discussion in 'Information Technology' started by grovera@gmail.com, Jul 28, 2006.

  1. grovera@gmail.com

    grovera@gmail.com
    Expand Collapse
    Guest

    Hey everybody. I'm very new to Lotus Notes and I've been given the
    task to implement a database for various Excel spreadsheets. I'm
    currently using Domino Designer 6 to create my form and some buttons to
    accomplish this task, however, I'm not sure how to properly code it.
    My concern is that there are about 5-7 spreadsheets which need to be
    accessed and navigating to them everytime is a big pain (seeing as how
    they are dispersed over the network drive). What I would like to do is
    create 5-7 buttons for each spreadsheet. So should the user click on
    the button "Parts Log", the corresponding "Parts Log" spreadsheet will
    open from it's respective location on the drive.

    Any help in this matter would be greatly appreciated, and if any more
    clarification is needed, please let me know.

    Thanks a lot!
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    grovera@gmail.com wrote:
    > Hey everybody. I'm very new to Lotus Notes and I've been given the
    > task to implement a database for various Excel spreadsheets. I'm
    > currently using Domino Designer 6 to create my form and some buttons
    > to accomplish this task, however, I'm not sure how to properly code
    > it. My concern is that there are about 5-7 spreadsheets which need to
    > be accessed and navigating to them everytime is a big pain (seeing as
    > how they are dispersed over the network drive). What I would like to
    > do is create 5-7 buttons for each spreadsheet. So should the user
    > click on the button "Parts Log", the corresponding "Parts Log"
    > spreadsheet will open from it's respective location on the drive.
    >
    > Any help in this matter would be greatly appreciated, and if any more
    > clarification is needed, please let me know.
    >
    > Thanks a lot!


    Sorry. This is a newsgroup dedicated to questions about Access, the
    database program in Office Professional. It appears your question may not
    be related to these subjects. The Microsoft help system is not all that
    clear and may have misdirected you here.

    Lotus Notes is a communication program, the Lotus database is Approach.
    Excel is a Microsoft spreadsheet, not a database. If you really need a
    database do consider Microsoft Access database.

    It is best to ask your questions in a newsgroup dedicated to the
    subject of your question. You should find people better able to address
    your problem there.
    http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


    Note: It is always best to indicate the name and version of any
    program(s) you may be using when asking a question and also indicate the
    operating system (like Windows XP or 98) when you ask a question.

    --
    Joseph Meehan

    Dia duit
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    This newsgroup is for questions about Access, the database product that's
    part of Office Professional.

    Your question has nothing to do with that product!

    Realistically, too, your question doesn't have anything to do with Excel
    either.

    I'd suggest starting at http://www-306.ibm.com/software/lotus/support/

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    <grovera@gmail.com> wrote in message
    news:1152114921.244718.149940@j8g2000cwa.googlegroups.com...
    > Hey everybody. I'm very new to Lotus Notes and I've been given the
    > task to implement a database for various Excel spreadsheets. I'm
    > currently using Domino Designer 6 to create my form and some buttons to
    > accomplish this task, however, I'm not sure how to properly code it.
    > My concern is that there are about 5-7 spreadsheets which need to be
    > accessed and navigating to them everytime is a big pain (seeing as how
    > they are dispersed over the network drive). What I would like to do is
    > create 5-7 buttons for each spreadsheet. So should the user click on
    > the button "Parts Log", the corresponding "Parts Log" spreadsheet will
    > open from it's respective location on the drive.
    >
    > Any help in this matter would be greatly appreciated, and if any more
    > clarification is needed, please let me know.
    >
    > Thanks a lot!
    >
     
  5. grovera@gmail.com

    grovera@gmail.com
    Expand Collapse
    Guest

    My question does have something to do with Excel, seeing as how these
    are Excel spreadsheets.

    Douglas J Steele wrote:
    > This newsgroup is for questions about Access, the database product that's
    > part of Office Professional.
    >
    > Your question has nothing to do with that product!
    >
    > Realistically, too, your question doesn't have anything to do with Excel
    > either.
    >
    > I'd suggest starting at http://www-306.ibm.com/software/lotus/support/
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > <grovera@gmail.com> wrote in message
    > news:1152114921.244718.149940@j8g2000cwa.googlegroups.com...
    > > Hey everybody. I'm very new to Lotus Notes and I've been given the
    > > task to implement a database for various Excel spreadsheets. I'm
    > > currently using Domino Designer 6 to create my form and some buttons to
    > > accomplish this task, however, I'm not sure how to properly code it.
    > > My concern is that there are about 5-7 spreadsheets which need to be
    > > accessed and navigating to them everytime is a big pain (seeing as how
    > > they are dispersed over the network drive). What I would like to do is
    > > create 5-7 buttons for each spreadsheet. So should the user click on
    > > the button "Parts Log", the corresponding "Parts Log" spreadsheet will
    > > open from it's respective location on the drive.
    > >
    > > Any help in this matter would be greatly appreciated, and if any more
    > > clarification is needed, please let me know.
    > >
    > > Thanks a lot!
    > >
     
  6. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Yes, but you're not using Excel directly to interact with them: you're using
    automation, with Lotus Notes as the client. That means you have to know how
    to perform automation from Notes. Notes is a very poorly architected
    application which doesn't follow normal Windows standards, so it's important
    that you find out what it needs to perform Automation, as opposed to what
    Excel expects.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    <grovera@gmail.com> wrote in message
    news:1152122926.340717.103940@p79g2000cwp.googlegroups.com...
    > My question does have something to do with Excel, seeing as how these
    > are Excel spreadsheets.
    >
    > Douglas J Steele wrote:
    > > This newsgroup is for questions about Access, the database product

    that's
    > > part of Office Professional.
    > >
    > > Your question has nothing to do with that product!
    > >
    > > Realistically, too, your question doesn't have anything to do with Excel
    > > either.
    > >
    > > I'd suggest starting at http://www-306.ibm.com/software/lotus/support/
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > <grovera@gmail.com> wrote in message
    > > news:1152114921.244718.149940@j8g2000cwa.googlegroups.com...
    > > > Hey everybody. I'm very new to Lotus Notes and I've been given the
    > > > task to implement a database for various Excel spreadsheets. I'm
    > > > currently using Domino Designer 6 to create my form and some buttons

    to
    > > > accomplish this task, however, I'm not sure how to properly code it.
    > > > My concern is that there are about 5-7 spreadsheets which need to be
    > > > accessed and navigating to them everytime is a big pain (seeing as how
    > > > they are dispersed over the network drive). What I would like to do

    is
    > > > create 5-7 buttons for each spreadsheet. So should the user click on
    > > > the button "Parts Log", the corresponding "Parts Log" spreadsheet will
    > > > open from it's respective location on the drive.
    > > >
    > > > Any help in this matter would be greatly appreciated, and if any more
    > > > clarification is needed, please let me know.
    > > >
    > > > Thanks a lot!
    > > >

    >
     
  7. grovera@gmail.com

    grovera@gmail.com
    Expand Collapse
    Guest

    Ahhh I see. Well thank you for that clarification. I'll post my
    concern on another user group, one pertaining more to this area.

    Thanks!

    Douglas J Steele wrote:
    > Yes, but you're not using Excel directly to interact with them: you're using
    > automation, with Lotus Notes as the client. That means you have to know how
    > to perform automation from Notes. Notes is a very poorly architected
    > application which doesn't follow normal Windows standards, so it's important
    > that you find out what it needs to perform Automation, as opposed to what
    > Excel expects.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > <grovera@gmail.com> wrote in message
    > news:1152122926.340717.103940@p79g2000cwp.googlegroups.com...
    > > My question does have something to do with Excel, seeing as how these
    > > are Excel spreadsheets.
    > >
    > > Douglas J Steele wrote:
    > > > This newsgroup is for questions about Access, the database product

    > that's
    > > > part of Office Professional.
    > > >
    > > > Your question has nothing to do with that product!
    > > >
    > > > Realistically, too, your question doesn't have anything to do with Excel
    > > > either.
    > > >
    > > > I'd suggest starting at http://www-306.ibm.com/software/lotus/support/
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > <grovera@gmail.com> wrote in message
    > > > news:1152114921.244718.149940@j8g2000cwa.googlegroups.com...
    > > > > Hey everybody. I'm very new to Lotus Notes and I've been given the
    > > > > task to implement a database for various Excel spreadsheets. I'm
    > > > > currently using Domino Designer 6 to create my form and some buttons

    > to
    > > > > accomplish this task, however, I'm not sure how to properly code it.
    > > > > My concern is that there are about 5-7 spreadsheets which need to be
    > > > > accessed and navigating to them everytime is a big pain (seeing as how
    > > > > they are dispersed over the network drive). What I would like to do

    > is
    > > > > create 5-7 buttons for each spreadsheet. So should the user click on
    > > > > the button "Parts Log", the corresponding "Parts Log" spreadsheet will
    > > > > open from it's respective location on the drive.
    > > > >
    > > > > Any help in this matter would be greatly appreciated, and if any more
    > > > > clarification is needed, please let me know.
    > > > >
    > > > > Thanks a lot!
    > > > >

    > >
     

Share This Page