Windows 10 and Office Excel

**DocAElstein** · 03-20-2018, 04:09 PM

slkhflskhfslkhf

**DocAElstein** · 03-20-2018, 04:09 PM

slkhflskhfslkhf

**DocAElstein** · 03-20-2018, 04:09 PM

slkhflskhfslkhf

**DocAElstein** · 03-20-2018, 04:09 PM

slkhflskhfslkhf

**DocAElstein** · 03-20-2018, 04:09 PM

slkhflskhfslkhf

**DocAElstein** · 03-20-2018, 04:09 PM

This is Thread Post 491 Forum Post 12766
https://www.excelfox.com/forum/showt...ge50#post12766
( link to youtube listings https://excelfox.com/forum/showthrea...ge42#post12685
https://excelfox.com/forum/showthrea...ge41#post12674
Link to last post on page 42 https://excelfox.com/forum/showthrea...ge42#post12693
Link to first post in page 43 https://excelfox.com/forum/showthrea...ge43#post12694
Link to first post in page 41 https://excelfox.com/forum/showthrea...ge41#post12674 )

Pull a Plonker #1

Microsoft Office, Bloatware?? – I doubt it

I might come back here when I have proved that the modification is necerssary. I don’t want to risk testing this yet, as if I am right and in testing I loose my Microsoft Office, then it can be a real pain to get it back: Despite having all the expensively purchased ( by me) disks with the Keys, Microsoft make virtually impossible to re install more than a couple of times.

In an earlier live stream video, around minute here and minute here , Chris mentions that he comments out the code line of
"Microsoft.MicrosoftOfficeHub"
so as to avoid deleting Microsoft office. On many other occasions he says following lots of request he is not going to delete it in any script of his. Never the less as I write this around Xmas New Year 2021 2022 , its constantly there in his scripts. Possibly its crept in since he is using GitHub to control his versions etc, GitHub IMO is worse than useless

I have left a few messages and replies to ask about this. I have had no reply and I don’t believe on badgering people who aren’t responding, as with people who are getting too many messages to cope, then it just fuels the situation and makes it worse.

So this Pull a Plonker #1 is doing this
# "Microsoft.MicrosoftOfficeHub"

Pull a Plonker #2

Push Pull Plonker WAP Properites Telemetry ( "DiagTrack" "dmwappushservice" stuff )

In this YouTube video at minute 1, Chris talks about disabling a couple of services, https://youtu.be/yXaYszT11CA?t=60
I expect that these code lines are the implementation of this in

Code:

 
Write-Host "Stopping and disabling Diagnostics Tracking Service..." 
Stop-Service "DiagTrack" -WarningAction SilentlyContinue
Set-Service "DiagTrack" -StartupType Disabled
Write-Host "Stopping and disabling WAP Push Service..."
Stop-Service "dmwappushservice" -WarningAction SilentlyContinue 
Set-Service "dmwappushservice" -StartupType Disabled

All well and good.
But in a later Live Stream video, Redesigning the Windows Toolbox, streamed live on Oct 29, 2021 he added a script bit a bit further down to set a few services to Manual, including these two.
So either those later two lines ( in # Service tweaks to Manual ) need to be removed, or the above bit should be removed.

For now I will take out the later lines thus

Code:

   # Service tweaks to Manual 
 
    $services = @(
    "diagnosticshub.standardcollector.service"     # Microsoft (R) Diagnostics Hub Standard Collector Service
     # "DiagTrack"                                    # Diagnostics Tracking Service        https://i.postimg.cc/ZK23pZyY/Services-MSC-Telemetrie.jpg
    "DPS"
     # "dmwappushservice"                             # WAP Push Message Routing Service (see known issues)  https://i.postimg.cc/t466zfh3/dmwappush.jpg

There is also a possible issue with the Undo Essential Tweaks not putting these back exactly as they were. But maybe I will look at that later ( https://eileenslounge.com/viewtopic.php?f=18&t=37712 )

Edit later Looking at this issue of the Services, Getting at them, it seems that
_ you will need PowerShell 7._ to do anything with
Start up Type AutomaticDelayedStart http://www.eileenslounge.com/viewtop...292019#p292019
http://www.eileenslounge.com/viewtopic.php?f=18&t=37740

See also here
https://excelfox.com/forum/showthrea...ge51#post12777

**DocAElstein** · 03-20-2018, 04:09 PM

This is post https://excelfox.com/forum/showthrea...ge50#post12767
https://excelfox.com/forum/showthread.php/2408-Windows-10-and-Office-Excel/page50#post12767

Pull it Plonker #3

Chris Fucked up a simple change because he was poxing about in GitHub Crap, ( or I am just a jerk for not understanding GitHub yet.. )

#3a Seems to work
Disclaimer: I might be talking crap here, because I don’t understand GitHub. On the other hand GitHub could be a complicated waste of time, worse than useless, and it can cause you to mess up a simple change like adding a couple of lines to a script and trying it out.
Simplified shortened story:
Someone called nikilson suggested way back in early December a change, basically comprising two code lines to stop the web search being suggested when you search in that small search bar bottom left, https://github.com/nikilson/win10scr...e09a7125868e92

So before using those code lines you might have this
https://i.postimg.cc/VNqwtH0M/bollox...web-search.jpg https://i.postimg.cc/rynk54sh/Bollox-to-Web-Search.jpg https://i.postimg.cc/2SvNpXwJ/Bollox-to-Web-Search.jpg

But if you run a couple of lines like this, either alone or in the full Debloat script, .._

Code:

Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\Search" -Name "BingSearchEnabled" -Type DWord -Value 0  
Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\Search" -Name "AllowSearchToUseLocation" -Type DWord -Value 0

_.. , and then the web search bollox is gone
https://i.postimg.cc/sxXCtj69/No-bollox.jpg https://i.postimg.cc/sDMRm2Z3/Gone-B...Web-Search.jpg
I have tested that on several computers on a few different Windows 10 versions, including the latest windows 10 version, 21H2. It seems to work, as does the corresponding undo code lines to put it back

Code:

 Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\Search" -Name "BingSearchEnabled" -Type DWord -Value 1   
 Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\Search" -Name "AllowSearchToUseLocation" -Type DWord -Value 1

Pullock #3b
In this live stream video, https://www.youtube.com/watch?v=ZEW5f7F94FY
9.23 Live - Updating all my GitHub Projects - The Power of FOSS 31 12 2021 https://drive.google.com/file/d/1A29...?usp=drive_web
, Chris had an attempt at testing the “Pull”:
At about minute 11, 37 seconds, https://youtu.be/ZEW5f7F94FY?t=697 , he started looking at it, at about minute 23 , https://youtu.be/ZEW5f7F94FY?t=1380 , he put it in some abstract branch twig test GitHub crap, and forgot about it and closed the “Pull request”
At about minute 57 , https://youtu.be/ZEW5f7F94FY?t=3430 , to fill up time while waiting for something, he tried to test the thing. He ran a Windows 10 virtual machine, and called up the script from the one command thing. As I understand it that runs the current ps1 script somehow across the internet. But Chris never changed that script, ( other than adding a simple single Debloat line HotspotShieldFreeVPN )
Instead, after adding that simple single Debloat line he …. Before we grab any more requests we will make another branch - ( minute 7 and 30 seconds https://youtu.be/ZEW5f7F94FY?t=450 )
I think the problem is when pissing about with virtual machines and catastrophic GitHub, you easily loose track of reality. It might look pretty on a video, but to get the job done quickly and efficiently it is very simple:
_ you can pick up older machines with the older software versions very cheaply. I think anyone working on developing things in windows 10 should have a few computers.
_ simply test the code lines directly in PowerShell or Windows PowerShell ISE or in a copy of the script.

The code lines do what they should. Chris was a Branch Test Pullock when he thought he tried them out, ( or I am the slow to get the point idiot, again..)

**DocAElstein** · 03-20-2018, 04:09 PM

Plonky Wonk 4 / 2b

Issues with the Service syntax differences PowerShell 5.1 to 7.1

http://www.eileenslounge.com/viewtop...292019#p292019
http://www.eileenslounge.com/viewtopic.php?f=18&t=37740

Set-Service "dmwappushservice"
We cant set it back to StartupType AutomaticDelayedStart in PowerShell 5.1. We need PowerShell 7.2. (PowerShell 7.0 and above is a separate install from the built-in PowerShell https://eileenslounge.com/posting.ph...&f=18&p=292019 )
Chris doesn’t seem to make any attempt to do anything with it in Undo Essential Tweaks)

**DocAElstein** · 03-20-2018, 04:09 PM

This is post https://excelfox.com/forum/showthrea...ge50#post12769
https://excelfox.com/forum/showthread.php/2408-Windows-10-and-Office-Excel/page50#post12769

Pulling my Plonkies 5+

Bollox, it would be easier to start again from scratch

I have come to a bit of a turning point. Mostly because just now I don’t yet have infinite time available.
- I got a lot more I want to do this winter.

Intro. Why am I writing my own script / developing
I would not have got this far, or no where near as quickly without Chris’s stuff. I remain very grateful to him.
But its got to the point that his chaotic organising and lack of him having time currently to do justice to the replies, and suggestions that he gets, coupled with the failings of GitHub and YouTube, ( In particular it being almost impossible to comment on YouTube without it being deleted since last July https://support.google.com/youtube/t...comments?hl=en
GitHub is deigned I think to mess up a project, by not only losing all control, but actively messing up all version control. GitHub is the Devil ) … All this means that at the end of the day, its going to be a lot quicker for me to start again from scratch myself.
His script is full of errors, redundant code and other failings and getting that info across to him has improved to be impossible.
But he is still a great guy, and I love him!

But I gotta move on….
I think this post I am writing in will turn into a table of contents for the next posts

GUI Redesign Post https://excelfox.com/forum/showthrea...ge50#post12770
I quite like the GUI idea. It’s convenient. But it’s aimed not to entertain but instead be practical. It is. Its square with simple square labelled button in it. It just need a few simple code lines, a few code lines are needed just once, some others are either in
_ a loop
Or
_ repeated.

Chris likes to use Posh GUI software to make and control developing/ adding to his GUI. I expect that is due to some reasons such as it looks nice in a YouTube video and other reasons I don’t know.
But its like swatting a fly with a nuclear missile. It makes a code I expect by recording what you do, just like the VBA macro recorder, you then get a lot of stuff repeated, which then a programmer would reduce into more efficient looping coding or make a function to do similar things in the same coding.
Personally I don’t mind the extended inefficient text, as text is cheap and it makes it easier later to do mods on a particular button later.
But I am going to do some looping to do the repeated stuff to get the buttons there,
mostly because
_ I want to reduce the code lines, so that I have room to add my new coding but keep some of Chris’s stuff approximately where it is, even if I then #comment it out, as I would like to still follow later what Chris is doing.
_ Its gonna help me “migrate” from modifying and rearing Chris’s script to having a completely new one of my own

**DocAElstein** · 03-20-2018, 04:09 PM

This is post https://excelfox.com/forum/showthrea...ge50#post12770
https://excelfox.com/forum/showthread.php/2408-Windows-10-and-Office-Excel/page50#post12770

Plop #495a)

A GUI, simple square with a few square buttons, based on a few simple code lines and a bit of looping

5a) Introduction.
The thing is like approximately like box with 4 columns of buttons. I might leave it in that form, or add a column or two and move things about a bit.

The outer window box GUI form thing that comes up:- It’s too dammed fucking big, Chris
I’ve told him dozens of times so has others. I think he is oblivious to the fact that for most people it blots out the screen making lower buttons unusable. Chris often waffles some crap about automatic re sizing, but I expect he just has some code generated by Posh GUI, which possibly has some redundancy in it, as well as other issues, which he does not understand.
So bollox to all that. It just takes a few simple code lies to make a simple square that will conveniently fit on most peoples screens. About half the size of what he usually has is ideal, but I will use about two thirds as then I can still see a lot of his buttons on it as I migrate from his coding to my new coding.

The buttons
For each button we have a variable of object type. Most of the properties are defined in one go to the variable, (assigned to the variable), but the Click is Added ( the coding that does something) somewhere else. There might be some reason for that, or it might once again just be how Posh GUI chucked it out.
All the buttons are very simple wide rectangular ones and could all be done in a loop. This has been suggested and written for Chris a few times, but he’s not interested as he like his posh GUI.
( jumbled in this section we also have 4 “panels” which for want of a better description seem to be a invisible button with nothing in it, - something like a range, or range object. These 4** are tall things a bit wider than most buttons and extend to the area a bit bigger than to accommodate one of the 4 columns of buttons
A bit further down we add things, that is to say the corresponding buttons, in these column ranges.
The actual Form itself seems to act like a range, or can be used as such, so we actual Add the variables to 5** ranges in total.
We do this Form Controls AddRange first and amongst other things, then add the 4 column Panels to that first. I suppose that makes some sort of hierarchical OOP relesense.

Generate some stuff with a function.
As I mentioned previously, I expect the GUI generated coding, as typical from such stuff, gives all things and does not have the sense to group similar things, or come up with something like a single function talking arguments, to do the similar stuff repeatedly. So a lot of stuff is repeated. I am actually untypical in preferring that usually, but I am going to tidy stuff up with a function to give me some spare lines to put my stuff in, whilst keeping some of Chris’s stuff , albeit mostly commented out, for later ease of navigating around his later modifications.

Etc. etc..