+ Reply to Thread
Results 1 to 3 of 3

Publishing interactive excel (macro-enabled) file into a HTML webpage

  1. #1
    Registered User
    Join Date
    05-11-2011
    Location
    College Station, Texas
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    42

    Publishing interactive excel (macro-enabled) file into a HTML webpage

    Hello,

    I was wondering if there is a way to publish a macro enabled interactive excel into a HTML webpage? I would really appreciate any kind of of suggestion/help!

    Regards,
    Abi
    Abi

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,703

    Re: Publishing interactive excel (macro-enabled) file into a HTML webpage

    No, not macros. To begin with, HTML does not offer any interactive functionality. That type of functionality has to be written in a client-side scripting language like JavaScript, and maybe even requires server-side coding like Java or PHP, depending on what you want to do. And being able to convert from VBA into that would be complex.

    There are ways to convert an Excel sheet into an interactive web page, but macros are not carried along.

    There was a very similar thread a while back.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-01-2013
    Location
    ohio
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Publishing interactive excel (macro-enabled) file into a HTML webpage

    According to the webpage below, you can export your VBA macros from Excel and import them to Visual Basic in Microsoft’s Web application development platform, .NET. However, I don't understand what you do with your spreadsheet.

    http://smallbusiness.chron.com/conve...net-40835.html

    The article says you'll need to make minor code corrections to convert the code from VBA to VB. It says if you right click on the red code, the compiler will give you suggested revisions.

    Does anyone know how to do this? Does it work? what are the limitations?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1