<div>
what do you want the messagebox to say?
</div>


<div>
the information provided by powershell. <br />
<br />
if there is any error message, to provide the error message for example.
</div>


the information provided by powershell.

if there is any error message, to provide the error message for example.

<div>
<div class="content wysiwyg-content">
Hello <br />
<br />
I am using a vba code to run a command from excel to Powershell but i need to have a message box with the result of the powershell command. &nbsp;<br />
Below you can find the script that I am using.<br />
<br />
Can you please help me ?<br />
<br />
<br />
&nbsp; file = &quot;c:\users\User\desktop\Set<wbr />MSXUser.ps<wbr />1&quot;<br />
&nbsp;Set cell = ActiveSheet.Range(&quot;Y12&quot;)<br />
<br />
<br />
&nbsp; Set ofile = CreateObject(&quot;Scripting.Fi<wbr />leSystemOb<wbr />ject&quot;).Cre<wbr />ateTextFil<wbr />e(file)<br />
&nbsp; While cell.Value &lt;&gt;&nbsp;&quot;&quot;<br />
&nbsp; &nbsp; ofile.WriteLine cell.Value<br />
&nbsp; &nbsp; Set cell = cell.Offset(1)<br />
&nbsp; Wend<br />
&nbsp; ofile.Close<br />
&nbsp; Shell &quot;powershell.exe &nbsp;-file &quot;&nbsp;&amp; file<br />
&nbsp; <br />
<br />
End Sub<br />
<br />
<br />
Regards
</div>
</div>


Hello 

I am using a vba code to run a command from excel to Powershell but i need to have a message box with the result of the powershell command.  
Below you can find the script that I am using.

Can you please help me ?


  file = "c:\users\User\desktop\SetMSXUser.ps1"
 Set cell = ActiveSheet.Range("Y12")


  Set ofile = CreateObject("Scripting.FileSystemObject").CreateTextFile(file)
  While cell.Value <> ""
    ofile.WriteLine cell.Value
    Set cell = cell.Offset(1)
  Wend
  ofile.Close
  Shell "powershell.exe  -file " & file
  

End Sub


Regards

how to add a message box that can grab the powershell result and prompt it in excel

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

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.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.