+ Reply to Thread
Results 1 to 2 of 2

Run a macro on a network PC

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    TIjuana, Mexico
    MS-Off Ver
    MSO 2010, MSO 2013
    Posts
    53

    Run a macro on a network PC

    Good day, I've been thinking of this but haven't yet tried to test it.

    Scenario:
    I run some macros on my PC, it has a configured driver for them to run without problems.
    Whenever a new user needs to use those macros, I have to configure the PC so they can run properly.

    Is it posible to be able to make a remote connection file, like a masterfile that calls on my macro file over the network and execute it from my PC? Without having to configure anything in the user's PC

    I hope I made myself clear enough, thanks in advance for the support.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Run a macro on a network PC

    Hi,

    In theory yes it's possible. A central workbook could use CreateObject to run an Excel instance on a remote machine- your PC- and thus open your macro workbook and run some code. You would need to ensure appropriate permissions were set and presumably that the Server service is running on your PC (which is standard).
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Making a macro available on my network
    By ohai309 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2015, 10:54 PM
  2. Share a macro on a network
    By Bukovnik in forum Excel General
    Replies: 0
    Last Post: 05-19-2014, 01:18 PM
  3. Get Network Full Name via Macro
    By djsouljah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2013, 12:42 PM
  4. OnAction macro assigment through a macro in network environment behaves strange
    By kbx17 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-26-2012, 02:22 PM
  5. Macro fails in network
    By Tom H in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2006, 12:25 PM
  6. [SOLVED] NETWORK (LAN) MACRO QUESTION: W XP Pro, SP-2
    By JingleRock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2006, 12:20 PM
  7. [SOLVED] macro to save to network
    By jim hardwick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2005, 03:05 PM

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