PowerShell script to change font of office apps
Hi, We are using Microsoft 365 for Enterprise for delivery office apps to users via Microsoft Intune. Currently the default font for all office apps is Calibri and now users want that it should change to Arial, 11 font. Is there a way in Powershell to make that change. I have been suggested ways to do it with .net objects or Interop. Can someone please share a sample PowerShell script or a full script to make that change. Thanks, Ashish Arya
How to split rows into column by specific delimiter
Hello. Good afternoon! Well, being direct: The question of the output of the ";" to "," I solved it... I have a routine that generates a CSV file, and it looks like this: A B C D E F G 1,2,3,4,5a 5b 5c 5d,6,7 I would like it to look like this: A B C D E F G 1,2,3,4,5a,6,7 1,2,3,4,5b,6,7 1,2,3,4,5c,6,7 1,2,3,4,5d,6,7 But the fundamental issue is that I need to preserve the contents of the other columns, replicating them to the rows... As in the situation... While column E is 5a, 5b, 5c... Columns A, B, C and D must repeat their contents... To achieve this scenario, I have opened it in Excel and done the "data transformation", asking it to divide the column by the space delimiter. This operation, due to manual intervention, ends up taking longer than it should... Via Powershell, how could I do this?
Data from Excel file to find specific files in folder
Hello, I'm trying to include data from specific ranges (contain files names) in a worksheet from Excel file in order to find this data in folders. After many searches, I couldn't get the way to accomplish it. Here the powershell script : $emplacement = "D:\DOCUMENTAIRE\" $myFolders = @( "File A", "File B", "File C", "File D", "File E", "File F", "File G", "File H", "File I", "File J", "File K", "File L" ) $nbDocuments=0 $Excel = New-Object -ComObject Excel.Application $Workbook = $Excel.Workbooks.Open('D:\PROJET_DOCUMENTAIRE\Suivi_v1.0.xlsx') $workSheet = $Workbook.Sheets.Item(1) $WorkSheet.Name.Range Write-Host "NUM;FOLDER;AGENCY;TYPE;DOMAIN;FILE" For($i=0;$i -lt $myFolders.Length;$i++) { $files = Get-ChildItem -Path $emplacement$($myFolders[$i]) | Where-Object { $_.Name -match ' ' } For($j=0;$j -lt $files.Length;$j++) { $explode_content = $files[$j].ToString().Split("_") $nbDocuments++ Write-Host "$nbDocuments;$($myFolders[$i]);$($explode_content[0]);$($explode_content[1]);$($explode_content[2]);$($files[$j])" } } $files | export-csv C:\Users\Admin\Desktop\List.csv -delimiter ';' Write-Host "---------------------------------" Write-Host "Total documents : $nbDocuments" Write-Host "---------------------------------" cmd / c pause Thank you in advance for your help ! Math
BATCH Run a Word Macro
I would like to run a word macro (for converting files to PDF without any markup comments) for many files in a given folder I pieced this together from other powerShell scripts I had and it doesn't work Param( [Parameter(Mandatory=$True)] [string]$FilePath ) $Files = Get-ChildItem "$FilePath\*.docx" $Word = New-Object -ComObject Word.Application Foreach ($File in $Files) { # open a Word document, filename from the directory $Doc = $Word.Documents.Open($File.FullName) #run Macro to Export to PDF without comments $Doc.Run("NoCommentsPDF") $Doc.Close() } (I got the macro from MVP Doug Robbins) [here is the macro and a link to the thread on a diffrerent Microsoft Q&A where I received this With ActiveWindow.View.RevisionsFilter .Markup = wdRevisionsMarkupNone .View = wdRevisionsViewFinal End With With ActiveDocument .ExportAsFixedFormat Left(.FullName, InStr(.FullName, ".") - 1), wdExportFormatPDF, True, wdExportOptimizeForPrint End With https://answers.microsoft.com/en-us/msoffice/forum/all/default-saveaspdfexport-settings/4b8a7543-de5e-4c45-9ddb-2945d03a1cd4
Using powershell to create folders within users onedrive
Hi all, I'm experiencing several issues with different PowerShell versions when trying to create folders in OneDrive for users in bulk. PowerShell 5.1 does not recognize Connect-PnPOnline. PowerShell 7 does not recognize Connect-SPOService. I have been following the instructions from this guide, which worked on my previous device. However, I’m unable to get it to work on my new device. My goal is to create folders within specific users' OneDrive accounts. Could you please assist me in resolving this? Thank you!Activating project moca?
Hey I am trying to activate Office365 Moca for Outlook using this: https://docs.microsoft.com/sv-se/powershell/module/exchange/set-owamailboxpolicy?view=exchange-ps https://docs.microsoft.com/en-us/microsoft-365/community/yet-another-tool-why-you-will-probably-love-project-moca-aka-outlook-spaces Additional information for admins: This feature is shipped off by default. You can enable it via PowerShell. For reference check Set-OwaMailboxPolicy. Connecting using Connect-ExchangeOnline -UserPrincipalName <UPN> Trying this command: Set-OwaMailboxPolicy -ProjectMocaEnabled $true But i get this error message cmdlet Set-OwaMailboxPolicy at command pipeline position 1 Supply values for the following parameters: Cannot display the prompt for "Identity" because type "Microsoft.Exchange.Configuration.Tasks.MailboxPolicyIdParameter" cannot be loa ded. + CategoryInfo : ResourceUnavailable: (:) [], PromptingException + FullyQualifiedErrorId : System.Management.Automation.Host.PromptingException + PSComputerName : outlook.office365.com Also tried Set-OwaMailboxPolicy -Identity <upn> -ProjectMocaEnabled $true Connection works. Module version (get-module) Script 2.0.3 ExchangeOnlineManagement Any suggestions?Turning off sharing with externals on all sharepoint sites, teams and groups?
Hi, I am looking to see if it's possible thru powershell to turn off the sharing capability of all sharepoint sites. groups and team sites? It's very hard to go thru every 30 sharepoint sites/groups and edit bulking them when there's over 1,000. This what I mean.... Is it possible to do in PowerShell?Sorry, we couldn't find your file. Was it moved, renamed, or deleted?
I want to write a script using powershell which can convert all word files in one folder into PDF format, But it always went error like blow Sorry, we couldn't find your file. Was it moved, renamed, or deleted? (C:\Users\PC\Desktop\test\N1.docx ) At C:\Users\PC\Desktop\Powershell\Converter_0.ps1:10 char:5 + $document = $wordObject.Documents.Open($wordPath) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (:) [], COMException + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException You cannot call a method on a null-valued expression. At C:\Users\PC\Desktop\Powershell\Converter_0.ps1:11 char:5 + $document.SaveAs([ref] $pdfPath, [ref] 17) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\Users\PC\Desktop\Powershell\Converter_0.ps1:12 char:5 + $document.Close() + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull Sorry, we couldn't find your file. Was it moved, renamed, or deleted? (C:\Users\PC\Desktop\test\N2.docx ) At C:\Users\PC\Desktop\Powershell\Converter_0.ps1:10 char:5 + $document = $wordObject.Documents.Open($wordPath) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (:) [], COMException + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException You cannot call a method on a null-valued expression. At C:\Users\PC\Desktop\Powershell\Converter_0.ps1:11 char:5 + $document.SaveAs([ref] $pdfPath, [ref] 17) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\Users\PC\Desktop\Powershell\Converter_0.ps1:12 char:5 + $document.Close() + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull Here is my script $folderPath = "C:\Users\PC\Desktop\test" $folderPathOut = "C:\Users\PC\Desktop\Output" $wordFiles = Get-ChildItem -Path $folderPath -Filter "*.docx" $wordObject = new-object -ComObject "Word.Application" $wordObject.Visible = $True foreach ($file in $wordFiles) { $wordPath = $file.DirectoryName+'\'+$file.Name | Out-String $pdfPath = Join-Path -Path $folderPathOut -ChildPath ($file.BaseName + ".pdf") | Out-String $document = $wordObject.Documents.Open($wordPath) $document.SaveAs([ref] $pdfPath, [ref] 17) $document.Close() } $wordObject.Quit()
