Activity for SteveT
-
SteveT posted a comment on discussion Help
I would need to look at my website hosting the update file. I don't use it other than hosting the update file, so there may be an issue there. Need to find a working alternative. Steve On Wednesday, March 18, 2026 at 07:59:28 AM CDT, roxie2401 roxie2401@users.sourceforge.net wrote: Steve, Thanks --- Really appreciate you quick reply! I had wondered about that; even checked to see if "Never" was an option. Just curious, any idea why when I run the update exe, I get "Unable to determine if an update...
-
If you run the Update Program.exe in the install folder (i.e. C:\Program Files (x86)\Spreadsheet Compare), then click on the Options tab, you can set check interval in days. If you put 1000 days, then that should hold it off for a while.
-
Try v.1.41.0 I uploaded last week. I think that fixed the issue.
-
I have found a colleague who has the same computer I have that has the same issue as you. It seems to be a permissions issue with Excel and the refEdit control that ships with Excel. I was unable to immediately fix his issue, but at least I have a computer with the issue that I work on to resolve this. So give me some time to troubleshoot the issue with him and I will post a solution. One thing you can do is delete the lines with ref... that come up in error as that control is missing. The refedits...
-
In 'Checking/Correcting References', check that RefEdit Control is checked. If not, browser for it and enable it. For me it is in c:\program files\microsoft office\root\office16\refedit.dll. You can also try the installation troubleshooting section for the same file.
-
Looks like a refEdit (Excel) control issue. Take a look at the help file, there are a number of workarounds for Excel issues in the troubleshooting section. I tried on my pc with Win 11 and Excel 365 (v2511) without issue.
-
Hmm. I don't see the same thing. Created two new workbooks (with Sheet1, 2 and 3). Renamed tabs in both, one set with '_Old' added, the other set with '_New' added. Ran compare, no matching tabs found. Clicked Active and only the active sheet from both files was moved. Did compare, no errors.
-
Does this happen in all workbooks or just one/some? If you can reproduce in a pair of files you can post here, I can download and do a compare to identify the problem. Don't upload anything that has personal information or data you don't mind sharing. Steve
-
Have you tried v1.40.0? I think that error was fixed by that version.
-
Try v1.40.0 I just uploaded, this should remove the error. Office versioning is weird, so it may complain that Excel is not installed and if so, refer to the help file for manual instructions.
-
can not install
-
Please create this as a new topic. I will look it to mean time. Thanks, Steve
-
No problem. I like the easy questions.
-
Just to check, did you close all instances of Excel before installing?
-
RowHeight does not appear to be a UDF in Spreadsheet Compare, so the only thing I can think of is that you created your RowHeight UDF in the Spreadsheet Compare VBA project. There is nothing stopping you from doing that, but you do run into the limitation you have found. Sounds like you know what you are doing, but can you track down where you actually placed your UDF and make sure it is not in the Spreadsheet Compare project? I have seen similar to your issue when I copy a UDF from SC and use it...
-
Easiest method would be: 1. Create a folder in your documents folder called XLSTART. 2. Enter that path into the blank textbox you highlighted. 3. Place the Spreadsheet Compare xlam into that folder. You can find the file in the Program Files\Spreadsheet Compare folder. A more complete location is in the help section you included above. It should then start when you next open Excel. If not, check that it is a trusted location in the Excel options.
-
Thanks. I don't believe Microsoft have provided any compare tools until the most recent versions and I don't use these recent ones because mine does everything I want. There is no setting for worksheet format compare, only data compare as you have found. Trouble with that is that there are many properties of a cell or range that can change, of which value is just one, so to compare all the properties would be a big undertaking which most people would not utliize. If there are specific things you...
-
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...
-
I don't get the error in Excel x86 or x64. I think this is an Excel 2007 issue. I will make the change that I think needs to be made and you can report back if it fixes it. Steve
-
I will double the width of the combobox dropdown, which should be enough. That way you do not need to click in the box. Also will update tooltip to the current selection. Create a new thread next time to avoid original poster receiving updates unrelated to the original post.
-
Sorry, forgot to add to the folder. Updated now. Rev 1.37.0 - 16 July 22 Added: Support for Excel x64. Changed: Spreadsheet selection combo boxes to be uneditable.
-
Excel 2007 VB script opening error after compare tool installed
-
previous session remains despite uninstall/reinstall
-
Can't compare files when using namespace prefix in sheet xml file(s)
-
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,...
-
You can add attachments to a message here.
-
Care to share how to reproduce it?
-
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
-
Three buttons on the ribbon, Full, Quick and Range. Range compares the selected ranges, meant for a quick range check, for example a simple table where you can see all the data without scrolling. This is the most basic. Quick compares the current sheet and assumes that there are not too many differences and you just want to visually see the changes. This has more features than range, but quicker than Full. Full gives the option of different output reports and stopping on error and other stuff and...
-
Do other workbooks compare okay? Is the issue on all worksheets within the workbook? If you getting an error during a compare, you can send me the files, or if it is private info, then narrow down where the error is by removing sheets that don't give an error, rows/columns that don't give an error until a small range that is of issue can be sent. Steve
-
Got it. I see the error you are seeing now. You are typing in the combobox and as soon as you click away, it generates an error because what you typed in is not an active workbook name. I don't recall why those are comboboxes instead of read only dropdown boxes, but I will look and change if I can. Thanks, Steve
-
Try comparing two new blank workbooks and to see if it is something in the workbooks you are comparing. You can put some data in cell A1 to compare. You can also send me the workbooks as well if you want. Steve
-
Preference would be to go to FILE > OPTIONS > ADVANCED > GENERAL and locate the 'At startup open all file in' folder. Place the .xlam there and there only (remove all others). If you still get the error, uninstall and reinstall and UNCHECK the option to register and activate the file. You will then have to manually copy as you have done.
-
You can try these. Show developer tab: https://support.microsoft.com/en-us/topic/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45 Change macro settings: https://support.microsoft.com/en-us/office/change-macro-security-settings-in-excel-a97c09d2-c082-46b8-b19f-e8621e8fe373 Steve
-
There is a section in the help file that is installed in the install folder. It has workarounds for a number of issues, so try that first. Steve
-
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)...
-
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.
-
-
If you look in the help file that is installed, there is some information on troubleshooting, basically all the information gained from every other issue that has come up to date. The xlam is also placed in the installation folder. Double clicking to open it in Excel may work if Excel is not opening it by default.
-
It works. I would not recommend Office x64. You can install without registering and access the manual/help from the Start Menu. It provides information on most known issues.
-
If you want a workaround, the xlam is just a renamed zip file. If you make a back in another folder, rename the file extension, open the zip file, you can edit the 'customUI\customUI14.xml' file. Change <tab idMso="TabAddIns" > <group to <tab id="Tab2" insertBeforeMso="TabDeveloper" label="Compare"> <group Zip up again and rename back to original. This will then load the group into a tab 'Compare'.
-
Originally Essential was under Add-in, but grew so big that I had to move it to a separate tab. 'Add-ins' is a bit special in that any pre-2017 add-ins (before the ribbon UI) will automatically be applied to the default 'Add-ins' tab. So Excel has some knowledge of this tab and this might explain why it works differently. So in my Excel, there are other add-ins that are shown in the add-ins tab as well, some that are xla (pre-2017 add-ins) and some xlam (2017+) that I wrote. It is more useful to...
-
I think this is functionality by Excel. I have not seen any option that would prevent adding a group. I have seen that Excel is very particular about the control of tabs. For example, in my other Add-in where I am moving some of the code from VBA to C#, Excel creates two tabs called 'Add-in' because even though they both refer to the same tab name, because they are different code bases, Excel won't let them share the same tab, so I end up with two tabs of the same name. I imagine in your case that...
-
The color all changes option on the second tab should do what you need. It colors all the cells that have changed in both files. You can then turn off the Merged Diffs option. If you don't want to color the original, just make a copy of the Excel file. The diffs will be colored rather than underlined.
-
This thread is a few years old, so you are better creating a new ticket. If you do, can you detail if you have tried other spreadsheets to compare and if the Quick Compare and/or Range Compare windows appear. Thanks, Steve
-
recent versions detected as malware, cannot install
-
Yeah, AV programs are a pain. v1.36.0 was uploaded 2 years old and suddenly now it contains malware. I wish I was that skilled that I could fend off all AV developers for a couple of years! I have uploaded a zip file as you suggested. You will need to go to the Files section of the site to download. Let me know if there are issues there. I included the update checker. That might be what your AV is having heartburn over. Manual instructions are in the help file.
-
Yeah, AV programs are a pain. v1.36.0 was uploaded 2 years old and suddenly now it contains malware. I wish I was that skilled that I could fend off all AV developers for a couple of years! I will upload a zip file as you suggest. Manual instructions are in the help file.
-
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.
-
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. Can I send you a new version to try? I think I have worked through that issue.
-
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
-
Sorry, download again. The file was not correctly added to the setup last time.
-
Do you see the same error or different?
-
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.
-
Can't compare files when using namespace prefix in sheet xml file(s)
-
Spreadsheet Compare 2013 is Microsoft's comparison tool which I have never used. You are free to download and try my tool if you still need it.
-
2 spreadsheets to be compared are always the same one
-
That is strange. What version of Excel do you have? I assume two instances of Excel are running? If so, if you do the same in the other instance, does it show only the other filename?
-
Error 1004 (Unable to set the Top property of the Window class) in procedure Sync of Form frmSyncScroll
-
Sorry, slow response. Have you been able to resolve, or replicate?
-
Office 365 Installation Problems
-
previous session remains despite uninstall/reinstall
-
The settings file is located here: C:\Users\%User%\AppData\Roaming\Spreadsheet Compare It remains if you do an uninstall, but you can manually delete it. Also adding note to the help file.
-
Spreadsheet Compare 1.35.3 causes Excel 2010 crash
-
Old post, but have you tried 1.36.0?
-
Fail on Win7 (x64) with Office2007 (32bit)
-
Microsoft changed the revision numbering of Office starting with Office 2019. I have Office 365 and it reports it is Office 2016. I am guessing in some cases, it does not report anything at all. The add-in in located in the installation folder by default and the installer attempts to install to the correct location based on version installed. If this fails, install copying the installation folder path to the clipboard and with the check box to activate the add-in unchecked. If that works, all the...
-
It's probably not the same VBA as on Windows.
-
If you have a Windows computer available you can install without registering and take the Add-In from the install folder and put on the Mac.
-
Don't believe Mac Excel can run Add-Ins.
-
Can you look in the help file (START>Programs>Spreadsheet Compare>Spreadsheet Compare Help). Look at the sections under Getting Started>Install and Troubleshooting. Specifically the items matching your messages. Most of the time, those steps will fix those issues. Steve
-
I don't see the images. Can you post again?
-
Try the new version. The popup always appears and you can change the recheck interval in the options tab.
-
Okay, yes, that simple popup does not bring up the other one. I will look at changing it. Thanks, Steve On Monday, March 25, 2019, 11:57:50 AM CDT, John Norcross johncnorcross@users.sourceforge.net wrote: The pop-up I was getting only had the single line "Unable to determine if an update is available." and an "OK" acknowledgement button, nothing else. This is with Spreadsheet Compare installed on a MS Office 2016 client in a corporate environment. Deleting the upgrade file I mentioned didn't seem...
-
In the popup, did you try changing the value 'check for updates every x days' to 180?
-
Remove the file, don't rename it. Excel loads all files in that folder. Did you go through the help file issues pages?
-
There is a section in the help file related to issues with installing/uninstalling. I am assuming that you installed the latest version, or did you install an old version? The installer used to copy and register an OCX. It has not done so for a long time. Now it copies the xla file you indicated. You can remove that file manually if you don't want the addin to appear, until uninstallation works. I assume that you have closed all Excel instances before uninstalling?
-
Try the new version 1.31.0. I think that will fix your issue.
-
Do you have Office x64?
-
Have you tried double clicking the .xlam to see what happens? Do you have any other Add_Ins that do work. Could it be macro security?
-
That's not much to go on. Did you look through the other threads help threads and at the troubleshooting section of the program help?
-
I don't see the addin because it is not loaded in the same manner as those you see in the addins list. I agree it would have been nice it Microsoft provided a way to see them.
-
Unfortunatly not. Virus scanners always tend to pick on macros and VBA code, because they are not compiled, it is hard to check for an exact binary match to a virus, so they just flag it up with some generic virus. It is a false positive. If you upload to virustotal.com, you will see 2 positives of 60 virus checkers. I have frequently been caught by over zealous virus checkers.
-
False positive. If you upload to virustotal.com, you will see 2 positives of 60 virus checkers. I have frequently been caught by over zealous virus checkers.
-
Office 365 Excel 2013 WindowsState error - won't tile sheets
-
"Full Compare": Run-time error 13' Type mismatch with MS Office standard Excel 2013
-
Add-in ribbon not displayed
-
Thanks for all the input. For the facebook icon and the row/column moving, those will be fixed in the next version. The buttons being chopped will be fixed as well. In the future I do want a clearer indication of what will and will not change the contents of the workbook, but have not decided on how best to accoumplish it without breaking the code. The ini file is only there for troubleshooting, in case someone finds an issue and I need to know exactly what options they use. There is nothing in the...
1 >
