Admin Managed Excel Add-in not visible in Office365 Excel
We have a Excel Web Addin, that was deployed to a group of users using the Office 365 Admin Center. But the add-in is not visible in Excel 2016 (Version 1803,Build 9126.2275, Click to Deploy) for those users.
<MessageText>User must have a mailbox for name resolution operations.</MessageText> <ResponseCode>ErrorNameResolutionNoMailbox</ResponseCode>
I also came across this post "No add-ins currently available." when deploying add-in using Centralized Deployment
that talks about enabling Exchange. I am not sure what that really means.
So any help is appreciated in understanding the issue and resolution.
See also questions close to this topic
Find and Replace in Excel.Range using VB.NET
So I'm trying to create a solution to this problem. I have a Excel.Range variable, and I want to find, and replace certain values in it, using two variables. The code currently looks something likes this:
Dim objTargetRange As Excel.Range = Nothing Dim strFind As String = String.Empty Dim strReplace As String = String.Empty
and later on, i tried some of these solutions, none worked:
'try1 objTargetRange = objTargetRange.Replace(strFind, strReplace) 'try2 objTargetRange = objTargetRange.Range(strFind) objTargetRange.Replace(strReplace)
Thanks in advance :)
Range(cells) vba usage
i used to do most of my coding by recording and then finding the parts i need and using them in code. I'm trying to move on to better things and simplifying simple functions like copying.
But i ran into a problem i don't seem to understand:
Sheets("main").Range(Cells(1, 1), Cells(2, 2)).Copy Sheets("Backup").Range(Cells(1, 1), Cells(2, 2))
Ends with an error: Run time error 1004, application defined or object defined error.
While there is no issue while i try to do:
Sheets("main").Cells(lastrowMain, lastcolumn).Copy Sheets("Backup").Range("A" + CStr(lastrowBackup + 1))
I thought the problem was the size of chosen location to paste to, so i just matched them to be the same, but i still get the same error.
Or maybe my way of choosing a range of cells is wrong and there is a better way?
Userform with varaible size
this time, I would assume, I have a rather simple problem.
In my Programm a string gets created and its size varies alot. This string should then be shown in a seperate window. Unfortunatly the regular Msgbox (limited to 1024 signs I believe) is to small for my needs. Mow I created a userform for the issue but off course it looks silly when there is a giant userform and only to values inside. but next time I needt the size since there are 1000 values in the string. I noticed that the regular msgbox changes size depending on how long the string inside it is.
How can I so the same thing for a Userform created by me? I only found information on how to make it full screen, which isnt helpfull for this case.)
Thanks alot in advance.
How to pass HTML Body as Paramaeter for DisplayNewAppointmentForm
How to pass HTML body as parameters for displayNewAppointmentForm in Office JS.
When I tried the below, the HTML tags are also displayed in the body of meeting
If I try to set only start and end times using displayNewAppointmentForm and then try to set the body using setAsync, I am getting the error that the property or method is not supported.
How can we pass the CoercionType:HTML also in displayNewAppointmentForm
Word add in to record file name in csv
I want to develop a Word add-in using Office js. This add is supposed to record the name and time of opening and closing of a document in a separate file.
I have developed Word addin before and can figure out the functionality.
My question is, how do I make the addin to start automatically when a document is opened in Microsoft Word, so that it can read the file name and system time and save it. The same is going to be repeated when the document is closed.
Office Web Add-In won't load properly. Connection Refused
I'm testing an Outlook web add-in both in Chrome and Edge. I'm using IIS-Express (Launched from VS2017)
The icon pointed to by the "iconURL" element in the manifest file will not load. I get the following error:
Failed to load resource: net::ERR_CONNECTION_REFUSED
Clearing the browser cache didn't help.
What we noticed was that when a new test project (Outlook web Add-in) was created, everything worked normally.
We suspect that IIS-Express isn't being launched by our regular project.
We think that because we had to click the stop debugging button to end the debug session in the test Add-in, but in our regular add-in the "Start" button was still active as if no debugging session was started!
How does Word Task Pane Office Add-in display on the left?
We developed a Word web add-in using
js, and inserted to Word. Our questions:
- Does the add-in display on the left of the document? Right now, when click on the Task Pane button it will display on the right of the document.
- How can I keep the add-in open when next time open the document?
Getting whole document returns empty PDF
I'm trying to generate the file from PowerPoint presentation or Word document using the Add-in as described here, using exactly the example code from getFileAsync(). I receive the PDF with correct document dimensions and number of pages, however all the pages are blank white. No text and background styling.
- Office version: 16.0.11001.20091 64-bit, Office 365
Does anyone had that problem? How can I fix it?
Office Web add-in Offline experience
I want bring an offline experience to the Outlook Web add-in that I am trying to build targeting the Outlook windows client. My idea is to use modern offline methods like service worker. This applies for Word Add-in as well. It would be nice to have something working in offline mode.
I found that web client that Outlook uses to render the add-in , does not support Service Worker. I am not in favor of using app cache to get offline experience , since it is not a web standard anymore.
Is the service worker support for Office Web add-in being planned by the Office add-in team? Or is there any other approach that is being suggested?