Resize table using VBA
Hello, I currently use the following code in order to copy data to another worksheet. However, when I eliminate rows on the original worksheet, the range of the table for the second worksheet remains the same when I run the macro. I was wondering if…
My Outlook Addin is overlapping the email actions
Hi everyone, I am developing a Web Addin for the new desktop Outlook, and it seems that something changed in the latest update. Now, every time I open the Addin, the Outlook UI is not responsive and the Addin overlaps it, covering part of the email and…
New Outlook add in Manifest for left side app bar
what will be the changes in manifest.json for new Outlook addin development to get that app launchable from the left side app bar?
How to apply dark mode on dialogs for outlook addin on the web
Hello, I am developing an Outlook add-in on the web with a taskpane and modal dialogs. In dark mode, we are trying to display the taskpane and dialogs in dark colors, but on the dialogs(in iframe), content has dark colors with custom css and html of the…
Error loading Teams app in Microsoft365.com (errorCode: 5600, "AppID is not valid. Must be GUID format")
We have three nearly identical apps published on Microsoft Teams, with only different market targets. When we load them in https://microsoft365.com, only one works, and the other two fail with an error message stating "AppID is not valid. Must be…
X-Unsent: 1 doesn't work on windows 11 and new outlook
Hello, I generate an eml file but the header X-Unsent doesn't work anymore on the new outlook version (windows 11). How can I specify the mail is a draft ? Sincerly
Workbook.refreshAllDataConnections() is not supported in Power Automate.
Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…
Excel crashes when opening a macro enabled excel file intermittently
I have an issue with a macro enabled excel file crashing intermittently. The file starts as a blank template for users to add data, sheets and images to. They can make copies of the template file. But every so often we run into an issue with certain…
Lost device for admin account of Developer E5
I changed my iPhone and I think Authenticator app will back up my Authentication code for Work account of Developer E5. But no, the Authenticator app also required to login even restored it. But it also required to type 2FA code. Now I'm stuck at two…
How do I resolve vba error 1004 when trying to autofill using a variable for dynamic range?
I get error 1004 on this line of Excel vba code and don't know how to resolve. Selection.AutoFill Destination:=Range("R2:R" & lastRow) Dim wb As Workbook Dim ws As Worksheet Set wb = ActiveWorkbook Set ws =…
How do I deploy a custom word ribbon tab with buttons that call VBA code in dotm template files across my organization
I have some highly developed VBA Macro enabled templates that I need to deploy to my organization. for one computer, it is trivial to manually add a custom ribbon tab and buttons to that tab to call code in template files in the start up folder, but we…
Programmatically read restricted excel file
I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and…
Workbook button for Excel Scripts permission issue : The button cannot run because the script was unshared. Contact the owner to share it again.
I created 3 Excel Scripts , added buttons to the workbook for each script, and shared the excel spreadsheet through Teams, and also the scripts on sharepoint with other folks in my organization. When they opened the excel sheet and tried to run the…
Want to save
not required
Mailings - Conditional Check Box.
Hi everyone, I have tried to find out how to create a conditional checkbox to no avail. My goal is to check the right box in a word document depending on what a value is in a field in an excel file. So if FieldValue = 1 Then Check Box 1 (Red Smily) So if…
How can I get the status of calculation request when using Workbook /calculate endpoint?
I am using the Microsoft Graph API endpoint /calculate for workbook recalculation, but it does not provide a way to poll for the status of the calculation asynchronously. After making a POST request to this endpoint, it initiates the calculation process…
Specifying Application ID URL
Context I'm building an Office 365 add-in - to be run in Outlook, both desktop and web -, and I'm at the stage where I want to try logging the user in and getting an access token. However, I'm running into trouble getting the login to work. The…
Need help on reactivaing my microsoft 365 developer Sandbox
Hi All, Last year in November i signed up for 365 developer community and i was given the E5 Instance Sandbox for development due to some issues i have left the program after developing the powerapp and integrated it with teams. After completion of my…
Powerpoint content add-in with iframe contains website cannot be export in web version
I am developing an add-in for Powerpoint. It's a content add-ins that display an external link in an Iframe. In the desktop version of Powerpoint, everything works fine, including export and print. But in the web version, when I try to export the slides…
How to keep add-in panel open
I have developed an outlook add-in and I need to keep it open for some use cases. How can I force it to keep open? I have a magic link login flow. Once a user opens the add-in for the first time they see a login page and after filling their email…