PDA

View Full Version : Test Closed Workbook Excel macros , XLM , (Excel 4 Macros) winhlp32 files



DocAElstein
12-30-2020, 04:39 PM
Testing and notes in preparation for possible blog on
Excel macros , XLM , (Excel 4 Macros)










Excel macros , XLM , (Excel 4 Macros)
Introduction.
The vagueness of Excel macros , XLM , (Excel 4 Macros)
Before Visual Basic for Applications, VBA, there were Excel macros, XLM.
The concept of XLM is very different from Visual Basic for Applications (VBA) macros.
VBA was introduced in Excel version 5.0 so these older macros are also known as Excel 4 Macros.
We basically have a lot of single commands, the execution of which does something. The actual way that you can use them seems to be a bit vague. Possibly this is because they have been continued to be supported in newer Office versions and can be used in various ways. It’s not too clear how these ways relate to the original way that they were used before Visual Basic for Applications.
The help information has been continually withdrawn, and it’s possible that the very latest versions of Office my not support them anymore.
So there may be a conscious or unconscious policy to confuse the issue.

There are ways to use an individual command, ( an individual Excel macro ), or a sequential list of them. Typically a list of them would be held in a file looking something with a modern spreadsheet but having the extension .xlm
In many cases the commands do something and / or return something, so they could be thought of as methods or functions.
Often a list of the possible commands would be referred to as a list of excel 4.0 macro functions.
Nobody is sure anymore of what all the possible commands / excel 4.0 macro functions are, or if they all still work, so there is no comprehensive list

Working on closed workbooks
What first interested me in these old Excel macros , XLM , (Excel 4 Macros) things was seeing that they come close to doing sometimes something like the VBA Evaluate function working with a closed workbook reference. The VBA Evaluate function won’t work with a closed workbook reference, which always annoyed me.
http://www.eileenslounge.com/viewtopic.php?f=30&t=25213
https://eileenslounge.com/viewtopic.php?f=30&t=34952
https://www.excelforum.com/excel-programming-vba-macros/1321581-put-data-in-series-by-vba.html#post5363303

Single value limitation, non array characteristic
One limitation worth pointing out an early stage to avoid possible over excited over possibilities with Excel macros , XLM , (Excel 4 Macros), is that typical commands/functions that return something will unlikely return anything other than a single value


Using Excel macros , XLM , (Excel 4 Macros)
General: In a Cell or Cells
Nobody can remember exactly how Excel macros , XLM , (Excel 4 Macros), were ever used, but approximately they seem to have been used like a modern Excel function, so like
=TheExcel4MacroCommandFunctionThing
But typing one of the old XLM commands/functions in a cell like that doesn’t seem to work in a modern Excel spreadsheet cell. In fact it would likely give you an error: A modern Excel wont recognise the thing as a name or function.
There seems to be a mixture of ways to get things working… , and a couple of things help us often, couple of general observations:
_(i) The common factor in getting the macro commands to run seems to be somehow referring to them. We often see this in Excel and VBA: We sometime talk about “exposing the interface…” : We find in Excel and VBA that sometimes a thing springs into life, or gets done if we are :
refer to a thing;
or
refer to where a thing is at;
or
using/calling its name.
For us, the thing of interest is named ranges. We will consider this in more detail later
_ As part of the compatibility measures present in newer Excel versions, we may add a macro sheet, a “4.0 Macro sheet in a Microsoft Excel” : this may be done via shortcut keys, Ctrl+F11 or from menus after right clicking on a worksheet tab, as in this screenshot
InsertMaco2Sheet.JPG : http://i.imgur.com/JtaUKCQ.jpg
3468
https://i.imgur.com/JtaUKCQ.jpg

We can type our commands, like =TheExcel4MacroCommandFunctionThing in this macro worksheet, and it wont error. We will discuss how we can then use these commands in such a worksheet in detail later




https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)


Ref
https://exceloffthegrid.com/using-excel-4-macro-functions/#comment-9200
https://www.excelforum.com/excel-programming-vba-macros/1148874-macro-4-sheet-mysterious-appearing-worksheets-and-modules-codes-transferred-to-new-modules.html#post4440076
https://www.youtube.com/watch?v=b1S4UJsL62w
https://www.youtube.com/watch?v=TpV__z0iZmo
https://www.mrexcel.com/board/threads/info-only-get-cell-arguments.20611/#post-95601
https://www.mrexcel.com/board/threads/info-only-get-cell-arguments.20611/page-2#post-5210188

DocAElstein
03-10-2021, 09:56 PM
Post for later use

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1 (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw)
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

DocAElstein
03-10-2021, 09:56 PM
Post to use later, need URL now

DocAElstein
03-10-2021, 09:57 PM
Old Excel 4 Macros help File
I found a Folder in an old computer
Normal Share ‘FoundMacro4Stuff’ https://app.box.com/s/5g8b5kh62jcxi4rb6niv8h90lh72gt5d
and
zip Share ‘FoundMacro4Stuff.zip’ https://app.box.com/s/jvh0q4jzx0a83r7yiryhs16sa2iq09l3
form
It has a few things in it http://i.imgur.com/9Br7Lb7.jpg
macrofun.exe
BOOTEX.LOG
Readme.txt
Macrofun.cnt

One of the files is some sort of Cabinet exe thing
http://i.imgur.com/rjq7QoL.jpg http://i.imgur.com/65NUgQO.jpg
Share ‘macrofun.exe’ -
Further examination of the exe file tells you its some sort of Win32 Cabinet Self-Extractor
http://i.imgur.com/AhwC8ok.jpg

I don’t know what that is, but if I double click on it I go through some sort of setting up / installing or similar process set of windows
http://i.imgur.com/yLbydAD.jpg http://i.imgur.com/X5LSH6i.jpg
http://i.imgur.com/vdxlFDj.jpg
http://i.imgur.com/Vn431Vn.jpg http://i.imgur.com/bxO7u5c.jpg
http://i.imgur.com/TtHS3mD.jpg
http://i.imgur.com/7YMUotF.jpg http://i.imgur.com/kqwbHye.jpg
I end up with a .cnt file and a .hlp file, ( and a txt read me file )
http://i.imgur.com/7vD1GCw.jpg http://i.imgur.com/xT9ajOA.jpg

If I double click on that cnt I get nothing useful, but if I double click on the hlp file on an old computer then I get a nice useful user friendly thing to tell me all about Excel4 Macro stuff
http://i.imgur.com/ygnV6U0.jpg http://i.imgur.com/CCVPfeV.jpg

DocAElstein
03-11-2021, 01:20 AM
Notes from here
https://www.pconlife.com/fileinfo/winhlp32.exe-info/


later

DocAElstein
03-15-2021, 01:09 AM
Test

Rought notes just testing


We are looking for a solution to get the .hpl file to come up when double clicking on it
A solution involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
I n short, that works well. I had success with this. Sometimes some tweaking was necessary…

For future reference this was the full story
Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg)
( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it.
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (https://imgur.com/FsF7ew7) )


Situation 2 (Vista)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/F5Ap67q.jpg). ( You will find a lot of reports on the internet from people who see this window a lot ).
Right clicking on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg).
If you simply ignore that , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
That seemed to do the job, - then after a double click on my .hlp file opened it up

A last Note on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed.

Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/)
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to these Thread Posts https://eileenslounge.com/viewtopic.php?p=281642&sid=a32fee2abaf5df4161a4a9a228569efb#p281642
https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350832


…. Associating wonks…
We are looking for a solution to get the .hlp files to come up when double clicking on it
In particular here, we are investigating a suggested solution which involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
Something that looks something along these lines: http://i.imgur.com/oWZZ0kw.jpg http://i.imgur.com/LwYnvHS.jpg
In short: that works well. I had success with this. Sometimes some tweaking was necessary… The following are the notes from that.

Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg) ( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it. )
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (http://i.imgur.com/FsF7ew7.jpg) Via the Controlpanel I see http://i.imgur.com/gl06ZKH.jpg )
( Note also: In this case, untypical an unassociate software has all options available - See later ** in next post for more details http://i.imgur.com/HSaIsTs.jpg )

Situation 2 (Vista)
This is the more common situation.
Double clicking on a .hlp file brings up a window telling you that the hlp (http://i.imgur.com/F5Ap67q.jpg) stuff is out of date and unsupported (http://i.imgur.com/tEu1L23.jpg). ( You will find a lot of reports on the internet from people who see this window a lot. Often this process and/or the associated file is somehow referred to with the word “Stub”** ).
Right clicking (http://i.imgur.com/ilIjYLm.jpg) on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg). -** A general concept similar to this may be referred to as a “help stub” , (https://support.microsoft.com/en-us/topic/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported-3c841463-d67c-6062-0ee7-1a149da3973b) a sort of Microsoft support but without any support at all. (https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350375) All of the downloads suggested there, or at other Internet sites (https://www.pconlife.com/fileinfo/winhlp32.exe-info/) , either aren’t available anymore, or don’t work.
If you simply ignore the suggested “stub” file association , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
1_RightClickOpüenWith 2_Browse 3_Select 4_Open(Select) 5_OK (http://i.imgur.com/5HvRivB.jpg)
That seemed to do the job, - there after, a double click on my .hlp file opened it up


Some other notes on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed: Start using keys MicrosoftSymbol+r or some similar route via the start menu ( bottom left Microsoft Symbol ). …_
Microsoft Symbol Run.JPG , GetIntoVistaRegisterEditor.JPG : http://i.imgur.com/VwprMgF.jpg , http://i.imgur.com/ai1s0JN.jpg
_.. etc.. as in next section Windows 7 for how to to delete a file association …
Even if the dissociation is not necessary , it does Appear to tidy things up a bit. The disassociation clears away the Stub, (http://i.imgur.com/JMhy687.jpg) and if you then re do the right click open with browse Select OK stuff, the stub will be replaced by the Microsoft help (http://i.imgur.com/gqeN7bE.jpg) – It is the Registry entry in HKEY_CURRENT_USER ….. which is responsible for the Stub unhelpful help window

A YellowToBlueToYellow ( Vista Acer )
With operating systems from Vista, the icon seen in Explorer or on the Desktop seems to change sometimes from Blue to yellow.
Approximately , the working solution seems to be mostly associated with yellow, and Blue is often an indication of the no use stub thing. That is not a clear cut rule, its only approximate.
Here is an example of some experiments , starting from a small old ACER Vista pc
At the start of the experiments I had got the working solution to automatic opening of the help file. All is Yellow
http://i.imgur.com/GF4t1C8.jpg , http://i.imgur.com/2YYMV0a.jpg
But note in the last screenshot , I have no option other than the “Stub”
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/JeAsGK5.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1GkiHWH.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/sh5yVJQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/Yx7ZJ0m.jpg

To go Blue , one simply needs to click on the (yellow) stub above, after a right click open with: After the OK , the computer blinks a bit, and the Icon in the explorer window, or , if on desktop, turns blue.
We then have the help that’s no help situation on double clicking, http://i.imgur.com/uOCwS3C.jpg , and the registry entries have changed.
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/jSoyJbB.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/NOaDyah.jpg HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/l6QSAZj.jpg

unassoc.exe has first option greyed out http://i.imgur.com/vRth42e.jpg
I go back to yellow after I hit the OK via the usual right click open with browse select OK (http://i.imgur.com/sDIx9dw.jpg) stuff. Then the double click works. I notice that I do have a second entry, this time at the bottom, although in the past I don’t always see that. Note: In fact it went away later
http://i.imgur.com/9eni0Gn.jpg
http://i.imgur.com/w9QmlE0.jpg
The registry entries have changed.
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/wGAXvdT.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/pa8lQO3.jpg HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hg1nOLc.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/DpCPqSn.jpg
unassoc.exe now has the first option showing http://i.imgur.com/TdkDLTw.jpg


Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/) ***
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg


Virgin (X110) (Win 7)
Initially there was just the HKEY_CLASSES_ROOT\.hpl with ab (Standard) REG_SZ hlpfile
I ran unassoc.exe and that was gone as well!
I downloaded the .hlp file , which had a blank icon, and no open with option on the right click. On the double click the new window (https://imgur.com/s5JTec1.jpg) appeared.
I downloaded winhlp32.exe , restarted the computer and the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList appeared. (http://i.imgur.com/Wc7Z43Q.jpg ) Still no right click option.
So I browse from the New Window on double click. ( At the start is no Recommended Programs at the top, but the stub is found at C:\Windows\winsxs\x86_microsoft-windows-winhstb_31bf3856ad364e35_6.1.7600.16385_none_28dc6 47c6aba6742 , BTW as per https://www.pconlife.com/fileinfo/winhlp32.exe-info/ http://i.imgur.com/VcdNXwp.jpg )
https://i.imgur.com/rFsKTN8.jpg
Here is then the situation, initially seeing a yellow ? on the icon, double clicking working, and the initial Other Programs entry soon changes to a Recommended programs (http://i.imgur.com/J7debqu .jpg[/url) entry
HKEY_CLASSES_ROOT\.hlp [url]http://i.imgur.com/dUSpyAs.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/S9mhR61.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/akvM638.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to this Thread Post https://eileenslounge.com/viewtopic.php?p=281746&sid=cc18222d1e76e492a277747afa644906#p281746

CommandDescription

Remove file association (User)Removes the user-specific association (via the Open With dialog) for the chosen file type. Note that this button will remain dimmed if there is no user-specific association for the file type.

Delete file typeDeletes the file type completely from the registry. Both the user-specific and global associations for the chosen file type is removed.

Refresh listRefreshes the list box contents.




*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

Re try Win7 unassoc.exe exp ( X110 Win 7)
I am starting at a working after right click brose situation, with first option greyed out
Recommended programs (http://i.imgur.com/r3kcKAZ.jpg) entry
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/dUSpyAs.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/S9mhR61.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/akvM638.jpg
I run unassoc.exe , and immediately after taking the second option, the yellow ? on the icon vanishes. The HKEY_CLASSES_ROOT\.hlp folder is gone. The two HKEY_CURRENT_USER \Software\Microsoft\Windows\CurrentVersion\Explore r\FileExts\ .hlp folder entries have not changed
I do the right click browse from double click new window to my downloaded desktop winhlp32.exe
I have the yellow ? on the desktop icon, and unassoc.exe shows first option!!
The HKEY_CLASSES_ROOT\.hlp folder entry is back, and I have an extra HKEY_CURRENT_USER \Software\Microsoft\Windows\CurrentVersion\Explore r\FileExts\ .hlp folder entry , and the right click gives me recommended program ? MicrosoftR Help (http://i.imgur.com/UcIlDr3.jpg)

DocAElstein
03-18-2021, 01:30 PM
Some misc rough notes in support of the last few Posts..




Drucky 20thMarch (Vista)
http://i.imgur.com/e1kw9m8.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/LCmH12Q.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/0QP15Z3.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/rO8dxOs.jpg

unassoc.exe has first option greyed out


Klaus lapTop 20thMarch (Vista)
http://i.imgur.com/urvtLOa.jpg]
HKEY_CLASSES_ROOT http://i.imgur.com/A6TZEvU.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/E6FLTpk.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Ho9s4XH.jpg

unassoc.exe has first option greyed out


KB 20thMarch (Vista)
http://i.imgur.com/pJpGvUv.jpg https://i.imgur.com/6P2WiQ1.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/itdpSVx.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/NKuq1YS.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Fhb3XfI.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/qOVdnMq.jpg

untypically unassoc.exe software has all options available http://i.imgur.com/HSaIsTs.jpg



ACER 22th March (Vista) (After YellowToBlueToYellow, no use of unassoc.exe
https://i.imgur.com/wcAWBxe.jpg
Note: there are no other entries : http://i.imgur.com/wdeSTls.jpg

HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/wGAXvdT.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/pa8lQO3.jpg HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hg1nOLc.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/DpCPqSn.jpg
unassoc.exe now has the first option showing http://i.imgur.com/TdkDLTw.jpg















HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg

























HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice















http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to this Thread Post https://eileenslounge.com/viewtopic.php?p=281642&sid=a32fee2abaf5df4161a4a9a228569efb#p281642

…. Associating wonks…
We are looking for a solution to get the .hlp files to come up when double clicking on it
In particular here, we are investigating a suggested solution which involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
In short: that works well. I had success with this. Sometimes some tweaking was necessary… The following are the notes from that.

Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg) ( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it. )
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (http://i.imgur.com/FsF7ew7.jpg) )


Situation 2 (Vista)
This is the more common situation.
Double clicking on a .hlp file brings up a window telling you that the hlp (http://i.imgur.com/F5Ap67q.jpg) stuff is out of date and unsupported (http://i.imgur.com/tEu1L23.jpg). ( You will find a lot of reports on the internet from people who see this window a lot. Often this process and/or the associated file is somehow referred to with the word “Stub”** ).
Right clicking (http://i.imgur.com/ilIjYLm.jpg) on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg). -** A general concept similar to this may be referred to as a “help stub” , (https://support.microsoft.com/en-us/topic/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported-3c841463-d67c-6062-0ee7-1a149da3973b) a sort of Microsoft support but without any support at all. (https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350375) All of the downloads suggested there, or at other Internet sites (https://www.pconlife.com/fileinfo/winhlp32.exe-info/) , either aren’t available anymore, or don’t work.
If you simply ignore the suggested “stub” file association , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
1_RightClickOpüenWith 2_Browse 3_Select 4_Open(Select) 5_OK (http://i.imgur.com/5HvRivB.jpg)
That seemed to do the job, - there after, a double click on my .hlp file opened it up


A last Note on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed: Start using keys MicrosoftSymbol+r or some similar route via the start menu ( bottom left Microsoft Symbol ). …_
Microsoft Symbol Run.JPG , GetIntoVistaRegisterEditor.JPG : http://i.imgur.com/VwprMgF.jpg ; http://i.imgur.com/ai1s0JN.jpg
_.. etc.. as in next section Windows 7 for how to to delete a file association …
Even if the dissociation is not necessary , it does Appear to tidy things up a bit. The disassociation clears away the Stub, (http://i.imgur.com/JMhy687.jpg) and if you then re do the right click open with browse Select OK stuff, the stub will be replaced by the Microsoft help (http://i.imgur.com/gqeN7bE.jpg) – It is the Registry entry in HKEY_CURRENT_USER ….. which is responsible for the Stub unhelpful help window

Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/) ***
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to this Thread Post https://eileenslounge.com/viewtopic.php?p=281642&sid=a32fee2abaf5df4161a4a9a228569efb#p281642

…. Associating wonks…
We are looking for a solution to get the .hlp files to come up when double clicking on it
In particular here, we are investigating a suggested solution which involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
In short: that works well. I had success with this. Sometimes some tweaking was necessary… The following are the notes from that.

Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg) ( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it. )
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (http://i.imgur.com/FsF7ew7.jpg) )


Situation 2 (Vista)
This is the more common situation.
Double clicking on a .hlp file brings up a window telling you that the hlp (http://i.imgur.com/F5Ap67q.jpg) stuff is out of date and unsupported (http://i.imgur.com/tEu1L23.jpg). ( You will find a lot of reports on the internet from people who see this window a lot. Often this process and/or the associated file is somehow referred to with the word “Stub”** ).
Right clicking (http://i.imgur.com/ilIjYLm.jpg) on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg). -** A general concept similar to this may be referred to as a “help stub” , (https://support.microsoft.com/en-us/topic/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported-3c841463-d67c-6062-0ee7-1a149da3973b) a sort of Microsoft support but without any support at all. (https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350375) All of the downloads suggested there, or at other Internet sites (https://www.pconlife.com/fileinfo/winhlp32.exe-info/) , either aren’t available anymore, or don’t work.
If you simply ignore the suggested “stub” file association , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
1_RightClickOpüenWith 2_Browse 3_Select 4_Open(Select) 5_OK (http://i.imgur.com/5HvRivB.jpg)
That seemed to do the job, - there after, a double click on my .hlp file opened it up


A last Note on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed: Start using keys MicrosoftSymbol+r or some similar route via the start menu ( bottom left Microsoft Symbol ). …_
Microsoft Symbol Run.JPG , GetIntoVistaRegisterEditor.JPG : http://i.imgur.com/VwprMgF.jpg ; http://i.imgur.com/ai1s0JN.jpg
_.. etc.. as in next section Windows 7 for how to to delete a file association …
Even if the dissociation is not necessary , it does Appear to tidy things up a bit. The disassociation clears away the Stub, (http://i.imgur.com/JMhy687.jpg) and if you then re do the right click open with browse Select OK stuff, the stub will be replaced by the Microsoft help (http://i.imgur.com/gqeN7bE.jpg) – It is the Registry entry in HKEY_CURRENT_USER ….. which is responsible for the Stub unhelpful help window

Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/) ***
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-18-2021, 01:30 PM
_____ Workbook: Extract missing dates for each person d Transpose.xlsm ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K

15465 Apples$50 Twenty =FIND("$",A1)=LEFT(A1,B1)=FIND(" ",C1)=RIGHT(C1,LEN(C1)-D1)=RIGHT(A1,LEN(A1)-B1)=FIND(" ",F1)=LEFT(F1,G1-1)=E1&H1=RIGHT(LEFT(A1,FIND("$",A1)),LEN(LEFT(A1,FIND("$",A1)))-FIND(" ",LEFT(A1,FIND("$",A1))))&LEFT(RIGHT(A1,LEN(A1)-FIND("$",A1)),FIND(" ",RIGHT(A1,LEN(A1)-FIND("$",A1)))-1)


25687 Grapes$597 Three =FIND("$",A2)=LEFT(A2,B2)=FIND(" ",C2)=RIGHT(C2,LEN(C2)-D2)=RIGHT(A2,LEN(A2)-B2)=FIND(" ",F2)=LEFT(F2,G2-1)=E2&H2=RIGHT(LEFT(A2,FIND("$",A2)),LEN(LEFT(A2,FIND("$",A2)))-FIND(" ",LEFT(A2,FIND("$",A2))))&LEFT(RIGHT(A2,LEN(A2)-FIND("$",A2)),FIND(" ",RIGHT(A2,LEN(A2)-FIND("$",A2)))-1)
Worksheet: Sheet2

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to this Thread Post https://eileenslounge.com/viewtopic.php?p=281642&sid=a32fee2abaf5df4161a4a9a228569efb#p281642

…. Associating wonks…
We are looking for a solution to get the .hlp files to come up when double clicking on it
In particular here, we are investigating a suggested solution which involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
In short: that works well. I had success with this. Sometimes some tweaking was necessary… The following are the notes from that.

Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg) ( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it. )
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (http://i.imgur.com/FsF7ew7.jpg) )


Situation 2 (Vista)
This is the more common situation.
Double clicking on a .hlp file brings up a window telling you that the hlp (http://i.imgur.com/F5Ap67q.jpg) stuff is out of date and unsupported (http://i.imgur.com/tEu1L23.jpg). ( You will find a lot of reports on the internet from people who see this window a lot. Often this process and/or the associated file is somehow referred to with the word “Stub”** ).
Right clicking (http://i.imgur.com/ilIjYLm.jpg) on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg). -** A general concept similar to this may be referred to as a “help stub” , (https://support.microsoft.com/en-us/topic/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported-3c841463-d67c-6062-0ee7-1a149da3973b) a sort of Microsoft support but without any support at all. (https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350375) All of the downloads suggested there, or at other Internet sites (https://www.pconlife.com/fileinfo/winhlp32.exe-info/) , either aren’t available anymore, or don’t work.
If you simply ignore the suggested “stub” file association , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
1_RightClickOpüenWith 2_Browse 3_Select 4_Open(Select) 5_OK (http://i.imgur.com/5HvRivB.jpg)
That seemed to do the job, - there after, a double click on my .hlp file opened it up


A last Note on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed: Start using keys MicrosoftSymbol+r or some similar route via the start menu ( bottom left Microsoft Symbol ). …_
Microsoft Symbol Run.JPG , GetIntoVistaRegisterEditor.JPG : http://i.imgur.com/VwprMgF.jpg ; http://i.imgur.com/ai1s0JN.jpg
_.. etc.. as in next section Windows 7 for how to to delete a file association …
Even if the dissociation is not necessary , it does Appear to tidy things up a bit. The disassociation clears away the Stub, (http://i.imgur.com/JMhy687.jpg) and if you then re do the right click open with browse Select OK stuff, the stub will be replaced by the Microsoft help (http://i.imgur.com/gqeN7bE.jpg) – It is the Registry entry in HKEY_CURRENT_USER ….. which is responsible for the Stub unhelpful help window

Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/) ***
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-18-2021, 01:30 PM
Klaus lapTop 27thMarch (Windows 7):
http://i.imgur.com/6nP7e6u.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/iLry5yI.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/y3EHTsI.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/9hH5KVw.jpg

unassoc.exe has first option greyed out


























The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to these Thread Posts https://eileenslounge.com/viewtopic.php?p=281642&sid=a32fee2abaf5df4161a4a9a228569efb#p281642
https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350832


…. Associating wonks…
We are looking for a solution to get the .hlp files to come up when double clicking on it
In particular here, we are investigating a suggested solution which involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
Something that looks something along these lines: http://i.imgur.com/oWZZ0kw.jpg http://i.imgur.com/LwYnvHS.jpg
In short: that works well. I had success with this. Sometimes some tweaking was necessary… The following are the notes from that.

Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg) ( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it. )
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (http://i.imgur.com/FsF7ew7.jpg) Via the Controlpanel I see http://i.imgur.com/gl06ZKH.jpg )
( Note also: In this case, untypical an unassociate software has all options available - See later ** in next post for more details http://i.imgur.com/HSaIsTs.jpg )

Situation 2 (Vista)
This is the more common situation.
Double clicking on a .hlp file brings up a window telling you that the hlp (http://i.imgur.com/F5Ap67q.jpg) stuff is out of date and unsupported (http://i.imgur.com/tEu1L23.jpg). ( You will find a lot of reports on the internet from people who see this window a lot. Often this process and/or the associated file is somehow referred to with the word “Stub”** ).
Right clicking (http://i.imgur.com/ilIjYLm.jpg) on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg). -** A general concept similar to this may be referred to as a “help stub” , (https://support.microsoft.com/en-us/topic/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported-3c841463-d67c-6062-0ee7-1a149da3973b) a sort of Microsoft support but without any support at all. (https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350375) All of the downloads suggested there, or at other Internet sites (https://www.pconlife.com/fileinfo/winhlp32.exe-info/) , either aren’t available anymore, or don’t work.
If you simply ignore the suggested “stub” file association , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
1_RightClickOpüenWith 2_Browse 3_Select 4_Open(Select) 5_OK (http://i.imgur.com/5HvRivB.jpg)
That seemed to do the job, - there after, a double click on my .hlp file opened it up


Some other notes on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed: Start using keys MicrosoftSymbol+r or some similar route via the start menu ( bottom left Microsoft Symbol ). …_
Microsoft Symbol Run.JPG , GetIntoVistaRegisterEditor.JPG : http://i.imgur.com/VwprMgF.jpg , http://i.imgur.com/ai1s0JN.jpg
_.. etc.. as in next section Windows 7 for how to to delete a file association …
Even if the dissociation is not necessary , it does Appear to tidy things up a bit. The disassociation clears away the Stub, (http://i.imgur.com/JMhy687.jpg) and if you then re do the right click open with browse Select OK stuff, the stub will be replaced by the Microsoft help (http://i.imgur.com/gqeN7bE.jpg) – It is the Registry entry in HKEY_CURRENT_USER ….. which is responsible for the Stub unhelpful help window

A YellowToBlueToYellow ( Vista Acer )
With operating systems from Vista, the icon seen in Explorer or on the Desktop seems to change sometimes from Blue to yellow.
Approximately , the working solution seems to be mostly associated with yellow, and Blue is often an indication of the no use stub thing. That is not a clear cut rule, its only approximate.
Here is an example of some experiments , starting from a small old ACER Vista pc
At the start of the experiments I had got the working solution to automatic opening of the help file. All is Yellow
http://i.imgur.com/GF4t1C8.jpg , http://i.imgur.com/2YYMV0a.jpg
But note in the last screenshot , I have no option other than the “Stub”
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/JeAsGK5.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1GkiHWH.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/sh5yVJQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/Yx7ZJ0m.jpg

To go Blue , one simply needs to click on the (yellow) stub above, after a right click open with: After the OK , the computer blinks a bit, and the Icon in the explorer window, or , if on desktop, turns blue.
We then have the help that’s no help situation on double clicking, http://i.imgur.com/uOCwS3C.jpg , and the registry entries have changed.
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/jSoyJbB.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/NOaDyah.jpg HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/l6QSAZj.jpg

unassoc.exe has first option greyed out http://i.imgur.com/vRth42e.jpg
I go back to yellow after I hit the OK via the usual right click open with browse select OK (http://i.imgur.com/sDIx9dw.jpg) stuff. Then the double click works. I notice that I do have a second entry, this time at the bottom, although in the past I don’t always see that. Note: In fact it went away later
http://i.imgur.com/9eni0Gn.jpg
http://i.imgur.com/w9QmlE0.jpg
The registry entries have changed.
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/wGAXvdT.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/pa8lQO3.jpg HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hg1nOLc.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/DpCPqSn.jpg
unassoc.exe now has the first option showing http://i.imgur.com/TdkDLTw.jpg


Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/) ***
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg


Virgin (X110) (Win 7)
Initially there was just the HKEY_CLASSES_ROOT\.hpl with ab (Standard) REG_SZ hlpfile
I ran unassoc.exe and that was gone as well!
I downloaded the .hlp file , which had a blank icon, and no open with option on the right click. On the double click the new window (https://imgur.com/s5JTec1.jpg) appeared.
I downloaded winhlp32.exe , restarted the computer and the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList appeared. (http://i.imgur.com/Wc7Z43Q.jpg ) Still no right click option.
So I browse from the New Window on double click. ( At the start is no Recommended Programs at the top, but the stub is found at C:\Windows\winsxs\x86_microsoft-windows-winhstb_31bf3856ad364e35_6.1.7600.16385_none_28dc6 47c6aba6742 , BTW as per https://www.pconlife.com/fileinfo/winhlp32.exe-info/ http://i.imgur.com/VcdNXwp.jpg )
https://i.imgur.com/rFsKTN8.jpg
Here is then the situation, initially seeing a yellow ? on the icon, double clicking working, and the initial Other Programs entry soon changes to a Recommended programs (http://i.imgur.com/J7debqu .jpg[/url) entry
HKEY_CLASSES_ROOT\.hlp [url]http://i.imgur.com/dUSpyAs.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/S9mhR61.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/akvM638.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to this Thread Post https://eileenslounge.com/viewtopic.php?p=281746&sid=cc18222d1e76e492a277747afa644906#p281746

CommandDescription

Remove file association (User)Removes the user-specific association (via the Open With dialog) for the chosen file type. Note that this button will remain dimmed if there is no user-specific association for the file type.

Delete file typeDeletes the file type completely from the registry. Both the user-specific and global associations for the chosen file type is removed.

Refresh listRefreshes the list box contents.




*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

Re try Win7 unassoc.exe exp ( X110 Win 7)
I am starting at a working after right click brose situation, with first option greyed out
Recommended programs (http://i.imgur.com/r3kcKAZ.jpg) entry
HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/dUSpyAs.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/S9mhR61.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/akvM638.jpg
I run unassoc.exe , and immediately after taking the second option, the yellow ? on the icon vanishes. The HKEY_CLASSES_ROOT\.hlp folder is gone. The two HKEY_CURRENT_USER \Software\Microsoft\Windows\CurrentVersion\Explore r\FileExts\ .hlp folder entries have not changed
I do the right click browse from double click new window to my downloaded desktop winhlp32.exe
I have the yellow ? on the desktop icon, and unassoc.exe shows first option!!
The HKEY_CLASSES_ROOT\.hlp folder entry is back, and I have an extra HKEY_CURRENT_USER \Software\Microsoft\Windows\CurrentVersion\Explore r\FileExts\ .hlp folder entry , and the right click gives me recommended program ? MicrosoftR Help (http://i.imgur.com/UcIlDr3.jpg)

DocAElstein
03-18-2021, 01:30 PM
Some misc rough notes in support of the last few Posts..




Drucky 20thMarch (Vista)
http://i.imgur.com/e1kw9m8.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/LCmH12Q.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/0QP15Z3.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/rO8dxOs.jpg

unassoc.exe has first option greyed out


Klaus lapTop 20thMarch (Vista)
http://i.imgur.com/urvtLOa.jpg]
HKEY_CLASSES_ROOT http://i.imgur.com/A6TZEvU.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/E6FLTpk.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Ho9s4XH.jpg

unassoc.exe has first option greyed out


KB 20thMarch (Vista)
http://i.imgur.com/pJpGvUv.jpg https://i.imgur.com/6P2WiQ1.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/itdpSVx.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/NKuq1YS.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Fhb3XfI.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/qOVdnMq.jpg

untypically unassoc.exe software has all options available http://i.imgur.com/HSaIsTs.jpg



ACER 22th March (Vista) (After YellowToBlueToYellow, no use of unassoc.exe
https://i.imgur.com/wcAWBxe.jpg
Note: there are no other entries : http://i.imgur.com/wdeSTls.jpg

HKEY_CLASSES_ROOT\.hlp http://i.imgur.com/wGAXvdT.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/pa8lQO3.jpg HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hg1nOLc.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/DpCPqSn.jpg
unassoc.exe now has the first option showing http://i.imgur.com/TdkDLTw.jpg















HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg

























HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice















http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-18-2021, 01:30 PM
Some expanded notes related to this Thread Post https://eileenslounge.com/viewtopic.php?p=281642&sid=a32fee2abaf5df4161a4a9a228569efb#p281642

…. Associating wonks…
We are looking for a solution to get the .hlp files to come up when double clicking on it
In particular here, we are investigating a suggested solution which involves doing once something of this form:
- Right-click a .hlp file.
- Select Open With... from the context menu.
- If you see winhlp32.exe, select it and tick the check box 'Always use this app to open .hlp files'. then click OK.
- If not, click 'More apps', then scroll down and select 'Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32, then click OK. (https://eileenslounge.com/viewtopic.php?p=281642#p281642 )
In short: that works well. I had success with this. Sometimes some tweaking was necessary… The following are the notes from that.

Vista

I had a couple of different situations which required different actions to get the thing working
Situation 1 ( Vista )
On some Vista computers, double clicking on a .hlp does nothing.
Right clicking on a .hlp file gave me an error, which in English translates to something like
No program is assigned to the file to carry out this action. Create an assignment in the "Control Panel" under "Assignments". (http://i.imgur.com/SBauu7t.jpg)
I went looking where that error told me to look, but such a thing did not exist. By luck, on typing in the suggested thing in the explorer top right search bar, I saw something along the lines of Standard Program (http://i.imgur.com/ZXQo2tU.jpg) , which looked promising
After clicking around a bit I Got to a window similar to what you often get after a ---Right-click on a file ---- - Select Open With ---- action (http://i.imgur.com/e9TbvHE.jpg)
I then did something which is my German equivalent of something like Look for another app on this PC'.
- Browse to C:\Windows\System32, locate and select winhlp32.exe , then click OK.. (http://i.imgur.com/EwWIhmI.jpg) ( I don’t yet have my winhlp32.exe at a typical Windows system type place. So I navigated to where it was and did the German equivalent of select and OK on it. )
That seemed to do the job, - then after a double click on my .hlp file opened it up
( Note however, that whilst the double left click opens the help file, the right click followed by Open With still gives me the original error (http://i.imgur.com/FsF7ew7.jpg) )


Situation 2 (Vista)
This is the more common situation.
Double clicking on a .hlp file brings up a window telling you that the hlp (http://i.imgur.com/F5Ap67q.jpg) stuff is out of date and unsupported (http://i.imgur.com/tEu1L23.jpg). ( You will find a lot of reports on the internet from people who see this window a lot. Often this process and/or the associated file is somehow referred to with the word “Stub”** ).
Right clicking (http://i.imgur.com/ilIjYLm.jpg) on the .hlp file and selecting Open With shows you that some program is assigned (http://i.imgur.com/zO8OojW.jpg). -** A general concept similar to this may be referred to as a “help stub” , (https://support.microsoft.com/en-us/topic/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported-3c841463-d67c-6062-0ee7-1a149da3973b) a sort of Microsoft support but without any support at all. (https://www.tenforums.com/general-support/108565-how-open-old-hlp-files-windows-10-a.html#post1350375) All of the downloads suggested there, or at other Internet sites (https://www.pconlife.com/fileinfo/winhlp32.exe-info/) , either aren’t available anymore, or don’t work.
If you simply ignore the suggested “stub” file association , then browse to find the winhlp32.exe where ever you have it, then select it and then OK.
1_RightClickOpüenWith 2_Browse 3_Select 4_Open(Select) 5_OK (http://i.imgur.com/5HvRivB.jpg)
That seemed to do the job, - there after, a double click on my .hlp file opened it up


A last Note on Vista
I don’t have an infinite number of Vista machines, and based on some googling I expect sometimes a solution like I needed in my Windows 7 machines might be needed: Start using keys MicrosoftSymbol+r or some similar route via the start menu ( bottom left Microsoft Symbol ). …_
Microsoft Symbol Run.JPG , GetIntoVistaRegisterEditor.JPG : http://i.imgur.com/VwprMgF.jpg ; http://i.imgur.com/ai1s0JN.jpg
_.. etc.. as in next section Windows 7 for how to to delete a file association …
Even if the dissociation is not necessary , it does Appear to tidy things up a bit. The disassociation clears away the Stub, (http://i.imgur.com/JMhy687.jpg) and if you then re do the right click open with browse Select OK stuff, the stub will be replaced by the Microsoft help (http://i.imgur.com/gqeN7bE.jpg) – It is the Registry entry in HKEY_CURRENT_USER ….. which is responsible for the Stub unhelpful help window

Windows 7
Initially the situation appeared to be similar to that last situation 2 Vista: Right clicking on the file gets me an open with option, and that suggest some program is assigned to it. (http://i.imgur.com/oS8VdOV.jpg)
Double clicking on a .hlp file brings up a window telling you that the hlp stuff is out of date and unsupported (http://i.imgur.com/u5WAxKl.jpg)
At this point it differs from the Vista situation, in that after doing, (from that right click , open with) the browsing, selecting, OK stuff, (http://i.imgur.com/nSI8prS.jpg) we find the situation has not changed and we have the same situation as at the beginning.
_... I followed the first part of this How to delete a file association in Windows 7 (https://websistent.com/delete-file-association-windows-7/) ***
After this, I got as they suggested at that link, on a right click on a help file, a new window (http://i.imgur.com/e0WnulM.jpg)
I then find that the working solution is to do something via the Control panel, similar to the very first situation 1 Vista
http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-20-2021, 06:14 PM
Keks (XP) 27th March
http://i.imgur.com/zVPiWSV.jpg
http://i.imgur.com/6aAhFiV.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/f4y9UI0.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/u5cDnEv.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/MiaUX4b.jpg







































HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice















http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-20-2021, 06:14 PM
Post for latr use

DocAElstein
03-20-2021, 06:14 PM
Keks (XP) 27th March
http://i.imgur.com/zVPiWSV.jpg
http://i.imgur.com/6aAhFiV.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/f4y9UI0.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/u5cDnEv.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/MiaUX4b.jpg







































HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice















http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-20-2021, 06:14 PM
Post for latr use

DocAElstein
03-20-2021, 06:14 PM
Keks (XP) 27th March
http://i.imgur.com/zVPiWSV.jpg
http://i.imgur.com/6aAhFiV.jpg
HKEY_CLASSES_ROOT http://i.imgur.com/f4y9UI0.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/u5cDnEv.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/MiaUX4b.jpg







































HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice















http://i.imgur.com/cD7mrtT.jpg
http://i.imgur.com/oJ0in2l.jpg
I finally end up with these ( new ) registry entries
HKEY_CLASSES_ROOT\.hpl http://i.imgur.com/wz8jVsr.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/ulLwM3T.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/INpVZNE.jpg



*** Using unassoc.exe https://eileenslounge.com/viewtopic.php?p=281746#p281746 , https://app.box.com/s/e7dd2hopzyinrrb2fdkk72scikw4rr6n
https://www.winhelponline.com/blog/unassociate-file-types-windows-7-vista/
An alternative for disassociating …
Vista: I examined the two entries, HKEY_CURRENT_USER ….. (http://i.imgur.com/NhGnyfo.jpg) and HKEY_CLASSES_ROOT (http://i.imgur.com/tulFWn3.jpg), in the registry before and then after below.
Using the software , unassoc.exe , I only had the the second delete option : http://i.imgur.com/mEB7aLo.jpg , http://i.imgur.com/QkXP0Ip.jpg , http://i.imgur.com/jJWVIXP.jpg
The .hlp no longer appears in the list after taking that delete option
The software seemsed to take off the HKEY_CLASSES_ROOT\.hlp only: Even after a computer restart, the HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp is still there
After following the usual way to re associate, the .hlp reappears in the list, but the removed entry does not re appear for HKEY_CLASSES_ROOT … so I have no HKEY_CLASSES_ROOT Here is the after for the other
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/1npC9iP.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/Y4uRKQi.jpg
Initially I seemed to have success.
The icon was blue suddenly. Double clicking stopped working and instead resorted back to the help that’s no help window.
After following the usual way to re associate, the icon turned yellow, the automatic opening worked, and an entry re appeared at
HKEY_CLASSES_ROOT http://i.imgur.com/nJzZYn7.jpg


Windows 7: The two entries appeared to be the same as in Vista
On running the software, I appear to have both options available. http://i.imgur.com/UUjBg8L.jpg
So I tried the first option first http://i.imgur.com/wiFxg7M.jpg , after which the first option became greyed out, http://i.imgur.com/fJGSmfN.jpg
The .hlp still appears in the list , and both entries are still in the registry, and the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing does not result in a successful opening of the .hlp file on double clicking on it. ( Note: the right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association thing brings back the first option
Taking the second option, http://i.imgur.com/IO2MxTj.jpg , http://i.imgur.com/msWhKn5.jpg , removes the HKEY_CLASSES_ROOT\.hlp only and removes the .hlp in the unassoc.exe list.
After this we lose the blue question mark icon, and have no rightclick OpenWith option, and on double clicking on the, now plain, icon, we get the new window. http://i.imgur.com/ZnFx1xx.jpg
Following the browsing (http://i.imgur.com/2SvmQ0g.jpg) from this new window (http://i.imgur.com/1vxTAj6.jpg) appears to have no effect, other than strangely bringing back the blue question mark icon and the right click OpenWith option
The newly re available route of right click-Open With-Browse-Select/Open- my downloaded winhlp.exe association appears to have no effect.
At this point the situation is that in the Registry we have nothing in no HKEY_CLASSES_ROOT and no entry for .hlp in the unassoc.exe list.
Strangely we have now three entries in HKEY_CURRENT_USER …..
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/AxiJxxE.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/efTpjNQ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\UserChoice http://i.imgur.com/C5p0aKn.jpg

So I now delete the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp … , which effectively leaves me with now no Registry entry.
Initially the .hlp file icon is blue , we have no OpenWith option and a double click leads to the new window. On a Computer restart , the blue question mark icon is replaced by no icon. unassoc.exe list has no .hlp and a single entry has appeared in the registry
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/Jz8zPFi.jpg
After double clicking I get the new window, and taking that route to make a new association , it takes some time before I get the window from which to browse. http://i.imgur.com/0GPeTGc.jpg
After this, all is OK, and note that the icon is yellow. http://i.imgur.com/W4TUt61.jpg
Here are the final Registries
HKEY_CLASSES_ROOT http://i.imgur.com/O3lKV4b.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/jVacdaq.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/hwpbLdq.jpg
( a .gid File also appeared )
unassoc.exe has a .hlp , the first option is greyed out, and after trying the second option, the yellow ? on the icon disappeared., we are back to the new window only after double click option… etc…
In the registry I have these
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/A0Y7cbY.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/I3D3XEP.jpg
I repeat the new window associate route, finally all is yellow ? well and Registry entries again
HKEY_CLASSES_ROOT http://i.imgur.com/JS1AjEJ.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithList http://i.imgur.com/FjEcyC1.jpg
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\.hlp\OpenWithProgids http://i.imgur.com/jnxXxd0.jpg

DocAElstein
03-20-2021, 06:14 PM
Post for latr use

DocAElstein
03-20-2021, 08:14 PM
Post for later use

DocAElstein
03-20-2021, 08:14 PM
Post for later use

DocAElstein
03-20-2021, 08:14 PM
Post for later use

DocAElstein
03-20-2021, 08:14 PM
Post for later use

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-27-2021, 02:00 PM
test


_____ Workbook: AssociationWonks.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E

1Recommended ProgramsOther ProgramsHKEY_CLASSES_ROOT
.hlp


2
Worksheet: Sheet1

DocAElstein
03-30-2021, 01:12 PM
Post for later use

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg (https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1 (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNe_XC-jK (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNe_XC-jK)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNPOdiDuv (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNPOdiDuv)
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgN7AC7wAc (https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgN7AC7wAc)
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm9wlhQrYJP 3M (https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm9wlhQrYJP 3M)
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg (https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg)
https://www.youtube.com/watch?v=DVFFApHzYVk&lc=Ugyi578yhj9zShmhuPl4AaABAg (https://www.youtube.com/watch?v=DVFFApHzYVk&lc=Ugyi578yhj9zShmhuPl4AaABAg)
https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgxvxlnuTRWiV6MUZB14AaABAg (https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgxvxlnuTRWiV6MUZB14AaABAg)
https://www.youtube.com/watch?v=_8i1fVEi5WY&lc=Ugz0ptwE5J-2CpX4Lzh4AaABAg (https://www.youtube.com/watch?v=_8i1fVEi5WY&lc=Ugz0ptwE5J-2CpX4Lzh4AaABAg)
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgxoHAw8RwR7VmyVBUt4AaABAg.9C-br0lEl8V9xI0_6pCaR9 (https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgxoHAw8RwR7VmyVBUt4AaABAg.9C-br0lEl8V9xI0_6pCaR9)
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=Ugz5DDCMqmHLeEjUU8t4AaABAg.9bl7m03Onql9xI-ar3Z0ME (https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=Ugz5DDCMqmHLeEjUU8t4AaABAg.9bl7m03Onql9xI-ar3Z0ME)
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgxYnpd9leriPmc8rPd4AaABAg.9gdrYDocLIm9xI-2ZpVF-q (https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgxYnpd9leriPmc8rPd4AaABAg.9gdrYDocLIm9xI-2ZpVF-q)
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgyjoPLjNeIAOMVH_u94AaABAg.9id_Q3FO8Lp9xHyeYSuv 1I (https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgyjoPLjNeIAOMVH_u94AaABAg.9id_Q3FO8Lp9xHyeYSuv 1I)
https://www.reddit.com/r/windowsxp/comments/pexq9q/comment/k81ybvj/?utm_source=reddit&utm_medium=web2x&context=3 (https://www.reddit.com/r/windowsxp/comments/pexq9q/comment/k81ybvj/?utm_source=reddit&utm_medium=web2x&context=3)
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg (https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg)
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm9wlhQrYJP 3M (https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm9wlhQrYJP 3M)
ttps://www.youtube.com/watch?v=LP9fz2DCMBE (ttps://www.youtube.com/watch?v=LP9fz2DCMBE)
https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg (https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg)
https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg.9wdo_rWgxSH9wdpcYqrv p8 (https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg.9wdo_rWgxSH9wdpcYqrv p8)
ttps://www.youtube.com/watch?v=bFxnXH4-L1A (ttps://www.youtube.com/watch?v=bFxnXH4-L1A)
https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxuODisjo6cvom7O-B4AaABAg.9w_AeS3JiK09wdi2XviwLG (https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxuODisjo6cvom7O-B4AaABAg.9w_AeS3JiK09wdi2XviwLG)
https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxBU39bTptFznDC1PJ4AaABAg (https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxBU39bTptFznDC1PJ4AaABAg)
ttps://www.youtube.com/watch?v=GqzeFYWjTxI (ttps://www.youtube.com/watch?v=GqzeFYWjTxI)
https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgwJnJDJ5JT8hFvibt14AaABAg (https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgwJnJDJ5JT8hFvibt14AaABAg)
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

DocAElstein
03-30-2021, 01:12 PM
Post for later use

DocAElstein
03-30-2021, 01:12 PM
Post for later use


https://i.postimg.cc/k5vWcGnv/Hitler.jpg (https://postimages.org/)

DocAElstein
03-30-2021, 01:12 PM
Post for later use

DocAElstein
03-30-2021, 01:12 PM
Post for later use

DocAElstein
03-30-2021, 01:12 PM
.,vmdvmd

DocAElstein
07-07-2023, 10:11 AM
spare post for later

DocAElstein
07-07-2023, 10:47 AM
Some notes in support of this main forum post
https://eileenslounge.com/viewtopic.php?f=27&t=39859


_____ Workbook: ctry_cd masteList.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F

1Country
Company
Country name
Logistics
Finance


2229
ABC
Algeria
01
5123


3229
UPS
Algeria
08
1552


4373
IBM
Mauritius offshore
01
5153


5382
Toshiba
Mali
01
5115


6383
Apple
Equatorial Guinea
01
0833


7602
IBM
Estonia
10
0393


8602
Microsoft
Estonia
NG
Y022


9610
SAP
ANGOLA
MC
5802


10613
GESNEXT
Argentina
TG
1458


11613
IBM
Argentina
01
0007


12
Worksheet: Sheet

DocAElstein
07-07-2023, 11:17 AM
Some notes in support of this main forum post
https://eileenslounge.com/viewtopic.php?f=27&t=39859


We can get simple data from a closed workbook. There are a few ways. The way shown here is the simplest, but often the most efficient way. I think it comes about because an “Excel file” , as we see it, is actually some combination of files somehow wrapped up in something that most of us know as an excel file.
One of the files has the values of used ranges, and/or something like that combined with a simplified sort of spreadsheet with just values in it. (I am not sure why that is. Maybe something to do with making things run more efficiently, since those files will be used often rather than looking at an entire sheet where lots of cells would typically be empty).

Strange looking string reference to a closed workbook
Microsoft lets us access the data without opening the full “Excel file”. We do that with a strange looking string reference. I don’t know why Microsoft chose to use such a strange syntax, but as Einstein cleverly advised, we should not waste our brain remembering some code that someone else dreamt up. Instead either note it somewhere , document it good and forget about it and/ or come up with a simple way to get it.

Get the awkward syntax for string reference to a closed workbook
Whether by design or accident, there is a simple way to get the awkward syntax.
Take for example the worksheet in an Excel file shown in the last post, https://www.excelfox.com/forum/showthread.php/2868-Test-Closed-Workbook-Excel-macros-XLM-(Excel-4-Macros)-winhlp32-files?p=21203&viewfull=1#post21203
Now do this
_ Open that workbook, ctry_cd masteList.xlsx
_ Open any other spare workbook
_ In the spare workbook do this
___ Type in any cell _ =
___Now click on the first cell in the worksheet, Sheet , in the workbook, ctry_cd masteList.xlsx
___Hit Enter

_ if you click on/ look at the cell you were typing in, then you should see this in the formula bar,
='[ctry_cd masteList.xlsx]Sheet'!$A$1
, and in the cell you will see the actiual cell value from the first cell in the worksheet, Sheet , in the workbook, ctry_cd masteList.xlsx , which is
Country
_ Now close the workbook, ctry_cd masteList.xlsx

_ Now you should see that strange looking reference mutate to something even more grotesque , ***the exact form will vary depending on where you have that file, ctry_cd masteList.xlsx , stored. This is what it looks like by me
='F:\Excel0202015Jan2016\ExcelForum\wbSheetMakerCl sdWbADOMsQueery\[ctry_cd masteList.xlsx]Sheet'!$A$1

_ You should see that it is still working , in other words it is getting you the value from the , now, closed workbook, ctry_cd masteList.xlsx

_ You should copy that reference and paste it somewhere, for example in a comment in the VB Editor

' ='F:\Excel0202015Jan2016\ExcelForum\wbSheetMakerCl sdWbADOMsQueery\[ctry_cd masteList.xlsx]Sheet'!$A$1

( ***Yours will look a bit different. )
In fact, you do already need to change that a bit, - just get rid of the $s

' ='F:\Excel0202015Jan2016\ExcelForum\wbSheetMakerCl sdWbADOMsQueery\[ctry_cd masteList.xlsx]Sheet'!A1


What to do with that reference to get a range of values (from a closed workbook)
You need to understand one of the most basic things about Excel that so far only I do.
A cell reference without the $s is not really a cell reference. It is a vector, and the value, A1 in this case, tells us how far you are from the origin. If you place that vector, ( stretch it, if you like), into the next cell, then Excel will display you B1

In the example file, lets say I want to import that range into a spare worksheet into a spare workbook, SpareWorkbook.xls
So all I need to do is paste that vector into some range of a similar size. The range I want from the worksheet, Sheet , in the workbook, ctry_cd masteList.xlsx is A1:E11
For no particular reason I will choose a spare range of B2:F12

This coding will put the vector in that range, and then convert the reference into the actual values from the closed workbook that the reference gets you in each cell.
(For convenience, if I put that spare workbook in the same folder as the file in which ctry_cd masteList.xlsx is, then I can simplifier the coding a bit, which is what the ThisWorkbook.Path is about)


' https://www.excelfox.com/forum/showthread.php/2868-Test-Closed-Workbook-Excel-macros-XLM-(Excel-4-Macros)-winhlp32-files?p=21204&viewfull=1#post21204
' https://eileenslounge.com/viewtopic.php?f=27&t=39859

' ='F:\Excel0202015Jan2016\ExcelForum\wbSheetMakerCl sdWbADOMsQueery\[ctry_cd masteList.xlsx]Sheet'!$A$1
Sub PutTheVectorInToGetTheValuesFromClosedWorkbook()
Let Range("B2:F12").Value = "='F:\Excel0202015Jan2016\ExcelForum\wbSheetMakerCl sdWbADOMsQueery\[ctry_cd masteList.xlsx]Sheet'!A1" ' YOU WILL NEED to change the path to suit where you have the closed file, ctry_cd masteList.xlsx
' Or, if you have the closed file in the same folder as the file from which this macro is run, then you can use the next line
Let Range("B2:F12").Value = "='" & ThisWorkbook.path & "\[ctry_cd masteList.xlsx]Sheet'!A1"
Let Range("B2:F12").Value = Range("B2:F12").Value
End Sub




If you want to test out what I am talking about,
_ Put both attached files in the same folder.
_ Open just SpareWorkbook.xls
_ Run the macro Sub PutTheVectorInToGetTheValuesFromClosedWorkbook() which is in the, now open, workbook , SpareWorkbook.xls, and be amazed.





https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

DocAElstein
07-09-2023, 01:04 AM
Some more notes and observations for this post
https://eileenslounge.com/viewtopic.php?p=308967#p308967

Consider the original file, ctry_cd masteList.xlsx

We can make a copy of the original file :
https://i.postimg.cc/cgRb9nB3/Make-copy-of-xlsx-book.jpg (https://postimg.cc/cgRb9nB3)4929


We can be a bit naughty and change the extension to .zip
https://i.postimg.cc/23YJq0C7/Change-type-to-zip.jpg (https://postimg.cc/23YJq0C7)4930
https://i.postimg.cc/9XwjnkSK/Change-type-to-zip.jpg (https://postimages.org/)



Then we can take a look at what is in it.
https://i.postimg.cc/yWTG00d4/Look-inside-the-zip.jpg (https://postimg.cc/yWTG00d4)4931
https://i.postimg.cc/5NcMd3W0/Look-inside-the-zip.jpg (https://postimages.org/)



For example take a look at the Xl folder
https://i.postimg.cc/4HXFrxWS/Look-inside-the-Xl.jpg (https://postimg.cc/4HXFrxWS)4932
https://i.postimg.cc/vTnFx1fb/Look-inside-the-Xl.jpg (https://postimages.org/)




After looking around a bit we can find the values from used ranges in simple XML files.
https://i.postimg.cc/0MR40fDx/Look-around-a-bit-at-the-xml-files.jpg (https://postimg.cc/0MR40fDx)4933
https://i.postimg.cc/hjfqgZGJ/Look-around-a-bit-at-the-xml-files.jpg (https://postimages.org/)




My guess is that we can get at the value info quite efficiently from those files, just as we can often get at such simple value information by using various methods to get at text files. My guess is that I can treat a XML file as a simple .txt file


My theory is that my simple closed workbook reference may somehow short-circuit / by-pass the various data base complicated methods, and perhaps work better than such various data base complicated methods.

sandy666
07-09-2023, 03:13 AM
Someone who is a vba fucker shouldn't talk about databases and PQ at all without any idea how it works

DocAElstein
07-09-2023, 02:42 PM
But then nobody should talk about it, because no one knows how it works. Probably no one knows really how VBA works either. We’re all ignorant fuckers most of the time

sandy666
07-09-2023, 02:52 PM
if you say so...

DocAElstein
07-09-2023, 03:02 PM
Correct, https://i.postimg.cc/k5vWcGnv/Hitler.jpg (https://postimages.org/) :)

sandy666
07-09-2023, 03:18 PM
sieg heil! :cool: