153 questions
Advice
0
votes
1
replies
116
views
I want to prevent fill and drag in Excel
I want a VBA code to prevent fill and drag in an Excel sheet without hiding the fill and drag cruiser. and without preventing them from advanced settings.
In addition, I want this code to be localized ...
0
votes
1
answer
151
views
Build index match in excel with dynamic sheet
I'm trying to build an INDEX MATCH combo with dynamic sheet input and 3 variables for matching.
I leveraged this article to get an understanding on how to do it and I opted to go for the non-array ...
- 782
2
votes
1
answer
60
views
Make Shortcuts functional for Excel Add-ins even when the task panel is not active
I am trying to add shortcuts to my Excel Add-in to be used in Office 365 as well. I notice that the shortcuts work only when I have clicked inside the Task pane and the Task panel is active. As soon ...
1
vote
1
answer
135
views
How to add tab in ribbon in excel add in using asp.net c#
We're trying to build a Custom Excel Add-in that runs on Office installation as well as Office 365. We're trying to add a custom tab to the Ribbon for the add-in. From the tutorials studied, I ...
- 31
0
votes
1
answer
578
views
Reply to mail item with a post item using VBA
I would like to reply to a mailitem in my inbox with a postitem.
The behavior I'm looking to replicate:
Selecting an email message in the active explorer
Clicking "ctrl + T"
Adding text ...
0
votes
1
answer
108
views
Excel VBA failing to access CorelDraw Page property with Late Binding
I have an Excel (Office 16) VBA code that opens a CorelDraw document and performs a task based on the orientation of each page in the document. The code is as follows:
Dim app As Object
Dim page As ...
- 169
2
votes
0
answers
220
views
Office URI - doc opened in read only mode
I have a word document that sit in a website in my iis,
When i opening the document with office uri from js like this :
window.open("ms-word:ofe|u|http://WSBJRM:8090/test/abc3.docx"),
the ...
- 428
1
vote
0
answers
90
views
How do I allow access to Office applications automation object from standard users in Windows 10?
I have several automation scripts that I wrote to move information in and out of Office applications using VBA. I put all of these together using Office 2003 on a Window 7 computer.
My organization ...
- 11
0
votes
1
answer
4k
views
How to highlight a certain time range in an Excel column of datetimes?
I have an excel column of datetime items in the European format of 2020.10.26 13:14:00, and I would like to highlight those rows where the time fall between 11:00:00 and 12:00:00.
Anything Google ...
- 17.7k
1
vote
0
answers
77
views
VSTO - How to get the folder selected in the menu?
I make VSTO Excel/Word/Powerpoint AddIn.
I want to get selected folder in file menu and set to dialog's InitialFolder.
I have to use [Office.FileDialog] because I have to check where to save documents....
8
votes
1
answer
4k
views
How to change the language of a single document in Excel?
My MS Office and Excel language is English. I am working with English documents most of the time, so I want to keep it that way. Temporarily changing the language options is also not an option.
When ...
- 1,154
2
votes
0
answers
210
views
How can i export merged cells in table from excel to word 2016 using a macro?
I try to use this method to export a table from excel to word, however i cannot export correctly because the merged cells appears unmerged.
But the problem is that the format does not include the ...
1
vote
1
answer
206
views
OpenXML - Get add-in manifests on PPT
I have an application and it have two manifest file.
First manifest create a taskpane to office of right side.
Second manifest is a content add-in.
When i run the application it open an empty ppt ...
- 322
0
votes
0
answers
61
views
vba routine not working after first working perfectly
My routine, which worked perfect before, suddenly results in errors. I do not understand why, the only thing I can think of is a newer office version makes this routine not work anymore. We changed ...
- 359
0
votes
1
answer
253
views
Does Office 2016 and Office 2016 under O365 use same Interop DLL's
Our Windows Citrix based application is migrating from Office 2010 to Office 2016 . We have built our application using Office 2016 software. During Server deployment , Infra teams are saying they do ...
- 3
1
vote
0
answers
102
views
Having a trouble with add-in which works both in Excel and Word and has specific API requirements for both apps
Our Excel-based add-in was recently upgraded to work with both Excel and Word. Initially, we created a separate add-in for Word, but our submission was rejected and we were asked to combine both ...
0
votes
1
answer
175
views
Lost ActiveWorksheet after 'for each worksheet' loop
Routine using for each worksheet loop to unprotect all worksheets in workbook, change active worksheet at least instead to keep the actual one.
This behaviour recognized by Office2016 only, and ...
1
vote
0
answers
6k
views
Ribbon editing option greyed out in Office Home and Student 2016
I just installed MS Office Home & Student 2016 edition on my Mac. Bringing up one of my Office 2016 PC files shows the main button on the front sheet in edit mode (clicking it does not fire the ...
1
vote
0
answers
583
views
Refresh All is not updating refresh-able web query table in Excel 2016
Recently I have updated two of my office PCs with Windows 10 and Office 2016.
I work on Excel sheets (on my server). My excel sheet contains many pages in which data is put as refresh-able web query ...
0
votes
0
answers
360
views
IBM Lotus Notes embedded Excel object. Data read via OLE does not match data in Workbook. Until workbook is manually opened and saved
We've got a Domino/Notes application with a few thousand Notes Docs which contain an embedded Excel workbook. The data has to date been copied from the Workbook using Field Exchange. This has proven ...
- 696
4
votes
0
answers
233
views
Office.js: How can I debug ExecuteFunction commands
I have a command button on a custom ribbon in Excel with an action of type ExecuteFunction which calls a global javascript function in a function file I point to.
Everything works as expected when ...
- 3,140
7
votes
1
answer
3k
views
Excel Add In - Where does console.log output it's message - NodeJS
I am trying to create an Excel AddIn with JavaScript API. But I don't understand where "console.log" outputs their messages. All Microsoft documentations are full with console.log examples, but it is ...
- 383
0
votes
1
answer
1k
views
"The operating system is not presently configured to run this application" Error when Running MAPI App
Thank you for your reply and comments.
Let me describe the situation more detailedly.
I use Visual C++ 2008 to write a small application that will invoke MAPI. I use MAPIStubLibrary to support both ...
- 859
0
votes
1
answer
37
views
Access 2016 - Call FORM from .net aplicatión
I hope you are doing fine,
The idea is to make the application in access with the forms. For business logic use store procedure.
Then call the forms made in Access 2016 from web app made in .net.
Is ...
- 1
0
votes
1
answer
180
views
VBA reference changed version automatically
I wrote some VBA in Excel 2013 which references Outlook and is now used on a virtual machine. My laptop was upgraded to Office 2016 last week, I made some changes in this tool and then it failed to ...
- 110