office 2016

Hi team, so I switched from Office 2016 straight to Office 365, used it for a few days and went back to Office 2016. Now a few VBA macros are not working for me, but they still work on my colleagues computers who are still using Office 2016. Could this be caused by the cache? Any idea how to...

Hello Everyone, Was wondering if anyone has ever had this problem, it looks like it's a problem with Excel 2016 in this PC specifically. I've made a Macros for sorting data from a CSV File, and put it in a normal Worksheet. I created the Macros in Excel 2013, on a PC at work. This PC has as...

Hi Friends, I tried with a formula creating Boolean strings but its time consuming every time. This is an example: In Column, AI have list of words from A1:A50, It varies every time from A1:A50. ColumnB AND words ColumnC NOT words Here I want to build Boolean strings in ColumnD. In ColumnD...

Hi, I've a question with slight variation as it was posted in this thread. https://www.mrexcel.com/forum/excel-questions/639139-return-multiple-column-headings.html I need to return the column headings for each matching x in a row; to a single cell instead of separate cells. Thanks for...

I need to use some Windows common controls like ListView in VBA UserForms in Excel. Does anybody know, is MSCOMCTL.OCX implementing the ActiveX interface to those common controls included into the installation of Microsoft Office 2016? And is the situation different in Office 365?

Hello all, Is there someone who have a solution to my problem ? I have an Excel workbook with an automatic fonction that copy part of a workbook in jpg then sent it using outlook. It used to work fine with Windows 7 and Windows 8 using Office 2013. Now, we are moving to Windows 10 and to...

Hi There, i am using Windows 10/64 and Office 16. when trying to use add-ins that have been made in Excel 2003, i get a message that "VBA Converter is required". searching the web, i got a "Hot Fix" which Microsoft indicated should resolve the issue. once unzipped, the HotFix has an...

Hi, all. I'm working in Word 2016 using VBA. Macro worked under Win8.1 using Word 2013. It worked on the first of the files I did today. Second file, I got the blocked by organizational policy message, and it highlighted the line below. I don't think it's a problem with the macro, but want...

Does anyone else share my frustration with the following? Or better still has found a solution? I am using Office 2016 on a Windows 10 64 bit OS. I cannot get the FileDialog.InitialView Property to take effect - i.e. no matter which of the msoFileDialogView constants I use it is not applied in...