5,949 questions
0
votes
0
answers
116
views
Office JS displayDialogAsync Error : TypeError TypeError: Cannot read properties of undefined (reading 'register')
I'm developing a webAddin on Excel and I'm having an issue, I have a taskpane that opens from the button in the ribbon, but I wanted to change to a Display, I have this code in the commands.js
...
1
vote
1
answer
71
views
Get-WmiObject : Invalid class "Win32_DCOMApplicationSetting"
When I run the below PowerShell command on a Windows Server 2016 Standard host I get the following error:
Get-WmiObject -query ('SELECT * FROM Win32_DCOMApplicationSetting WHERE AppId = "{...
1
vote
1
answer
52
views
Outlook classic (vsto): Identifier of context menu of appointment in reminder window
I would like to add an item to the context menu of an appointment in the reminder(s) window in outlook classic:
Is this possible in a VSTO add-in, and if so, what is the identifier of the context ...
-3
votes
3
answers
327
views
Efficient mass find-replace in Word via VBA
I have a VBA-based tool that basically for each row in the Excel takes a defined word document and performs number of find-replace operations. This has been working well so far, but I am starting to ...
0
votes
1
answer
60
views
How do I place a tab stop exactly at cursor?
Is there a built-in or VBA method to place a tab stop at the exact location of the text cursor?
I've tried digging through documentation, but I can't figure out how to get the text cursor location.
I ...
0
votes
0
answers
66
views
Reject HTTP Authorization: Negotiate request in WebDAV
I have a rare bug where some clients (MS Office) suddenly try to do NTLM negotiation. This looks like a regular request, except that the body of a LOCK or PUT request is empty, and a header is added ...
0
votes
0
answers
284
views
Is it possible to sideload Office web extension manifest.xml in production mode?
I am developing an Office Add-in using Office.js. This new extension will be a re-implementation of an old COM Office extension. The problem I am facing right now is how to install the extension for ...
1
vote
1
answer
361
views
How to store hidden, persistent metadata in DOCX files that survives edits
I am looking for a way to add machine-readable metadata to DOCX reports I generate. The goal is to allow users to modify the document's styles and re-upload it to the system while preserving the ...
0
votes
1
answer
72
views
File using Office XML Schema no longer reliably opened by Excel
For many years I have been exporting HTML tables from my web app and downloading them as XSLX so that they will be opened by Excel.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "...
0
votes
0
answers
47
views
Why is there a gamma symbol missing in the formula displayed when I use this latex code in word?
Why is there a gamma symbol missing in the formula displayed when I use this latex code in word? I have tried to display the gamma symbol alone, but the gamma symbol cannot be displayed in this ...
0
votes
0
answers
77
views
word 404 - File or directory not found. The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable
I have a problem with Microsoft Word on the web app. I used to be able to export my files to PDF and download them. However, now I can't do it. This problem has been going on for 3 days. I can still ...
0
votes
1
answer
206
views
In Excel, how can I make a live connection to a table that is in another sheet?
Let say I have two sheets, one Database and another one NewSheet. I want to have a reference to the database so I can put some filters to the columns and be able to search for certain words or phrases ...
1
vote
2
answers
95
views
Get new named cell with Excel JS API
We're using Excel JS API to get changed on worksheets.
Is there an event to get new named cells?
The only way that I see is to store the named cell collection (using NamedItemCollection) & compare ...
-1
votes
2
answers
106
views
How can I copy the field (key entries) from one Access Table to another Table?
I am new to Access. So I have one Excel linked table in Access "Surge Arrester" which is unmodifiable and can only be modified in Excel. I want to copy the keys from the "Surge Arrester&...
0
votes
0
answers
111
views
Microsoft Office Ribbon Custom Tabs not working
We have a Office (M365 Apps for Enterprise) Environment.
Usually I was deploying simple Ribbon customizations for Word with the "Word.OfficeUI" file under C:\users\bla\AppData\Roaming\...
0
votes
0
answers
46
views
Folder.AddToPFFavorites-Methode is not working under Office 2024 64 bit
Currently, we are using the Folder.AddToPFFavorites method to add public folders to the favorites in Outlook 2016 (32-bit). As we prepare to switch to Office 2024 (64-bit), we have found that this ...
0
votes
2
answers
123
views
Excel. How to get an one row data (multiple columns) from every three rows
Please need your help.
I have an excel file with this following structure, that one row is divided into the next two rows:
initial
And need finally get this one. Every third row need to be combined ...
0
votes
1
answer
120
views
How do I set an animation effect to trigger on click of a specific shape?
I am writing VBA to add an animation to an object.
My goal is to make the added animation trigger on click of another specific shape
Image of Trigger on Click object, Animated object, then Animation ...
0
votes
1
answer
74
views
Excel script for generating pivot tables without subtotals
I have a script that creates a pivot table, but I don't want to display subtotals, only final totals.
function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getActiveWorksheet(); // ...
0
votes
1
answer
43
views
Adding duplicate comment to table Microsoft Word 2013
I'm trying in every way to add duplicates of each comment in VBA Word 2013, but for some reason when I run the script, Word crashes and all comments except the last one are created on the restored ...
0
votes
0
answers
77
views
Office.context.mailbox.item.saveAsync fails during OnSend function on Outlook for web/New Outlook
I have an Add-in created for Outlook Web which adds headers to emails in order to send them securely. It operated both through Task Pane and on the OnSend functionality of Outlook Web.
When pressing ...
1
vote
0
answers
66
views
Office.js | Comments not showing immediately after adding through Office.js
I am building a word add-in, one of the main functions is that it can insert comments in specific parts of the document. The whole thing works well when used in locally installed Word, but as soon as ...
-1
votes
1
answer
204
views
Office Script return multidimensional array
Can you help me, how can i return a function in office script that returns an array with: a mail, and 2 array of row ranges:
the return i need is (if possible )
[["[email protected]"],["...
1
vote
3
answers
92
views
How to export / backup files from Sharepoint page libraries?
I'm looking to export all pages under a page libraries in Sharepoint, how do I achieve this?
It is currently not an option to export page libraries, but can be done by Sync for the other SP ...
0
votes
0
answers
88
views
Trying to make a basic auth API call from Office Script
Using this and it fails to fetch. Where am I missing it?
async function main(workbook: ExcelScript.Workbook) {
const response = await fetch('https://postman-echo.com/basic-auth', {
method: 'GET',
...
0
votes
0
answers
43
views
Embedding Excel chart in html
I'm trying to embed some parts of my excel in my html page. When I click three dots to embed my file and then try to customize it, the iframe is not completed:
<iframe width="402" height=&...
1
vote
1
answer
67
views
OfficeScript says it is writing to designated excel sheet, but no text appears and no errors given
I cannot get my office script to write any data in the "Data" sheet. I get no errors from running the script and it does say it writes the data but then nothing is there... I've tried ...
2
votes
1
answer
640
views
Opening MS Office URI getting not allowed due to Restricted Site
I am trying to use a MS Office URI which will automatically open Excel 2016. I am using a URI similar to:
ms-excel:ofe|u|<https://localhost:7068/getOfficeFile?fileName=2021_12_06_Metrics.xlsx>
...
1
vote
0
answers
105
views
What is the "execution mode language" in Office?
Office VBA allows you to query the language used by a particular Office application. For example, executing:
? Application.LanguageSettings.LanguageID(msoLanguageIDUI)
in the immediate window will ...
0
votes
1
answer
88
views
tcom tcl: Error when trying to add hyperlink with link of length more than 255 characters [duplicate]
I am running following script on windows 10, with TCL8.4 and tcom installed. I have Excel 2016 and empty excel file 'clone.xls'.
I am trying to create a hyperlink with link of length 256 characters ...
3
votes
3
answers
207
views
Powerpoint VBA Macro for changing color
I was surprised that no one has asked this question yet, maybe people are not as incapable as me in programming:
I want to program a button in PowerPoint that either changes the color by clicking it ...
0
votes
2
answers
198
views
Developing a word library add-in for office 2024
i'am trying to develop addin for word 2024.
I have created a dummy dll like this:
#include <Windows.h>
extern "C" int WINAPI wlAutoOpen(void);
extern "C" int WINAPI ...
0
votes
1
answer
90
views
Power Automate: Automate Adding New Clients to Microsoft Bookings from Microsoft Forms Submission Trigger
I'm trying to set up a workflow that automatically adds new clients to Microsoft Bookings based on submissions from a Microsoft Forms form. Here's a breakdown of what I'm aiming to achieve:
Trigger: ...
0
votes
1
answer
128
views
Export Selection in Microsoft Visio to picture file using VBA
I am having a MS Visio diagram. Often I need to export the part of the drawing to a picture file to use it somewhere else, but I am really tired of using menus.
I want to export some selected elements ...
0
votes
1
answer
146
views
Convert numerals from English to Arabic (Hindi) in Microsoft Office Online
This is for MS office online, can anyone help and advise how to display the numbers in Arabic (Hindi) instead of English? this is within the word-online, there is no option to change language settings ...
2
votes
0
answers
61
views
How can I tell whether or not user has the new MS Office visual style?
I make a c# add-in for an MS Office desktop app. It uses WPF for front end UI. I want the background of the forms in the add-in to match the Office app colors.
Microsoft recently launched a brand-new ...
1
vote
0
answers
51
views
Lock Tracking in Word Using the Word JavaScript API
I am currently working with the Word JavaScript API, and I can enable Track Changes for the following document
await Word.run(async (context) => {
const document = context.document;
...
0
votes
1
answer
81
views
Excessive scrolling speed in edit mode
I've been experiencing an issue with Office Online Server:
When using edit mode, the scrolling is excessively fast compared to read mode. This makes it nearly impossible to highlight any text near the ...
-1
votes
2
answers
327
views
Is there a way to find first non zero value for a lookup value in excel
can anyone please help me find first non zero value for a lookup in excel. Example, in the below table, when I lookup for 1, with respect to column2, I should get value 'b', not blank or #NA.
I found ...
0
votes
1
answer
108
views
How to write txt file at same file path but preventing window to update notepad display
I like to show string in notepad for easier debug purpose.
I have been used the following VBA codes to display string for years. I use office 2021.
Public Sub writeTxt(ByVal sOri As String)
Const ...
0
votes
2
answers
69
views
leave Filedialog window open after selecting a file
In my VBA application, I'm opening a FileDialog and waiting for the user to select a file.
FileDialog.Show displays the contents of the folder and waits until the user makes a selection. Once the user ...
0
votes
1
answer
78
views
How can I make my simple PowerPoint Add-In available to other people?
A friend asked me to develop a simple PowerPoint (365) Add-In since they couldn't find a suitable one in the Office Store.
I opted to create a Web Add-In in Visual Studio, which is working fine when I ...
0
votes
4
answers
154
views
Word break not working properly in exported document from html template
I am trying to export a word document from html. A lot of items are inside a table. When there is a large text without space, the td content takes a lot of space and the title of the table row shrinks ...
0
votes
1
answer
56
views
How can I use Office JS add-in to track the coordinates of a shape in PowerPoint?
When I use Office JS (JavaScript API for Office) add-in to track the coordinates of a shape in PowerPoint as it moves but I didn't get any coordinates over slides, I guess we can use the Office ...
0
votes
0
answers
199
views
The database cannot be opened because the VBA project contained in it cannot be read when open .accdb
https://i.sstatic.net/57JO73HO.png
Message error
I received a request from a customer who wanted to run the Access system on both 32bit and 64bit environments.
Example code:
' Windows API‚
#If Win64 ...
0
votes
0
answers
62
views
How to "Evaluate" column of a table within a COUNTIFS()
I have a table (real table, not just looking like one) with multiple columns, one called Date Created and the contents are in the format, e.g., 3. Juni 2023 16:09:12 MESZ.
My goal is to count all ...
1
vote
1
answer
232
views
Display header/footer from second page of the word document generated from HTML
I am currently working on exporting word document from HTML. The document contains header & footer but I want them from page 2. I tried the various approaches from various threads, stackoverflow ...
0
votes
0
answers
202
views
How to use a custom authorization server for MS Office with OAuth2?
I am implementing a WebDav server and struggle with adding proper OAuth2 support to allow MS office applications to access files directly.
I followed this answer to get the workflow started. Let's say ...
1
vote
1
answer
488
views
Excel crashes with Access Violation in VBE7.DLL after WorkbookOpen event - how to diagnose?
We are working on a optimization of process built in Excel and experiencing a recurring issue with Excel crashing after loading a specific file that contains many worksheets and extensive VBA code. ...
0
votes
2
answers
67
views
Return the address of last non-empty string cell
I've been researching this for a bit and can't find a solution. Thanks for the help.
Without using VBA, I'd like to:
Return the cell address of that last cell in a column with a numerical value in it....