Results 1 to 5 of 5

Thread: help with Datareport and excel

  1. Apr 27th, 2006, 07:18 PM #1
    popodc
    popodc is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2006
    Location
    Philippines
    Posts
    177

    Thumbs down help with Datareport and excel

    how can i set the datareport1.datasource to an excel file?? is it ont object Excel App or the workbooks?? or neither? how?? thanks!
    Reply With Quote Reply With Quote
  2. Apr 27th, 2006, 07:43 PM #2
    popodc
    popodc is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2006
    Location
    Philippines
    Posts
    177

    Re: help with Datareport and excel

    /help
    Reply With Quote Reply With Quote
  3. Apr 27th, 2006, 08:21 PM #3
    popodc
    popodc is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2006
    Location
    Philippines
    Posts
    177

    Re: help with Datareport and excel

    datareport1.datasource = ?? "i need to know on how to set it to an excel file"

    please help!!
    Reply With Quote Reply With Quote
  4. Apr 27th, 2006, 08:58 PM #4
    d3gerald
    d3gerald is offline
    Frenzied Member d3gerald's Avatar
    Join Date
    Jan 2006
    Posts
    1,348

    Re: help with Datareport and excel

    you need to open a recordset connected to the excel file that you have

    see the attached link for inforation about connecting a recordset to an excel file

    http://vbforums.com/showthread.php?t=394651

    then set the datasource of your report to your recordset

    set DataReport1.DataSource = myRecordset
    On error goto Trap

    Trap:
    in case of emergency, drop the case...
    ****************************************
    If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option.     if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
    Reply With Quote Reply With Quote
  6. Apr 28th, 2006, 06:24 AM #5
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: help with Datareport and excel

    Moved to reporting section
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width