+ Reply to Thread
Results 1 to 2 of 2

Moving Complex Excel Application to Web

  1. #1
    Registered User
    Join Date
    05-10-2017
    Location
    Stamford, CT
    MS-Off Ver
    Excel 2010
    Posts
    1

    Moving Complex Excel Application to Web

    Hello,

    I have a large and complex xlsm with quite a bit of VBA code and a growing library of lookup tables. It grew organically and it's size has become a bit unwieldy. It really should be moved to a DB backend, but as part of that process, I think I would like to move the front-end to a Web interface. I am happy to do the needed coding, but I'm not even sure where to start with the process and googling has been surprisingly unhelpful (at least using the terms I tried).

    Can anyone recommend a tool or list of resources? Ideally, my web front-end would have some database front-end features as well as an area that functions like an actual spreadsheet. I am just trying to find some samples that I can use to figure out how to approach the coding.

    Cheers!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Moving Complex Excel Application to Web

    Your question is bit vague, but you'd probably use PHP to code front-end.

    There's open source front-end generator for MySQL (based on PHP). It has DataGrid module, which allows you to work with DB like spreadsheet (uses AJAX data grid).
    http://xataface.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Application/Object Defined Error when moving to 'Else Statement'
    By micszekely in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2017, 05:23 PM
  2. Replies: 9
    Last Post: 07-29-2014, 11:41 AM
  3. Complex problem involving moving rows and returning different values from same criteria
    By drdrummerii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2013, 04:14 PM
  4. Moving between Excel and A.N.Other Application and back again.
    By GavinBest in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2012, 07:19 AM
  5. Complex Timing Application
    By Snoopydad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2012, 09:27 PM
  6. Moving an application from Access
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2012, 05:14 AM
  7. error 1004 application defined error (Moving click button)
    By mdavid800 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-08-2011, 10:13 AM

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