Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating a Workbook on Website

    I am trying to find a way of creating a multiple worksheet report on website on my company's intranet. The site is using VBScript to retrieve information from an Access database. One of the requirements is that the website be able to generate a Excel report that has 4 worksheets, based on the user's selection. I have tried using the Office Web Components, but can only get one worksheet, not multiple worksheets.

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a Workbook on Website

    As you've probably discovered by now the stripped-down OWC functionality only allows it to have 1 worksheet per workbook. You fundamental choices would seem to be to have some kind of VBA code that combined 4 separate 1 page workbooks offline and migrating to a much more high powered solution <img src=/S/money.gif border=0 alt=money width=17 height=15> - such as .NET and Office 2003.
    Gre

Posting Permissions

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