<div>
Yes you can. Note the punctuation.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42826350-1"><span>Sub YesYouCan()</span>
<span>' The test macro opens a userform</span>
<span>Application.Run &quot;'C:\MyPath\MyWorkbook.xlsm'!Test&quot; </span>
<span>End Sub</span>
</code></pre>
</div>


<div>
This code needs to placed into a new module in the workbook called &quot;PART 1 - REFRESH COPY &amp;&nbsp;PASTE&quot; where the Userform is?
</div>


<div>
In the workbook 'PART-1---REFRESH-COPY---P<wbr />ASTE.xlsm'<wbr /> put this code in a standard module.<br />

<pre><code class="code-1 nolinks" id="code-20-42826368-1"><span>Sub OpenForm</span>
<span>    UserForm1.Show</span>
<span>End Sub</span>
</code></pre>
<br />
In the workbook 'Example.xlsm' put this code in a standard module.<br />

<pre><code class="code-1 nolinks" id="code-20-42826368-2"><span>Sub ShowForm()</span>
<span>    Application.Run &quot;'PART-1---REFRESH-COPY---PASTE.xlsm'!OpenForm&quot;</span>
<span>End Sub</span>
</code></pre>
<br />
Now if you run if both workbooks are opened you can run ShowForm from 'Example.xlsm' to open the form in 'PART-1---REFRESH-COPY---P<wbr />ASTE.xlsm'<wbr />
</div>


<div>
If the two workbooks are named WB1 and WB2 then if the userform is in WB2 you would put my macro in WB1.
</div>


<div>
Hi, there seems to be a similar issue with both of your codes. <br />
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415713/1.JPG" target="_blank" title="1.JPG (16 KB)"><img alt="1.JPG" class="file-block lazyload" style="max-width: 372px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415713/1.JPG" /></a><a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415714/2.JPG" target="_blank" title="2.JPG (19 KB)"><img alt="2.JPG" class="file-block lazyload" style="max-width: 694px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415714/2.JPG" /></a><br />
My file path is &quot;C:\Users\ESPZYONG\Documen<wbr />ts&quot; and my file name is &quot;PART-1 REFRESH COPY &amp;&nbsp;PASTE&quot;<br />
<br />
<br />
This is the current code<br />

<pre><code class="code-1 nolinks" id="code-20-42826398-1"><span>Sub Test()</span>
<span>Application.Run &quot;'C:\Users\ESPZYONG\Documents\PART-1 REFRESH COPY &amp; PASTE.xlsm'!Test&quot;</span>
<span>End Sub</span>
</code></pre>
</div>


1.JPG

2.JPG

<div>
There's no filepath in the code I posted.
</div>


<div>
@Norie I have tried again and the problem still persists<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415715/Capture.JPG" target="_blank" title="Capture.JPG (15 KB)"><img alt="Capture.JPG" class="file-block lazyload" style="max-width: 553px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415715/Capture.JPG" /></a>
</div>


Capture.JPG

<div>
This error pops up the first time I run it<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415716/Capture.JPG" target="_blank" title="Capture.JPG (21 KB)"><img alt="Capture.JPG" class="file-block lazyload" style="max-width: 375px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415716/Capture.JPG" /></a>
</div>


<div>
The code I posted relies upon the workbook with the userform being open.<br />
<br />
If it isn't you can use the code Martin suggested but you need to ensure you specify the correct path for the workbook.<br />
<br />
PS Are the 2 workbooks located in the same folder?
</div>


<div>
Both workbooks are in the same folder and I made sure both were open
</div>


Supply Chain Management & Quality Management

Noah

<div>
I have tried renaming and saving new files but nothing has worked so far. I have put the code in a module which is in Example.xlsm<br />
<br />
I have also renamed and save the file with the userform to userform.xlsm<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42826426-1"><span>Sub ShowForm()</span>
<span>    Application.Run &quot;'&quot; &amp; ThisWorkbook.Path &amp; &quot;\userform.xlsm'!OpenForm&quot;</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
I had ensured that I the file was saved as Macro-enabled workbook and enabled macros before running
</div>


<div>
What code did you put in the workbook with the userform in it?
</div>


<div>
There is a single command button in the userform<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42826435-1"><span>Private Sub CommandButton1_Click()</span>
<span></span>
<span>Call Button1_Click</span>
<span></span>
<span>End Sub</span>
<span></span>
<span>Sub Button1_Click()</span>
<span>    Application.ScreenUpdating = False</span>
<span>    Call CopyPasteValuesInTab(&quot;Allocation&quot;)</span>
<span>    Call CopyPasteValuesInTab(&quot;By Ctry-EIN&quot;)</span>
<span>    Call CopyPasteValuesInTab(&quot;By Ctry-EMSB&quot;)</span>
<span>    Call CopyPasteValuesInTab(&quot;By Ctry-ETH&quot;)</span>
<span>    Call CopyPasteValuesInTab(&quot;By Ctry-EPC&quot;)</span>
<span>    Call CopyPasteValuesInTab(&quot;ESD Trf Qty&quot;)</span>
<span>    '...</span>
<span>    ActiveSheet.Calculate</span>
<span>    Application.ScreenUpdating = True</span>
<span>    </span>
<span>    MsgBox &quot;Done!&quot;</span>
<span>End Sub</span>
<span></span>
<span>Sub CopyPasteValuesInTab(ByVal SheetName As String)</span>
<span>    On Error GoTo EH</span>
<span>    Dim ws As Worksheet</span>
<span>    Set ws = Sheets(SheetName)</span>
<span>    ws.Activate</span>
<span>    Cells.Select</span>
<span>    Selection.Copy</span>
<span>    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False</span>
<span>    Range(&quot;A1&quot;).Select</span>
<span>    Application.CutCopyMode = False</span>
<span>    Exit Sub</span>
<span>EH:</span>
<span>    Debug.Print Err.Number &amp; &quot;: &quot; &amp; Err.Description</span>
<span>    Application.CutCopyMode = False</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
You need code in a standard module to show the form.<br />
<br />
Something like this, which is from my original post.<br />

<pre><code class="code-1 nolinks" id="code-20-42826439-1"><span>Sub OpenForm()</span>
<span>    UserForm1.Show</span>
<span>End Sub</span>
</code></pre>
That code goes in the workbook with the userform.
</div>


<div>
I have put in the code but it's not working, it keeps saying macros are not enabled or macros are not available.<br />
Even when I try other variations of codes such as this one<br />

<pre><code class="code-1 nolinks" id="code-20-42826442-1"><span>Sub myMacro()</span>
<span>Workbooks(&quot;userform.xlsm&quot;).Activate</span>
<span>Application.Run ThisWorkbook.Name &amp; &quot;!OpenForm&quot;</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
Can you upload the workbooks again?
</div>


<div>
<blockquote>
it keeps saying macros are not enabled or macros are not available.
</blockquote>
you can add in the <b>new location</b> to the <b>Trusted Location</b> in <b>Trust Center</b> for where your Excel file (.xlsm) located<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415720/Untitled.jpg" target="_blank" title="Untitled.jpg (160 KB)"><img alt="Untitled.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/03_w12/800_1415720/Untitled.jpg" /></a><br />
and see if you now able to run macro by default?
</div>


Untitled.jpg

<div>
Here there are <br />
The userform: <a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415721/userform.xlsm" target="_blank" class="file-inline" title="userform.xlsm (16 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>userform.xlsm</a><br />
The data: <a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415722/data.xlsm" target="_blank" class="file-inline" title="data.xlsm (34 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>data.xlsm</a>
</div>


data.xlsm

userform.xlsm

<div>
@Ryan Chong The error is still persisting, I don't think it had to do with trust issues as other macros in other file locations could work prior
</div>


<div>
just now it worked for me to call other workbook's macro by setting the Trust Location with the following codes:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42826466-1"><span>Sub ShowForm()</span>
<span>    Application.Run &quot;'&quot; &amp; ThisWorkbook.Path &amp; &quot;\userform.xlsm'!OpenForm&quot;</span>
<span>End Sub</span>
</code></pre>
<br />
but now I try to remove the settings and do it again and now I can't reproduce the same result lol....<br />
<br />
I got to re-try that again
</div>


<div>
it seems worked fine for me now, with exactly same settings I mentioned above.
</div>


<div>
@Ryan Chong It still doesn't work for me, I think I will try it on my other laptops
</div>


<div>
@Ryan Chong I have tried on another laptop but it shows the exact same problem
</div>


<div>
Hi everyone, I will be closing this thread and opening a new one to ask about my error since @Ryan Chong has stated that it works for him.
</div>


<div>
<blockquote>
Application.Run &quot;'C:\Users\ESPZYONG\Docume<wbr />nts\PART-1<wbr /> REFRESH COPY &amp;&nbsp;PASTE.xlsm'!Test&quot;
</blockquote>
In the workbook that has the userform, is the procedure that opens it called 'Test? if not then change 'Test' to the procedure name.
</div>


<div>
@Martin Liss I have already tried both test and showform commands but it doesn't work
</div>


<div>
<blockquote>
I have already tried both test and showform commands but it doesn't work
</blockquote>
What is the name of the procedure that opens your userform? Do you have one?
</div>


<div>
I think I have removed it previously. I have opened a new thread regarding this issue so let's continue it there :)<br />
<a href="https://www.experts-exchange.com/questions/29140411/Error-With-Running-A-Userform-in-A-Different-Workbook.html" rel="ugc">https://www.experts-exchange.com/questions/29140411/Error-With-Running-A-Userform-in-A-Different-Workbook.html</a>
</div>


<div>
<div class="content wysiwyg-content">
Greetings Experts,<br />
<br />
I have two excel Macro enabled workbooks, however, I have a userform in one workbook called &quot;PART 1 - REFRESH COPY &amp;&nbsp;PASTE&quot; and I need to run the userform in another workbook called &quot;example&quot;.<br />
<br />
Is it possible to make a VBA script to do this?<br />
<br />
Any help is much appreciated :)<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415709/example.xlsm" target="_blank" class="file-inline" title="example.xlsm (31 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>example.xlsm</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2019/03_w12/1415710/PART-1---REFRESH-COPY---PASTE.xlsm" target="_blank" class="file-inline" title="PART-1---REFRESH-COPY---PASTE.xlsm (17 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>PART-1---REFRESH-COPY---PASTE.xlsm</a>
</div>
</div>


example.xlsm

PART-1---REFRESH-COPY---PASTE.xlsm

Greetings Experts,

I have two excel Macro enabled workbooks, however, I have a userform in one workbook called "PART 1 - REFRESH COPY & PASTE" and I need to run the userform in another workbook called "example".

Is it possible to make a VBA script to do this?

Any help is much appreciated :)

Need Help With Running A Userform in A Different Workbook

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.