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:


    Application.VBE.ActiveVBProject.VBComponents.Import ("\\aze\(...)\macro.bas")
    
    Workbooks("Week_Report.xlsm").Activate
     Sheets("Wszystkie_maszyny").Select
    ActiveSheet.Shapes.Range(Array("Button 1")).Select
    Selection.OnAction = "Macro"
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?