5,963 questions
-3
votes
2
answers
269
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 ...
- 525
0
votes
1
answer
34
views
Cannot open Office files (Word, Excel) directly from Alfresco
I’m using Alfresco Community 5.2 installed on an Ubuntu server, and I have the AOS (Alfresco Office Services) module correctly installed and working.
When I try to open an Excel file directly from ...
- 25
1357
votes
10
answers
1.0m
views
What is a correct MIME type for .docx, .pptx, etc.?
For older *.doc documents, this was enough:
header("Content-Type: application/msword");
What MIME type should I use for new .docx documents? Also, for pptx and xlsx documents?
- 84k
0
votes
1
answer
35
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 ...
- 45
1
vote
1
answer
160
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 ...
- 2,085
0
votes
0
answers
28
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 ...
- 19.7k
-1
votes
2
answers
86
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&...
- 65
0
votes
1
answer
100
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 ...
- 65
1
vote
2
answers
69
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 ...
- 11
0
votes
1
answer
60
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" "...
- 13.6k
0
votes
0
answers
65
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 ...
0
votes
2
answers
74
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
0
answers
67
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\...
- 1
-1
votes
1
answer
108
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]"],["...
0
votes
1
answer
63
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 ...
- 13