output to excel - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

output to excel

Last post 08-28-2007 07:34 AM by Kalyan Gaddam. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-28-2007 03:02 AM

    output to excel

    Hi,

    I have created a holiday request form in infopath 2003.  When this form is submitted and eventually approved I want to push the data in the form into an excel spreadsheet located on a users "My Site".

    Ingoring the username/"mysite" issues and locating the correct spreadsheet for a particular user (i'll work that out) - is it possible to update an excel spreadsheet with data submitted from infopath?
     

  • 08-28-2007 03:26 AM In reply to

    Here is the answer which is answered on other post(MSDN) by S.Y.M. Wong-A-Ton

    ---------------------------------------------------------------------------------------------------------------

    Yes, you can do it using Excel automation. See
    http://www.mvps.org/access/modules/mdl0006.htm for an example of Excel
    automation that opens a workbook and sets the value of a cell.
    ---
    S.Y.M. Wong-A-Ton

    ---------------------------------------------------------------------------------------------------------------

    Kalyan G Reddy
    Infopath MVP 2007 and 2008
  • 08-28-2007 03:31 AM In reply to

     Thanks for replying.  It's a good start!

  • 08-28-2007 07:34 AM In reply to

    No worries, Glad that it is helping

    Kalyan G Reddy
    Infopath MVP 2007 and 2008
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.