+ Reply to Thread
Results 1 to 2 of 2

Run Macro enabled Excel on server

  1. #1
    Registered User
    Join Date
    04-05-2016
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    13

    Run Macro enabled Excel on server

    Hi all,

    Currently, I have developped an invoicing tool which I sell in my spare time to self-employed customers.
    This tool is Excel based and has a lot of VBA code behind it, as well as ActiveX forms etc in the workbook.

    I will install this excel file and make sure all the macro's are working (correct references checked etc) manually at the clients laptop/desktop.

    So this is the current situation, but a lot can go wrong and it's time consuming.

    Ideally, I want to move to a different situation of which I don't know it's possible.
    In my head it's easy: I buy a server to host an excel for each client which they access through a web application that works with a user login.
    By doing so, I can update their excel files remotely if I discover bugs or want to add functionality.
    I should also be able to ask for a recurring fee to keep using the excel file.

    Problems that I encounter:
    - Is it possible to host macro enabled Excel workbooks? A quick google learned me that it's not so straight forward...
    - what kind of equipment (server, software,...) would I need?
    - There might be a privacy issue as their data is stored locally on my server and they might not like that I'm able to see all their data. How do other companies deal with this?

    I'm afraid my IT knowledge is not sufficient enough, but I'm eager to learn and maybe I'll have to hire a professional to do this.
    But if you guys can already tell me whether it's technically possible, that would be awesome!

  2. #2
    Registered User
    Join Date
    04-05-2016
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    13

    Re: Run Macro enabled Excel on server

    Anyone?

+ 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. [SOLVED] using macro enabled worksheets and an excel viewer
    By worthm in forum Excel General
    Replies: 2
    Last Post: 10-24-2014, 11:17 AM
  2. opening macro enabled worksheet on 64bit 2008 OS server from dotnet application
    By svibuk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2013, 06:24 AM
  3. opening macro enabled worksheet on server from dotnet application
    By svibuk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2013, 01:27 AM
  4. Macro to Save As for an Excel Macro Enabled workbook
    By hvitzthum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2013, 09:19 AM
  5. Sharing macro enabled excel sheet
    By arunbjaidev in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2013, 03:53 AM
  6. convert all 97-2003 excel documents to macro enabled documents on server
    By viperisback in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 09:06 AM
  7. Replies: 2
    Last Post: 04-10-2013, 04:43 AM

Tags for this Thread

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