How to extract data from Word tables into Excel
Thx！And I was dealing with a bunch of old Word forms filled out over the past decade – inconsistent fields, messy tables. I need to extract the data for each field into Excel for analysis and processing. Is there a good way to do this? I heard about this tool from a friend. Has anyone here used it? Is it good? https://chestnuttable.vercel.app/
How to open Office file in react web App?
Hi Team, I want to show my office file into my web App. Few office file reside in sharepoint server and few are in my local storage. I want to show word/excel/powerpoint files in my reactweb app. I referred, the link, But not much clear, Is there any example available to show office files in my react-web app?A Microsoft site that part of Office relies on has a faulty certificate. Who can I report that to?
A Microsoft site/server(s) that part of Office relies on to embed videos and other online media has a faulty certificate used for HTTPS. Who can I report that to? This isn't a fault with an installation at our end but on Microsoft's infrastructure.
I can't add an O365 email to MS Outlook
Hi all, "email address removed for privacy reasons" and "email address removed for privacy reasons" are Office 365 accounts . My PC and user's PC are Windows 10 , with Office 2016 standard I can add "email address removed for privacy reasons" to MS Outlook on my pc and user's pc I can't add "email address removed for privacy reasons" to MS Outlook on my pc and user's pc but I can access it from the web. I go to https://testconnectivity.microsoft.com --> Office 365 --> Outlook Connectivity and test "email address removed for privacy reasons" with Modern Authentication (OAuth) credentials successfully. How can I troubleshoot it ?MS Access: Office 365 vs Office 2016 Issue
I have a form that has a dropdown box which is filled with data from another table based on whether the date selected by the user is Sunday, Monday, ... This function works correctly in Office 2016 but when I open the application with Office 365 the functionality does not work, i.e. nothing shows up in the dropdown box. I wonder if the 'iff' function has changed slightly causing the issue. Below the is the SQL View behind the dropdown box. I've also included two images, the first is what it looks like when running Office 2016 and the second when running Office 365. SELECT tblRoutes.RouteID, tblRoutes.RouteShortName AS Run, tblRoutes.RouteType AS Type, tblRoutes.PullOutTime AS Start, tblRoutes.PullInTime AS [End], tblRoutes.Sunday, tblRoutes.Monday, tblRoutes.Tuesday, tblRoutes.Wednesday, tblRoutes.Thursday, tblRoutes.Friday, tblRoutes.Saturday FROM tblRoutes WHERE (((tblRoutes.Sunday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=1,-1,9))) OR (((tblRoutes.Monday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=2,-1,9))) OR (((tblRoutes.Tuesday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=3,-1,9))) OR (((tblRoutes.Wednesday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=4,-1,9))) OR (((tblRoutes.Thursday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=5,-1,9))) OR (((tblRoutes.Friday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=6,-1,9))) OR (((tblRoutes.Saturday)=IIf(Weekday([Forms]![frmDemandResponseAdd]![DateOfTrip])=7,-1,9))) ORDER BY tblRoutes.RouteShortName; Thanks, Jeremy
Office 2016 - Your Privacy Option Popup
Hi Globally we are using local Office 2016 Enterprise. I would like to do Uncheck/grey-out the option "turn on optional connected experiences." See visual below. From my search this can only be done by GPO. Option 1 below. This can also be configured in the Office2016 / 2019 / 365 ADMX Group Policy files. User > Policies > Admin Templates > Microsoft Office 2016 > Privacy > Trust Centre 1. Allow the use of additional optional connected experiences in Office 2. Allow the use of connected experiences in Office 3. Allow the use of connected experiences in Office that analyze Content
Outlook notification or notification whenever something is attached
Hello, I am wondering if there is an administrative way in Outlook/EXO to cause a custom message or notification whenever an attachment is added to an email. Reason: We want to drive people to use sharepoint links in emails to share things via email instead of an attachment. I do undertand that I can create a reminder notification when Outlook detects that an attachment is forgotten. This is not what I want. Many Thanks
Issue of comboBox in WPF window displayed using Show (not ShowDialog) in VSTO project
In a VSTO solution (Excel workbook document-level), when a Window containing a ComboBox is displayed using Show() instead of ShowDialog() the popup list will close as soon as the mouse is released, contrary to expected behavior of remaining open until a selection is made or the control loses focus. Moreover, if the ComboBox is clicked and released (causing the list to flash on and off) without a selection being made, the window itself (the top bar and minimize/maximize/close buttons) is not clickable. Other controls in the window body continue to function. It’s a little better with office 2013 but not acceptable : The combobox items are properly displayed but once the mouse goes on any item that’s not actually selected, the list disappear. Someone tested for me with office 365 and it’s working for him… The only way to use combobox is to not release the mouse click for selecting a new item. We have a plugins system that allows developers (these can be space engineers that do small code to get technical enhancements to the software like power or thermal calculations) to extend functions of the main application and they may create WPF windows as well as display them using Show (and not ShowDialog) so we can’t use custom hack as it would mean that we ask every third parties developers to do so and it’s not acceptable. The only way to ensure comboboxes work as expected is to create every window in a separated thread, but everything must be thread safe (UI’s actions) and so still not acceptable also for same reason than previously mentioned . I could ask my customer to forget about the 2010 compatibility but the problem is still present in Office 2013, so it will really be difficult for him to ear that. Steps to reproduce : 1 - Ensure Excel 2010 is installed. 2 - Create a new Excel workbook (VSTO) project on visual studio. 3 - To allow adding new WPF window from Visual Studio, open the csproj with a text editor and change ProjectTypeGuids tag to include : {60dc8134-eba5-43b8-bcc9-bb4bc16c2548}. 4 - Add System.Xaml in references of the project. Clean the solution, close it and reopen it. 5 - Create a new WPF window and add to it a combobox with items in it. 6 - In the ThisWorkbook_Startup event of the ThisWorkbook.cs file, create an instance of the window and launch the “window.Show()” function. 7 - Start the project (Ensure it launches with Excel 2010). 8 - When window is shown, click on the combobox (don’t let the mouse button pressed) : the list is not displayed, window is locked and can’t be closed / minimized… Repeat these steps with Excel 2013 : The list is displayed. Move the cursor to an item : The list disappears and same behaviour than before. I attached a sample project made with VS 2015. Thank you very much for providing us a solution. Best regards, Guillaume
