+ Reply to Thread
Results 1 to 2 of 2

Import VBA code to SPECIFIED project

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    31

    Import VBA code to SPECIFIED project

    Hi,

    I am willing to import VBA Code to specified project, not the active one though..
    [I am running code from 1 file, trying to import other code from file to another].

    And afterwards I am trying to put the code into the button

    I had developed sth like that:


    Please Login or Register  to view this content.
    But it DOES copy Code to my active VB Project instead of the one I want..

    Let's say the Project I'd like to have it in is named:

    VBAProject (Reporting.xlsm)

    can you help me with the issue?

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,298

    Re: Import VBA code to SPECIFIED project

    Try directly addressing the workbook:

    Please Login or Register  to view this content.
    or use a workbook object:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  2. Import data into excel from MS Project
    By egavasrg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2011, 05:10 PM
  3. If i entered any project code in sheet2 display all data of that project
    By koolguys4u in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2009, 03:09 AM
  4. Microsoft project import export template
    By Hamendra Arora in forum Excel General
    Replies: 1
    Last Post: 05-18-2005, 06:06 PM
  5. [SOLVED] How do I import MS Project data into Excel?
    By mk in forum Excel General
    Replies: 0
    Last Post: 03-16-2005, 01:06 PM

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