powershell

All, I can't get the power shell dir function to work with more than one wildcard through excel vba. If I have this directory structure: C:\Test1\Test2\Sample1.xlsm C:\Test1\Test2\Sample2.xlsm This VBA call to power shell will return 2 files fileRegExp = "C:\Test\Test2\*.xlsm" files =...

I have this code in Powershell and I would like to have the same code in Power Query. Grateful for any help. $uri = "https://graph.microsoft.com/beta/security/securescores" $request = Invoke-MgGraphRequest -Uri $URI -method GET -ErrorAction Stop foreach ($item in $request.value) {...

Hello all! I have run automated VBA scripts for some years without much issues. Currently in Windows 10 and Office 365. Windows task scheduler -> PowerShell script -> Excel + VBA code There are various macros and workbooks, but most launch some PowerQuery connection, process data and might...

Hi Thanks in advance , I am new in powershell and trying to create multiple folders with refrence to a column in CSV sheet , The refrence column holds multiple duplicate values e.g. 3455 3455 3456 3456 I want to select each unique value from this column and want to create folder of each one of...

Hi, Need help to add a progress bar to the disk cleanup powershell function when running the clean up. Appreciate any help. Thanks. Get-ItemProperty -Path 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\VolumeCaches\*' | % { New-ItemProperty -Path $_.PSPath -Name StateFlags0001...

Hello All, I have Powershell script that calls an Excel VBA script and saves the file. I'm running into an issue while saving the workbook as I get a dialog box "Would you like to merge your changes with the latest updates on the Server?" and PS waits for user confirmation. How do I suppress...

Hello all, I have been testing a VBA code that will run a Powershell (.ps1) file located on my desktop. When I click on the file directly it works without issue. When I try to run it through VBA, Powershell launches and gives me this issue: File C:\Users\drew\Desktop\showDSKTP.ps1 cannot be...

Hello I am looking for a free and fast way to manipulate large amounts of data (GigaBytes). I think Powershell is the most appropriate as it comes with Windows and it is fast. Do you have any other alternatives? As for Powershell, can you help me please with a script that will read the lines...

Hi, I have a cell with a command on it and would it be possible to be launched to cmd or powershell? I encountered this function, PID = Shell("notepad c:\MyFiles\TextFile.txt", vbNormalFocus) but I am not sure how would this launch to cmd or powershell. How would I incorporate the cell with...

I am trying to use a Powershell script to open an excel file and then run a macro then save and close the excel file. Below is the powershell script i have written. It will open the excel file and save the file, but I cannot figure out how to access the macro. Any suggestions? Thanks...

I have a cell (J2) that produces a powershell command instead of getting the user to copy that cell and paste it into powershell I was hoping to setup a button that just runs the command from the cell Is this possible?

Hello, I have a fillable PDF form I need to populate with data from a workbook. I think it's possible, but controlling other applications is way out of my range of knowledge of VBA. I think I can use the Powershell functionality in excel, but can anyone point me in the right direction on the...

I’m fairly new to Excel macros. I have an Excel 2016 form that I’ve created for some data entry. I want to be able to run a PowerShell script when a particular cell is selected. My issue is I can run a PowerShell script but I can’t figure out how to pass 2 parameters to the PowerShell script...

Hi Friends, I have called a powershell script in my vba code using "Call shell (..........". I want to wait till it finishes it's execution.How can I do that ?

I am using this script, and in powershell, it pulls everything up fine. get-adgroup -Filter * -property mail | fl SamAccountName, Mail, DistinguishedName However, when I add this to the end get-adgroup -Filter * -property mail | fl SamAccountName, Mail, DistinguishedName | Export-Csv c:\My...

Hi could anybody help here. I cannot find the right solution for this error message Excel 2010 - execute powershell commands with button Row13, column 2 enable-mailbox -identity user1 -Alias user1 Sub button9_click() Counter = 13 Do Command = Worksheets("EX2010...

I have written a Powershellscript to search certain text in the VBA coding. It works and is able to searchwithin the .dot files giving me useful results but in the same directory thereare .dotm files which does not seem to be searching. Please see the powershell script below...

Hi All, Can we run powershell script from VBA Excel? If yes then how?