Microsoft All-In-One Script Framework Sample Release on August 23rd

Microsoft All-In-One Script Framework is updated today with 10 new script samples.   These new script samples cover Office and SharePoint. All of these scripts are written for solving frequently asked IT tasks that our team observed in TechNet forums and Microsoft Support Incidents.  Many customers are asking about these IT scenarios, so we expect that the script samples can save some time for IT Pros.

 

------------------------------------------------------------

New Office Script Samples

image

 

Save attachments from multiple selected items in Outlook (VBA)

https://gallery.technet.microsoft.com/scriptcenter/Save-attachments-from-5b6bf54b

Description: This VBA sample illustrates how to save attachments from multiple selected items in Outlook.

User Scenarios: When multiple items are selected, the Save Attachments option in the File menu will be grayed out, and it's inconvenient to save attachments one by one. This script is useful and can be used to save attachments from multiple selected items all at once.

Acknowledgement: Thanks Zhiliang Zhou for collecting the script topic.  Thanks Cristin Yan for composing the script sample.   Thanks  Pranav Wagh (Microsoft Support Escalation Engineer) for reviewing it and ensuring the quality.

 

Convert PowerPoint Presentation to Word Document (VBA)

https://gallery.technet.microsoft.com/scriptcenter/Convert-PowerPoint-c3a26165

Description: This VBA sample illustrates how to convert PowerPoint presentations to Word documents, in the meantime, it will try to keep the original format and layout and reduce the output file size. It can be only run on PowerPoint 2010.

User Scenarios: Converting PowerPoint presentations to Word documents is a frequently asked question by end-users in many public forums. Although there are similar methods available from built-in feature or 3rd-party applications, but most of them have evident disadvantage, some of them make large file size, some of them break or lose the format or layout.

Acknowledgement: Thanks Zhiliang Zhou for collecting the script topic.  Thanks Cristin Yan for composing the script sample.   Thanks  Shiv Khare (Microsoft Tech Lead) for reviewing it.

 

Remove or Change Password for Multiple PowerPoint Presentations (VBA)

https://gallery.technet.microsoft.com/scriptcenter/Remove-or-Change-Password-0efd9823

Description: This VBA sample illustrates how to convert PowerPoint presentations to Word documents, in the meantime, it will try to keep the original format and layout and reduce the output file size. It can be only run on PowerPoint 2010.

User Scenarios: Converting PowerPoint presentations to Word documents is a frequently asked question by end-users in many public forums. Although there are similar methods available from built-in feature or 3rd-party applications, but most of them have evident disadvantage, some of them make large file size, some of them break or lose the format or layout.

Acknowledgement: Thanks Zhiliang Zhou for collecting the script topic.  Thanks Cristin Yan for composing the script sample.   Thanks  Shiv Khare (Microsoft Tech Lead) for reviewing it.

 

Import Multiple Tables from Access to Excel (VBA)

https://gallery.technet.microsoft.com/scriptcenter/Import-Multiple-Tables-ad78b80f

Description: This VBA sample illustrates how to import multiple Access tables to Excel worksheets at once, meanwhile each worksheet‘s name will correspond to each table's name. It can be run on Excel 2003, 2007 and 2010.

User Scenarios: Users would like to import Access tables to Excel worksheets, meanwhile each worksheet's name will correspond to each table's name.

Acknowledgement: Thanks Cristin Yan for collecting the script topic and composing the script sample.  Thanks Shiv Khare (Microsoft Tech Lead) for reviewing it.

 

Remove Notes Pages in PowerPoint (VBA)

https://gallery.technet.microsoft.com/scriptcenter/Remove-Notes-Pages-in-9cd979c7

Description: This VBA demo illustrates how to remove notes pages in PowerPoint 2007 and the later version.

User Scenarios: Removing notes pages in PowerPoint is a frequently asked question by users in the Answers forums. For example, 1) remove slide numbers from PowerPoint notes pages using VBA  2) VBA shut off for PowerPoint 2007 Notes Page Header.  

Acknowledgement: Thanks Cristin Yan for collecting the script topic and composing the script sample.  Thanks Shiv Khare (Microsoft Tech Lead) for reviewing it.

 

------------------------------------------------------------

New SharePoint Script Samples

 

image

 

Retrieve SharePoint list data (PowerShell)

https://gallery.technet.microsoft.com/scriptcenter/Retrieve-SharePoint-list-8e7fb421

Description: This script demonstrates how to retrieve Microsoft SharePoint list data by Windows PowerShell and Microsoft SharePoint PowerShell snapin.

User Scenarios: Retrieve list data is a regular but important task for SharePoint content management. From the related cases, we could see that there are requirements from the IT administrators. There are some scripts in Internet, but all of them just focus on one section (e.g. retrieve all the list items), and also hard to read due to lack of explanations.

Acknowledgement: Thanks Simon Huang for collecting the script topic.  Thanks Greg Gu for composing the script.  Thanks Sojesh Sreelayam (Microsoft Support Escalation Engineer) for reviewing the script sample.

 

SharePoint List Enumerator (PowerShell)

https://gallery.technet.microsoft.com/scriptcenter/SPListEnumerator-PowerShell-b0ce0b9f

Description: This script enumerates through a "large" list or document library and provides information about items in it.

User Scenarios: In SharePoint (2007 and 2010) we have a threshold on the number of list items in a container. In SharePoint 2007, the threshold value is 2,000 and in SharePoint 2010, it is 5,000. We often come across customers who have a large number of items in their lists/document libraries and complain of overall site performance. It is possible for customers to create nested folders and have a large number of documents/list items reside in them. But exceeding the threshold value can cause slowness and have a performance impact on the backend SQL content database.  This script traverses through each folder in a given list/document library and will enumerate items at each container level. It writes the output to a .CSV file to make it easier for viewing in Excel and perform further filtering.

Acknowledgement: Thanks J Vijay William (Microsoft Support Escalation Engineer) for collecting the script topic and composing the script sample.

 

Reset the User Profile Synchronization Service in SharePoint (PowerShell)

https://gallery.technet.microsoft.com/scriptcenter/Reset-the-User-Profile-cebcdee1

Description: This script will help IT administrator to reset the User Profile Synchronization Service in Microsoft SharePoint Server 2010.

User Scenarios: The User Profile Synchronization service interacts with Microsoft Forefront Identity Manager (FIM) to synchronize profile information with external systems such as directory services and business systems. The two FIM services, Forefront Identity Manager Service and Forefront Identity Manager Synchronization Service, are provisioned when you start the User Profile Synchronization service. Being unable to start the User Profile Synchronization service is the most common profile synchronization (profile sync) issue that administrators encounter. The farm account is used to start the User Profile Synchronization service. If you have configured a wrong service account, User Profile Synchronization Service won’t be started. This script could be used to reset the User Profile Synchronization service and its service account.

Acknowledgement: Thanks Anders Wang for collecting the script topic.  Thanks Greg Gu for composing the script sample.   Thanks Sojesh Sreelayam (Microsoft Support Escalation Engineer) for reviewing it before publishing.

 

Add attachments for a specific list item in Microsoft SharePoint Server 2010

https://gallery.technet.microsoft.com/scriptcenter/Add-attachments-for-a-1e931663

Description:  This script could be used to add attachments for a specific list item in Microsoft SharePoint Server 2010.

User Scenarios: In a real world, IT Administrators may need to add attachments for a specific list item. It will be a heavy task if we do it manually, so the IT Administrators need a script to complete this task.

Acknowledgement: Thanks Wenxuan Fan for collecting the script topic.  Thanks Greg Gu for composing the script sample.   Thanks Nishand Vasudevan (Microsoft Escalation Engineer) for reviewing it.

 

Add Allowed Inline Downloaded MIME Types for one Web Application in SharePoint

https://gallery.technet.microsoft.com/scriptcenter/Add-Allowed-Inline-1ae367ae

Description:  This script could be used to add allowed inline downloaded MIME types for one Web Application in Microsoft SharePoint Server 2010.

User Scenarios: By default PDF files cannot open in browser. It is not listed as a safe MIME type. But for most companies, PDF files are widely used in their daily work, so it is necessary to add PDF to the allowed inline downloaded MIME types list.

Acknowledgement: Thanks Wenxuan Fan for collecting the script topic.  Thanks Greg Gu for composing the script sample.   Thanks Sojesh Sreelayam (Microsoft Support Escalation Engineer) for reviewing it.

 

We look forward to learning your feedback and serving you better.  If you have any suggestions, please email All-In-One Script Framework: onescript@microsoft.com.