Recent Posts

201

General Software Discussion / Re: Multiple Find and replace in a word file

« Last post by 4wd on January 27, 2021, 05:33 PM »

Code: Visual Basic [Select]

1. Sub FindAndReplaceMultiItems()
2.   Dim strFindText As String
3.   Dim strReplaceText As String
4.   Dim nSplitItem As Long
5.    
6.   Application.ScreenUpdating = False
7.  
8.   ' Enter items to be replaces and new ones.
9.  strFindText = InputBox("Enter items to be found here,seperated by | (vertical bar): ", "Items to be found")
10.   strReplaceText = InputBox("Enter new items here, seperated by | (vertical bar): ", "New items")
11.   nSplitItem = UBound(Split(strFindText, "|"))
12.  
13.   ' Find each item and replace it with new one respectively.
14.  For nSplitItem = 0 To nSplitItem
15.     With Selection
16.       .HomeKey Unit:=wdStory
17.       With Selection.Find
18.         .ClearFormatting
19.         .Replacement.ClearFormatting
20.         .Text = Split(strFindText, "|")(nSplitItem)
21.         .Replacement.Text = Split(strReplaceText, "|")(nSplitItem)
22.         .Format = False
23.         .MatchWholeWord = False
24.       End With
25.     Selection.Find.Execute Replace:=wdReplaceAll
26.   End With
27. Next nSplitItem
28.  
29.   Application.ScreenUpdating = True
30.  
31. End Sub

Try that, it uses | instead. (Not tested since I'm on a tablet.)

202

General Software Discussion / Re: Batch Word Text Replacer

« Last post by 4wd on January 26, 2021, 06:49 PM »

I am doing something wrong.
No replaces at all.

-Contro (January 26, 2021, 10:03 AM)

That's because it looks for *.docx files by default, you need to change it to *.doc.
Changing it to *.doc? would probably do both types but I haven't tested it.

Code: Text [Select]

1. strFile = Dir(strFolder & "\" & "*.doc", vbNormal)

or

Code: Text [Select]

1. strFile = Dir(strFolder & "\" & "*.doc?", vbNormal)

203

General Software Discussion / Re: Batch Word Text Replacer

« Last post by 4wd on January 25, 2021, 07:28 PM »

Ojú !!!!!!!!!! Then you don't have used datanumen .
I would prefer an advice if you are using this tool or know at first hand someone doing.

-Contro (January 24, 2021, 07:17 PM)

No problem ... however that VBA module is from 2017 and I've just tested it on Word 2003 and it worked ...

204

General Software Discussion / Re: Batch Word Text Replacer

« Last post by 4wd on January 25, 2021, 02:25 AM »

You can give this a try:
https://www.datanume...iple-word-documents/

-4wd (January 24, 2021, 06:21 PM)

I am trying long time ago with this sort of program.
So : Have you try that script or the program ? Do you use this program ?

-Contro (January 24, 2021, 07:17 PM)

I don't have/use Word or VBA, if I did I'd probably use PowerShell interfacing to Word to do the same thing instead.

205

LaunchBar Commander / Re: Add Windows 10 programs (ex: Krita)

« Last post by 4wd on January 25, 2021, 01:28 AM »

This method works for adding UWP apps: How to open UWP apps from the command line

206

General Software Discussion / Re: Batch Word Text Replacer

« Last post by 4wd on January 24, 2021, 06:21 PM »

You can give this a try:
https://www.datanume...iple-word-documents/

207

General Software Discussion / Re: Speedtest of my Internet browsers :-(

« Last post by 4wd on January 23, 2021, 08:04 PM »

I expect the problem is inside my computer, not in the network; We are 400 apartments, theoretically with the same wiring, but I am the only one complaining...

-Curt (January 23, 2021, 03:01 AM)

To start with I'd boot into Safe Mode with Networking, fire up Edge (or any browser with zero add-ons), and then do your speed test, (personally I'd use an ftp transfer but this is easier), so there'll be no extra background programs running.

If I'm following this right, (which is not normally the case as I get older ), you get 400Mbps on the computer, 800+Mbps on your phone (via WiFi) through the same router, modem, and ISP.

Your problem is more than likely your computer:

• You're running too much crap doing background networking.
• You're running crap extensions in your browsers.
• The network settings are seriously screwed up.
• etc, etc.

For the first, boot your computer, start Task Manager, switch to Performance tab, and select your network connection on the left - you should have close to zero data transfer, (or sub-100Kbps), if it's just idling along, (no updates or anything).
If it's high then it's time to start trying to find what's sucking data.

For the second, download the PortableApps version of Firefox and try that or start Firefox in Safe mode.

For the third ... you could try running the Network Troubleshooter, All Settings->Network & Internet->Network Troubleshooter.  If that appears to not help then it's time to get into the crap you normally don't want to

PS. It's Mbps not MBps, 1000 Mbps = 125 MBps 

208

Found Deals and Discounts / Netflix/Youtube Premium

« Last post by 4wd on January 18, 2021, 04:34 AM »

OK, not really a deal as it were but more a method to save money, (this doesn't break any law in Australia but who knows what kind of messed up copyright is in your country).

Here's a Google spreadsheet with Netflix prices: Netflix Prices

The spreadsheet hasn't been updated since the last price hike, Netflix plans are now: AU$10.99, AU$15.99, & AU$19.99 for Basic, Standard, & Premium

But I currently get Premium for ~AU$7.30, (US$5.60), by signing up and paying on the Turkish site, a 63% saving.  (Argentina is currently the cheapest, Turkey was when I signed up.)

All you need is a free VPN with a exit node in Turkey ... and in case you're wondering all your content won't suddenly become Turkish in nature. The content is based on the location you log in from, I might pay in Turkish Lira but the content is all that's applicable to Australia.

Some info for signing up: Netflix via Turkey  (Just use the Netflix sign up information, not any services the site is selling)

The same thing can be done for Youtube Premium, here it's AU$14.99 Individual or AU$22.99 Family.

Paying in Argentine Pesos: ~AU$1.80 Individual or ~AU$2.75 Family.

Sign up via a VPN with an Argentine exit node, if it asks for an Argentine address see here.

FWIW, I've been paying in TKL for Netflix for over a year and only just signed up for Youtube Premium - I probably wouldn't have bothered with either of them if it was necessary to pay full price.

The above is via OzBargain: Netflix; Youtube Premium

209

Non-Windows Software / Re: Possible to dual boot via boot priority swapping?

« Last post by 4wd on January 15, 2021, 04:08 PM »

Not sure what previous method you're referring to, (Grub?), so I'll mention one I've used previously, EasyBCD (community edition).

It lets you add/remove entries to the normal Windows bootloader and then you can select which to boot into at startup.
I've used it to boot WIMs, ISOs, and VHDs but it can also do Linux, BSD, and MacOS.

Since it's using the normal Windows start mechanism, (BCD), and not having to install Grub, to remove Linux you'd just remove the entry from the BCD and remove the drive.

It's just an interface to the bcdedit command within Windows.

You could try it by installing Linux on a flash drive and using EasyBCD to set up an entry to boot into it before going the install to an M.2 option.

Otherwise, what you suggest would also work.

210

General Software Discussion / Re: Windows 10 Announced

« Last post by 4wd on January 07, 2021, 08:16 PM »

Also, what's that Windows dimmer function that works like f.lux,

-ich thys (January 06, 2021, 08:16 PM)

Night Light - Open the Notification area, right-click in the tile area and select Edit, then Add it.

211

Living Room / Re: Does the right software and hardware exist to use two wifi connections simultan?

« Last post by 4wd on January 06, 2021, 08:29 PM »

Link Agreggation^w or Channel Bonding

Speedify

Can you please elaborate on that? I'm trying to understand what you want to achieve.

-Ath (January 06, 2021, 12:23 PM)

To download all the pr0n you need maximum bandwidth

 

212

N.A.N.Y. 2021 / Re: NANY 2021 Entry: Free Movies (website)

« Last post by 4wd on January 04, 2021, 06:09 PM »

Would it be possible to implement alphabetically sorting?

-4wd (January 01, 2021, 02:17 AM)

Is this acceptable? https://scarytaskbar...om/movies/full-list/

-app103 (January 04, 2021, 02:23 PM)

Yes, thank you - it lets me browse through and immediately see if there is a sequel.

Plus I know you said that originals might not be available in the coming months but at least it saves me from unnecessarily searching online if I can immediately see the original is there along with the sequel.

213

N.A.N.Y. 2021 / Re: NANY 2021 Entry: Free Movies (website)

« Last post by 4wd on January 01, 2021, 07:28 PM »

Would it be possible to implement alphabetically sorting?

-4wd (January 01, 2021, 02:17 AM)

Not entirely sure if that will be possible, or desirable.

Current default sort is chronological, based on when the movie was added to the site, so most recent will be shown first.

-app103 (January 01, 2021, 03:14 PM)

No problem, I was just wondering since you have movies that are original + sequel/s and it's always a lot easier to pick them out and watch in order when they're sorted alphabetically.

214

N.A.N.Y. 2021 / Re: NANY 2021 Entry: Free Movies (website)

« Last post by 4wd on January 01, 2021, 02:17 AM »

First off, great idea I've had several free movie/TV apps on the tablet, nice to have things available in one spot.

Would it be possible to implement alphabetically sorting?

Public Domain Movies is somewhat similar.

215

General Software Discussion / Re: some useful but less-known software. share your list!!!

« Last post by 4wd on December 31, 2020, 08:05 PM »

Restic

Restic is a modern backup program that can back up your files:

• from Linux, BSD, Mac and Windows
• to many different storage types, including self-hosted and online services
• easily, being a single executable that you can run without a server or complex setup
• effectively, only transferring the parts that actually changed in the files you back up
• securely, by careful use of cryptography in every part of the process
• verifiably, enabling you to make sure that your files can be restored when needed
• freely - restic is entirely free to use and completely open source

And not strictly software: ffmprovisr

A ffmpeg resource for help with various operations.

216

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 31, 2020, 07:49 PM »

Just one more point regarding the screen share aspects of AnyDesk, NoMachine, etc - they all presuppose that you have a hardware monitor connected in the first place.

As such I think the MiraCast, OpenWFD, WiFi Display route is probably more geared towards this, seeing as it was billed as being "Wireless HDMI".

A couple of my old Android phones had MiraCast and WiFi Display in their settings but haven't seen them in any later phones.
Pretty sure that they would have been for sourcing rather than sinking, (which is what you want).

There are some MiraCast receiver/sink apps on the Play Store.

... and now back to our regularly scheduled program

PS. MiraCast is an optional feature in Windows 10 2004+ so it might give you something to play with.

217

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 31, 2020, 06:21 AM »

Actually, I think we've all kind of missed the point, me included 

AnyDesk, NoMachine, VNC, etc are for controlling the computer remotely. Client controls host.

-4wd (December 30, 2020, 03:53 PM)

I thought the point was that even though something like AnyDesk is intended for remote usage, it can still be used for "screen sharing" and allow someone to remotely see what the local user is doing.

-Deozaan (December 31, 2020, 02:07 AM)

There you go, I've officially used up whatever brain cells were allocated for this year ... I'm dumb 

And I just discovered NoMachine can do the same with a little fiddling ... I think I'll shutup until my brain cells are replenished next year.

218

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 30, 2020, 08:02 PM »

So the equivalent of casting the display from the Pi

-4wd (December 30, 2020, 03:53 PM)

This is exactly what I want.  I have a PI that has a keyboard and mouse attached, but no display other than a really small one.

-wraith808 (December 30, 2020, 05:26 PM)

I think you need to look for something that implements the WiFi Display protocol (MiraCast), for example MiracleCast.

219

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 30, 2020, 03:53 PM »

Actually, I think we've all kind of missed the point, me included 

Which is what Wraith is getting at I'm guessing.

AnyDesk, NoMachine, VNC, etc are for controlling the computer remotely. Client controls host.

Don't you really want something that mirrors what you're doing on the Pi to another device, ie. phone/tablet ?
Client mirrors host.

So the equivalent of casting the display from the Pi, eg. LetsView (not avail. for Linux).

220

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 30, 2020, 12:46 AM »

but be warned, they ignore the unsubscribe button on emails :-/

-tomos (December 23, 2020, 12:33 PM)

I've discovered the same issue with Banggood.

-Deozaan (December 23, 2020, 08:04 PM)

Try using the unsubscribe link in a browser on Linux, (eg. Firefox), or your phone, I got a completely different web page layout and the unsubscribe action completed unlike with Opera or Edge in Windows where it just sat there animating the spinner.

... and I haven't received an email from them in a week as opposed to one/two per day.

Connecting to/from my 64-bit Linux laptop with my ARM Android phone using AnyDesk was no issue at all. Think it is a pretty safe bet that you can expect the Linux version you'll use on your Raspberry Pi device will not give you problems when connecting with Android devices using AnyDesk.

-Shades (December 25, 2020, 08:15 AM)

An AnyDesk response to a customer:

I have Anydesk response on this, dated August 4th 2020

"Currently, we only support Raspbian (32-bit) on Raspberry Pi 3 and newer:
https://support.anydesk.com/Installation

However, we are aware that such an AnyDesk version is requested, but we cannot give you any further information about this yet, unfortunately."

NoMachine just plain old worked for me, it's working better than VNC which I've used for years.

221

N.A.N.Y. 2021 / Re: NANY 2021 Entry: The Lightning Bolt Quiz

« Last post by 4wd on December 27, 2020, 02:31 AM »

A bunch of other people, who are or probably have been annoyed by the evangelist in the past, jumped in the thread bragging about how "evil" they are, effectively trolling the evangelist into doing what he does: evangelize.

-Deozaan (December 26, 2020, 04:11 PM)

I'd just like to point out that I'll excuse myself from this bunch because:

• I have no idea who the OP is and/or whether or not they are Pro-religious because it is quite literally the first time I've looked at a thread by them, (AFAICR), and only because it had "lightning bolt" in the subject, (being a lover of thunderstorms).
• I am completely indifferent to all things religious ... actually I just don't care.
• Given the cartoonish nature of the initial graphic I took it as a bit of fun and responded in kind.

222

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 25, 2020, 05:27 AM »

DOUBLE EDIT: It seems there's no ARM64 build of AnyDesk available. So while they claim to support the Raspberry Pi 4, I guess that means you have to be using a 32-bit OS for it to work.

-Deozaan (December 24, 2020, 05:10 PM)

Try NoMachine instead, it's available for a lot more architectures including ARMv6-v8.

Works quite well from Win10|Android->RasPi 4B (DietPi ARMv7 - don't have a RasPi with 64bit installed atm).

223

N.A.N.Y. 2021 / Re: NANY 2021 Entry: The Lightning Bolt Quiz

« Last post by 4wd on December 23, 2020, 09:55 PM »

I had the same thought process LOL

-wraith808 (December 23, 2020, 05:16 PM)

I think it's random, I just hit max everything this time and got: 28,016,972

224

Living Room / Re: Gadget WEEKENDS

« Last post by 4wd on December 23, 2020, 04:51 PM »

Here a review of its more powerful brother, the iPlay 30 ...

-tomos (December 23, 2020, 12:33 PM)

Take it for what you will but ... it uses an MTK SoC, of the 3 phones I've had with one they all developed a problem within warranty. One phone started running the battery down like crazy, (even after factory resets), two other phones just died, one near end of warranty, the other within 3 months of purchase.

I think the Alldocube X Neo would be better but then it costs more, Qualcomm Snapdragon 660.

So far the iPlay20 has been rock solid, if I had one criticism it would be that both speakers are on the bottom. Would have been better if one was on the top for when you watch video in landscape position. But then I almost always use BT earphones so it's not really a problem for me.

... but be warned, they ignore the unsubscribe button on emails :-/

And that's why you use throw away email addresses ... plus you generally get new user coupons/discounts each time you create a new account
Try logging into the account and remove all email prefs.

225

General Software Discussion / Re: What Android Apps Do You Use?

« Last post by 4wd on December 23, 2020, 04:28 PM »

RemoDroid, Inkwire, and Screen Share

I've tried them but RemoDroid requires root for touch to work.
Inkwire and Screen Share needs permission to draw over the screen but even then I couldn't get them to do anything, I was trying to control my tablet from the phone, (or vice versa), both are Android 10.

Who knows, you may have more luck.