Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    web version of Excel tools (97/2000/2002)

    I've written quite a few complex Excel VBA tools and am now being asked to make web versions of these tools. I noticed that none of my VBA code runs when I save a workbook as a web page, so that obvious 'solution' won't work. <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> Where can I go to educate myself on how to do web apps which would generate the type of graphs that Excel does and give that same look and feel? Are there ActiveX controls that I'd use (which limits it to IE, right?)

    I'm an intermediate Perl and CGI programmer but I don't want to write these things from scratch like I've done before. Is there some source of info I could go to (sites or books) that would give me an idea of how to do such a project.

    I know about ExcelWriter which is pretty cool but not sure they'd spring the $ for it.

    Thnx much, Deb <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: web version of Excel tools (97/2000/2002)

    Sounds as though you are ready to tackle Office Web Components, ActiveX components that run from the client machine, load worksheet data from the server, and are manipulated by code in the web page. The controls changed significantly between Office 2000 and Office XP, and you probably want to deploy the more recent ones, particularly if you are working with XP yourself.

    In order for the clients to have a license for the components, they need to have a version of Office beefier than Small Business Edition. Although SBE2000 users are allowed to crib from other Office licensees, per Q231126, "More Information" section, SBE XP users are stuck with "view only" versions, per Office XP Web Components Licensing Frequently Asked Questions. The controls also can be deployed from an intranet server (see Q288732) subject to these same licensing limitations.

    To see the types of code changes required to web-ify your Excel/VBA solution, see Microsoft Office XP Developer: Working with the Spreadsheet Component's Object Model on MSDN.

    Good luck, and let us know whether this looks promising.

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: web version of Excel tools (97/2000/2002)

    Thanks for all the insight but the way you describe it doesn't sound at all practical <img src=/S/ouch.gif border=0 alt=ouch width=15 height=15> to implement if my end users need some special version of Office (that definitely won't happen). I thought it would just be some ActiveX control that fits in IE and no other licensing.

    I haven't checked out your links yet, but will do so later this week. I might just end up duplicating the functionality and not the look and feel of a spreadsheet since in my projects, the spreadsheet is mostly used for data entry and chart display. All my VBA code does the business logic on the data which uses almost no formulas.

    Deb <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

Posting Permissions

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