Microsoft Q&A
Office Development
2,427 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
Event-based activation issues with Outlook add-ins
Hello, For some time now we've tried to build an Outlook add-in for both Outlook Desktop and Outlook for the Web using the new JavaScript based stack. Our business needs have led us to event-based activation however in our experience this does not work…


Converter número em extenso
Boa tarde, Tenho o Office 365. Pretendo colocar na celula A1 o valor 123,00€ e que apareça na celula B1 cento e vinte e três euros). Dado que o Excel não tem uma função para o efeito, podem me ajudar com uma uma macro que responda ao solicitado? …


Change colour of bullet point and make text bold/italics
Dear person, I wrote some VBA code to automate powerpoint slides per row of my excel file. Everything works great so far, only thing is that I would like to change the colour of the bullett point that is created with the Placeholder(2) line. Also how…


How can I create a common rule across all enterprise computers for Outlook and run it all computers?
I would like to setup a default rule on each users machine for Outlook. I would like to apply conditional formatting for all external emails. Currently there appears to be no way to do it via group policy.


VSTO, Late signing ClickOnce manifests
I'm developing an Excel VSTO Add-In and I need to update its manifests to reflect customer's specific settings (ie, I have to update 'file' list in application's manifest, since I need to modify the content of a .config inside application's folder). I'm…


Is it possible to change the On-Send default message?
Is it possible to change the On-Send default message using the Outlook Add-in API? I have an add-in where I am stopping the email from being sent using: currentEvent.completed({ allowEvent: false }); I tried doing this, but it didn't work. Does anyone…


Attempting to save Options always results in error message "the end date you entered occurs before the start date"
Problem is ... In Outlook, File | Options, any attempt to save by clicking the OK button (even if you have made no changes) results in the error message "the end date you entered occurs before the start date" and no changes to the Options can…


VBA importing yellow text into Excel from Word?
I posted this a while back on Super User, but never got a response. Students fill out some tables in Word, and they must occasionally use a certain color font to get full credit. I'm using VBA to import their data and the color of their font from their…


manifest xml not updating excel add-in after changes
Our manifest xml file is having some sort of caching problem where our updates to the manifest file are not showing up on our excel add-in. Instead, the add-in seems to be using and caching older versions of the manifest. We have referenced the…


Create macro in Outlook for accepting a selected meeting invite, set 'Show as' and don't send response
With the help of Chat GPT I have been trying to create some macros in Outlook to automate incoming meeting requests. The macro is applied to a (one) meeting request that is selected in the inbox. I managed to set a category, and to accept the…


runtime error 462 reported after trying to open a visio picture in a Word
Hi, My routine process a Word document in Excel VBA, when I tried to open a Visio picture embedded in the Word document, it will fail randomly, while the object of Word will be flushed to null. When the code run forward, error 462 will be reported on…


Word Displays a Question to Use Normal Instead
Updating a macro from a previous version of Word that inserts a file and Word is displaying this VERY annoying message prompting SO many questions! This also appears when inserting the file manually without a macro. Why am I getting a dialog about the…


How to execute a specific macro code depending on which account an incoming email is addressed to if in Outlook, I have several email accounts configured
I have multiple email accounts/mailboxes set up in my Outlook. (my personal company account, a mailbox for windows problems, a mailbox for unix problems, and another mailbox for network problems), and I want to see if there is any way to determine the…


XLL xlSet max string length
Hi Colleagues, It looks like xlSet call from Excel CAPI (XLL) can set cell string data up to 8190 characters string in Excel 2019 despite I expect the limit of 32767 characters. The call returns xlretFailed (32) and error code xlerrValue (15)…


Office Telemetry Dashboard couldnt create worksheets
Hello, i have a question relating the office telemetry dashboard. I searched for a couple of hours but could not find anything that helped me fix my problem, since there is only one other post of someone asking for a solution. I was trying to get the…


microsoft 365 e5 instant sandbox +Azure Active Directory + Invite External User + Bookings
Hi Team, I have configured a M365 Developer Instant Sandbox, I managed to configure Booking page, I'm able to invite internal staff members to my Booking page but if I try to invite external users it seems to not work. I'm able to invite an external…


Office JS Excel Chart Format
To get chart, series, series point formatting, I have to load each format property (e.g axisGroup, gradient color etc).Is there any way we get chart, series and series point formatting is single function?


WinWord.exe crashes randomly when used for .doc to .PDF conversion using automation with Office 2016
We use Microsoft WinWord application to do the .doc to .pdf conversion through automation. The conversion works well for many files. However after a file say 10000 conversions, Windword.exe crashes randomly sometimes. Attaching the Dump file for crash…


How to store data in an office add-in taskbar locally?
We are currently developing a text enhancement add-in for Word with the objective of offering it without any online account requirements. Our aim is to ensure that the add-in operates locally, thereby eliminating any concerns for professional and…
How to keep track of paragraphs from an office add-in taskbar?
We are currently developing a spellchecker add-in for Word that targets minority languages. Our approach involves extracting text from the paragraphs, checking for spelling errors, and displaying them in a taskbar. However, we are facing a challenge in…