Microsoft Q&A
Office Development
2,213 questions
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
Development: The process of researching, productizing, and refining new or existing technologies.
Content
VBAでのクエリとデータモデルの削除について
お世話になります。 クエリを手動で削除した場合とVBAで削除した場合の挙動が異なっており、困っています。 手動で削除した場合、クエリの削除と一緒にピボットテーブルで使用しているデータモデルも削除されるのですが、以下のコードでVBAで削除した場合、クエリが削除されてもピボットテーブルで使用しているデータモデルが削除されません。 次回、VBAで再度クエリを作成すると、dmodel 1となり、その後もVBA実行のたびに dmodel 2、dmodel…


LoadBuildingBlocks in Word Document_New and Document_Open very slow
Hi, I want that some Word documents would be based on quite a complex Word template called MyMainTemplate.dotm. MyMainTemplate.dotm uses several BuildingBlocks that are stored in MyServiceXx.dotx templates (different templates for different languages: Xx…


White horizontal lines randomly appearing in Outlook
This is and old one, but still unsolved and unanswered, bug of Outlook: …


Confused about Add-in "SAAS" and Offer types.
Hello, I have been reading the certification and AppSource requirements for developing Office Add-In's. I'm a little bit confused about some of the policies. My situation: I'm developing a Microsoft Office Word add-in that is generally targeting…


Excel External Data Connection Permission
Hi Experts and Engineers, I am meeting an issue regarding Excel API connection as Data sources. I am successfully getting data from the web via OData. The permission method is basic authorization, which means a username and password are required. …


Fetch error on Office Script (Does Bearer Authorization token for external calls work in Excel script?)
Hi all, I am trying to run the following script for an external API call with a Bearer Token: export interface DATOS { count: number; results: Result[]; skill_memberships: SkillMemberships; meta: Meta; } export interface Meta { count:…


How do i apply an automatic sensitivity label to office 365 emails ONLY.
How do i apply an automatic sensitivity label to office 365 emails ONLY.


Office Script stuck
Hello I have been using Office Scripts for a long time and never without too many issues. One returning issue though, is that a script run in Excel Online through the Code Editor (under Automation tab), will get stuck in 'The script is running' while…


I finished my Microsoft educator learning path but didn't get my badge
I have finished a learning path named as Microsoft Educator Academy but didn't received my badge till now.


Can someone assist with steps to integrate workplace with Sharepoint Online
Hi Team, Can someone assist with steps to integrate workplace with SharePoint Online related to both admin side activities and development actions in order to integrate workplace with SharePoint Online would be helpful.


macro for marking a folder as read?
I understand that there is a bug in Outlook, where it sometimes shows the unread email icon, even when there aren't any unread emails. So, I'm wondering if there's a simple macro, that will either open and close the sent items folder, (which should…


Regarding using Excel = Microsoft.Office.Interop.Excel
We have built DLL using 32 bit and when calling through application, we are getting error - "Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not…


Issue loading my visual studio project
My project was able to load till yesterday. Now I get this error when I open the solution file. This is an Excel VSTO add-in project. One or More projects in the solution were not loaded correctly. Please see the Output Window for details. …




Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80080005.
Getting Error while creating instance of Word Microsoft.Office.Interop.Word.Application = New Microsoft.Office.Interop.Word.Application() I have added IISUSRS and Network service account in DCOM settings but still error exists Installed MS Office 2016


InsertOoxml() method of content control is not working for web version of word document.
InsertOoxml() method of contentControl word office js api is not working in online Web version . Tried to get the ooxml of a sample chart from desktop and tried to run the same valid ooxml in web version using insertOoxml() and its throwing RichApi error…


Excel office script, having a confirmation modal
Having reviewed all the relevant documents pertaining to a confirmation modal for the Typescript-based Excel script, I have observed that the modal works successfully on the web page but not within the Excel script. Although I recognize that there are…


How can I insert a PDF within PowerPoint add-ins
Looking at the API documentation for Powerpoint add-in and trying to understand what is possible. I'm looking to insert a PDF as an image. Similar to what is available in the interface as described in the below article or how you would drag/drop pdf…


AADSTS1002016: You are using TLS version 1.0, 1.1 and/or 3DES cipher which are deprecated to improve the security posture of Azure AD.
We are using MSAL.net in the VB.net desktop application to authenticate using Azure AD. but currently facing issue "AADSTS1002016: You are using TLS version 1.0, 1.1 and/or 3DES cipher which are deprecated to improve the security posture of Azure…


Security warning when opening document with URI Schema ms-word
Hello, In a web application, documents are opened using the ms-word protocol. The files are located on a local network drive and opened with a url of the following form: <a href="ms-word:file://server/path/document.docx">Edit…