Excel Blog

Subscribe to the Excel Blog to get the latest product announcements and updates

Options
12.7K
Microsoft Excel on Apr 30 2024 06:44 PM
23K
Microsoft Excel on Mar 26 2024 09:30 AM
14.7K
isabeladominguez on Mar 18 2024 11:25 AM
31.2K
Microsoft Excel on Feb 27 2024 01:05 PM
40.5K
Microsoft Excel on Jan 30 2024 03:32 PM
32.9K
GraceOued on Jan 04 2024 06:00 AM
26.8K
Microsoft Excel on Dec 19 2023 06:00 AM
31.5K
jack-williams on Dec 11 2023 06:00 AM
44.4K
Microsoft Excel on Nov 28 2023 11:20 AM
79.8K
JoeMcDaid on Nov 14 2023 01:11 PM
51.7K
Microsoft Excel on Oct 31 2023 01:41 PM
30.8K
jokahati on Oct 26 2023 06:00 AM
23.6K
Nir_Tal on Oct 25 2023 06:00 AM
18.6K
Sharon910 on Oct 24 2023 08:45 AM
23.8K
ravon314 on Oct 05 2023 09:00 AM
30.5K
Microsoft Excel on Sep 26 2023 03:43 PM
42.8K
David Monroy on Sep 21 2023 08:00 AM
38.5K
Chris_Gross on Sep 18 2023 09:00 AM
32.1K
Microsoft Excel on Aug 30 2023 09:03 AM
1.3M
Microsoft Excel on Aug 22 2023 06:00 AM
24K
Chris_Gross on Aug 18 2023 08:00 AM
22.1K
JoeMcDaid on Aug 08 2023 12:36 PM
31.4K
Microsoft Excel on Jul 25 2023 11:14 AM
28.2K
Chris_Gross on Jun 28 2023 06:00 AM
37.8K
Microsoft Excel on Jun 27 2023 06:00 AM
26.3K
Lev_Solodkin on Jun 26 2023 12:15 PM
18.7K
Microsoft Excel on Jun 16 2023 10:00 AM
49.5K
Microsoft Excel on May 30 2023 12:42 PM
21.2K
Sharon910 on May 18 2023 04:54 PM
33.5K
Microsoft Excel on Apr 25 2023 05:16 PM

Latest Comments

I have found the file and can confirm that the VBA UDFs that reference the Scripting Library still work. My regular expression was^([^\d]+)\s+(\d+)[,\s]*([A-Z])?(?!\w)\w*[,\s]*(st|St|ST|\d*)?[,.\s]*(kl|th|tv|mf|Th|TH|TV)?[-a-z,.\s]*([A-Z]|\d+$)?which I am thankful that I do not need to follow now. T...
0 Likes
Thank you @Keith_A_Lewis . Will wait for the fix. I have already been using re (not regex) library which presently serves the purpose. In fact this is how I have linked excel to that library with xlwings add-in as bridge (By defining Python script with UDF which is called directly from excel): impor...
0 Likes
@jignesh0yt2k I've been able to duplicate the "Add method of addins class failed". I will fix that.As for not having all the Python regex goodness, you can hook up the C code used in mrabarnett/mrab-regex (github.com) using my library. Here is how I hooked up the C++ `<regex>` library: xll_regex/xll...
1 Likes
@jignesh0yt2k , that's the question to @Keith_A_Lewis as the author of the add-in. However, perhaps it's better to discuss details of the tool here GitHub - xlladdins/xlladdin: Bootstrap based on Excel bitness
1 Likes