Sure.
Thanks. I have incorporated your two requests. I don't know when I will release a new version, but if you want to try this out, I can send you an advance copy. Steve On Tuesday, July 11, 2023 at 03:20:42 PM CDT, M MOHSIN mohsyn@users.sourceforge.net wrote: [feature-requests:#2] Regex Find and Replace (Not as formula) Status: open Group: Next_Release_(example) Created: Tue Jul 11, 2023 08:20 PM UTC by M MOHSIN Last Updated: Tue Jul 11, 2023 08:20 PM UTC Owner: nobody I use regex to search and replace...
Regex Find and Replace (Not as formula)
I realized that this is not a problem of Essential Addin but default behaviour of Proper Function in Excel which does not respect ' and - I am using the following code to bypass the issue (sharing here for anyone with same issue or for Steve to include as part of Essential ) Public Function ProperCase(ByVal str As String) As String Dim words As Variant Dim i As Long Dim word As String words = Split(str, " ", , vbTextCompare) For i = 0 To UBound(words) words(i) = UCase(Left(words(i), 1)) & LCase(Mid(words(i),...
I realized that this is not a problem of Essential Addin but default behaviour of Proper Function in Excel which does not respect ' and - I am using the following code to bypass the issue (sharing here for anyone with same issue or for Steve to include as part of Essential ) Public Function ProperCase(ByVal str As String) As String Dim words As Variant Dim i As Long Dim word As String words = Split(str, " ", , vbTextCompare) For i = 0 To UBound(words) - 1 words(i) = UCase(Left(words(i), 1)) & LCase(Mid(words(i),...
When using "Capitalize each word" it recognizes apostrophe and minus as end of the word and capitalizes every letter after them like Tom'S Can there either be an exception for apostrophe and minus symbol by default since they are not end of word or at least an option to exclude them?
Change every word to Capital incorrectly recognizes apostrophe as and of word and capitalizes every letter after apostrophe like Tom'S Can there either be an exception for apostrophe and minus symbol by default since they are not end of word or at least an option to exclude them.
Thanks Steve! I'm looking forward to using it again.
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
Thanks. The issue occurs when a single cell is selected and some part of the worksheet is hidden (like columns are hidden). In this case, the function SpecialCells returns all cells instead of the correct range. This appears to be a bug/feature of Excel, depending on how you interpret the implementation. In any case, I consider it a bug, so I am adding some additional code to detect and workaround it. Meantime, understand the workaround is to select more than one cell if any area is hidden. Thanks,...
Select only one cell and change case to anything - it will affect all the other cells works normally if two or more cells are selected.
You can add attachments to a message here.
Great! Thanks for your work. It's an excellent add-in!
I can share a dummy excel file which reproduces this behavior. let me know email id.
Care to share how to reproduce it?
Yes I can reproduce the issue in a specific file.
Sorry to hear that. I have been unable to replicate this. Are you able to reproduce the issue?
I finally have a copy of Office x64 now, so I am working through issues as I find them, and there are many parts that need workarounds for x64 coding. Will be maybe next week when I can have a new version out, but that should be issue free unless there are machine specific issues. Steve
Thanks for the suggestion, Steve. I tried it but kept getting the same error. See image Any suggestions are appreciated.
I recently used change case feature and to my horror it 1. did not warn 2. changed case for whole sheet instead of selection 3. no way to undo 4. no backup of sheet I hope you rectify Change Case Tool issue to prevent Data Loss!
I recently used change case feature and to my horror it 1. did not warn 2. changed case for whole sheet instead of selection 3. no way to undo 4. no backup of sheet this is a nightmare of a tool. I hope you rectify it!!!!
From another help request in the help forums that was never answered. See if this fixes the issue. You could try change the end of the declare lines from Long to LongPtr below. Technically these are not points and should not need to be changed, however I have seen some posts that suggest that any Long should be LongPtr, so it is worth a try. If Win64 Then Declare PtrSafe Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal hKey As LongPtr, ByVal lpSubKey As String, phkResult As LongPtr)...
Using Excel for Microsoft 365 MSO (Version 2204 Build 16.0.1512820240) 64-bit I've tried reinstalling several times.
You could try change the end of the declare lines from Long to LongPtr below. Technically these are not points and should not need to be changed, however I have seen some posts that suggest that any Long should be LongPtr, so it is worth a try. If Win64 Then Declare PtrSafe Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal hKey As LongPtr, ByVal lpSubKey As String, phkResult As LongPtr) As Long Declare PtrSafe Function RegQueryValueEx Lib "advapi32.dll" Alias "RegQueryValueExA" (ByVal...
Under what conditions does this happen? Is it every time? Don't have Excel 64 bit, so unable to test.
Forgot to post the screenshots
Seems to be having an issue interacting with the registry...? This is on Windows 10 20H2 and Excel 2016 64b
Try this one. Steve
Sorry. Dumb mistake. I am working off my other computer that does not have the latest version, so I sent you an old version by mistake. I will sort out and send you the correct one shortly.
Sorry. Dumb mistake. I am working off my other computer that does not have the latest version, so I sent you an old version by mistake. I will sort out and send you the correct one shortly.
now following error appears at the start of excel On Mon, Apr 5, 2021 at 5:48 PM SteveT stevetowner@users.sourceforge.net wrote: Here you go. I have only changed the part you indicated, so if that part is fine, you may find the same issue elsewhere, but I will at least know what needs to be done. Thanks, Steve Attachments: Essential_Excel_Add-In_Setup_v1.35.0a.exe https://sourceforge.net/p/essenexceladdin/discussion/443929/thread/2619360a31/b016/2bc4/attachment/Essential_Excel_Add-In_Setup_v1.35.0a.exe...
this error appears now at the start of excel
Here you go. I have only changed the part you indicated, so if that part is fine, you may find the same issue elsewhere, but I will at least know what needs to be done. Thanks, Steve
Thanks Steve, I'll appreciate it, so let's try!
Thanks. Can I send you a new version to try? I think I have worked through that issue.
After click for closing of Visual Basic
After click for closing of Visual Basic
Following step, screenshot No.3
Here is screenshot 2
After the instalment, at the start of Excel following errors are shown as in the screen shots. As I can't upload all screenshots at once, I will upload one by one, after eache command carried out.
I don't find any references to ReqQueryStringValue in the programs. Can you take a screenshot of the location when it happens. Do you have office x64? You can create this as a separate topic in the help forum to avoid combining different issues in on thread. Under Support>Create Topic. Thanks, Steve
I have the error with Microsoft Visual Basic "Compile error: Type mismatch" , 1Result=ReqQueryValueEx highlighted, resulting to "Can't execute code in break mode" with "Function ReqQueryStringValue (ByVal kHke As Long, ByVal strValueName As String) As Sting" highlighted, which follow with "This command will stop the debugger", and afterwards no operations carried out in Add-in Version Office 2019, and Windows 10 Thanks for your assistance
Sorry, download again. The file was not correctly added to the setup last time.
Do you see the same error or different?
Sorry, no joy. On Sat, Apr 3, 2021 at 12:54 PM SteveT stevetowner@users.sourceforge.net wrote: Updated in v1.36.0. I cannot test, so appreciate feedback if there are any issues. Compilation Errors in Excel - Office 2016 Pro; Windows 10 Pro https://sourceforge.net/p/essenexceladdin/discussion/443929/thread/efd3afe8ee/?limit=25#bfb4 Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/essenexceladdin/discussion/443929/ To unsubscribe from further messages, please visit...
Support for x64 in v1.36.0. I cannot test, so appreciate feedback if there are any issues.
Updated in v1.36.0. I cannot test, so appreciate feedback if there are any issues.
"The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute." Also, do I need to change Long in Dim statements with LongPtr throughout the add-in? I'm not a VBasic expert. Please advise. Thank you.
Try the new version 1.31.0. I think that will fix your issue.
Hi Steve. I have 32-bit version. Exact version info: Microsoft Excel for Office 365 MSO (16.0.11001.20097) 32-bit
Do you have Office x64?
Hello. Thank you very much for your great add-on! My Excel is a part of Microsoft Office 365 ProPlus suite and when I install Essential Excel Add-In, it doesn't show up in the ribbon. Do you have plans to enable suport for Office 365? Thank you!
Hello. My Excel is a part of Microsoft Office 365 ProPlus suite and when I install Essential Excel Add-In, it doesn't show up in the ribbon. Do you have plans to enable suport for Office 365? Thank you!
I have found the issue with my installation on Excel2007: If I use the Custom UI...
I've just tried several older versions. V1.12 and earlier display the ribbon correctly...