+ Reply to Thread
Results 1 to 2 of 2

Importing Excel Macros Code from another Excel sheet which has Macro code.

  1. #1
    Registered User
    Join Date
    01-14-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    1

    Importing Excel Macros Code from another Excel sheet which has Macro code.

    How can I Export and import Excel Macro from an Excel Template in Centralized location? Whenever user opens the Template this code gets imported at runtime.

    All macro code in file1 kept in Shared drive.

    Whenever any user opens Template it gets all the code for macro from this Shared Drive --> template.



    For that I need to have some code within all the templates to get this code from shared drive.

    i) Importing macros

    ii) have all code in VBS format in the shared drive



    But for First solution it not working. I will show you what I have worked on and could you please tell me what is wrong.

    Please find the code which i have worked on however has issues with it when import line is execute. It doesn't perform any action though it executes that line.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 01-14-2010 at 03:12 PM. Reason: Added Code Tags

  2. #2
    Registered User
    Join Date
    12-27-2009
    Location
    Paris, France
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Importing Excel Macros Code from another Excel sheet which has Macro code.

    Hello,

    A track with the following code to copy in the code window ThisWorkbook

    Please Login or Register  to view this content.

    I put an attachment for better understanding.
    It will save Smoke_Test.xls in C: \

    Best regards.

    PMO
    Patrick Morange
    Attached Files Attached Files

+ 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