Messages

151

N.A.N.Y. 2020 / NANY 2020 Mug-shots

« on: February 11, 2020, 01:25 PM »

Again, it seems like I'm the first to kick-off a thread with NANY-2020 mug-shots.

Please add yours (or other rewards received) too



I got both the regular and the alternative design again, but in the smallest available size (11 oz.), so they're actually usable under European coffee machines

152

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« on: February 09, 2020, 01:03 PM »

I'm trying to help solve issues/questions, because that is what I like to do, but with your questions/issues the hardest part is not finding the solution, but to get you to write down only the facts that are involved in the issue, and the exact result you want to achieve. Often you are adding a lot of words that have nothing to do with the issue, making it nearly impossible to help.


I'll retry to get the facts clear, please give consise answers to these questions:

• What is the input? Currently I suspect there is an Excel file with several sheets
  • Do all sheets have the same columns/data?
  • Can you provide a sample file?
• What is the output you need?
  • All sheets combined into a single sheet in a new file?
  • All sheets combined into a new sheet in the current file?
  • All sheets combined into the first sheet in the current file?
    • All sheets should remain in the file?
    • All sheets from sheet 2 should be deleted?

153

Coding Snacks / Re: copy paste utility for excel

« on: February 09, 2020, 12:10 PM »

This thread should be closed by a moderator, the exact same question by the same OP is already in another thread.

154

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« on: February 09, 2020, 12:05 PM »

@Contro:
Ok, I'll ask the 'big' question once, and please don't repeat the confusing flurry mesh of info you gave above: What goes into this black box, and what is the expected output? (IOW, what is it to be used for)

-Ath (February 09, 2020, 03:25 AM)

you are totally right Ath.
That's the point.
I have tried to explain to Shades. Perhaps you may accomplish there.
 

-Contro (February 09, 2020, 11:37 AM)

Well, all that you have done is what I explicitly asked not to do: You've added a mishmash of unrelated and useless words that say absolutely nothing about the issue you are trying to resolve. And on top of that you even used 3 posts to do that...
To add insult to injury, you talk about using ahk to do something for you because Excel is 'too big' for you (to handle?).
What kind of help are you expecting?

155

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« on: February 09, 2020, 03:25 AM »

@Contro:
Ok, I'll ask the 'big' question once, and please don't repeat the confusing flurry mesh of info you gave above: What goes into this black box, and what is the expected output? (IOW, what is it to be used for)

156

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« on: February 08, 2020, 11:30 AM »

1 google search gave me enough information to find this makeuseof page (select Not Now in the red page-blocker when using a decent browser with an ad-blocker), providing not 1, but 3 step-by-step procedures to accomplish what you ask. With the standard product, so no utilities needed, only a rather simple skill: google

As you forgot to mention what Excel version you are using, I assume you have a decently modern version that has a ribbon (Excel 2007 or newer).

157

General Software Discussion / Re: Webbrowser for a special ocassion (virtualbox - guest xp pro)

« on: February 06, 2020, 01:11 PM »

Some well meant advice:
You really, really, really!, shouldn't be using IE for actively browsing the interwebz. And if it has to be IE (usually because someone 'forgot' to phase-out ActiveX), then don't use anything older than IE 11.
On top of that: You really, really, really!, shouldn't be using Windows XP for actively browsing the interwebz. You'd better install some Linux distro in a VM to browse the interwebz.

158

Screenshot Captor / Re: Hello i had a small bug with screenshot capture thought i mention it.

« on: February 06, 2020, 01:02 PM »

OT: Please don't shout here, we're quiet people, most of the time.


Check for another application that takes hold of the PrtScr key, most notorious is MS OneDrive that often has this enabled by default. Stopping/starting Screenshot Captor just brings it to the top of the chain, so it will work for the rest of the (Windows) session.

159

DC Member Programs and Projects / Re: Building code on Linux with non-recursive Make

« on: February 03, 2020, 01:08 AM »

 

It's been a while (~25+ years) since I used make for my Clipper (a dBase 3 compiler with many additional features) builds, so it's nice to see such a set of useful stuff. Thnx.

160

General Software Discussion / Re: Alternatives 7stacks for w10home

« on: January 29, 2020, 12:56 PM »

I'll attach the download here so you can try it, it's rather old (2009, that's not a typo), but it's the latest available. Please run some AV across it before actually trying it, just to be sure.

161

Living Room / Re: Connector SAS

« on: January 29, 2020, 01:04 AM »

Though SAS and SATA connections are quite alike, they aren't interchangeable. SAS drives are mostly used in servers and are usually much too expensive to be used in desktop systems.

OTOH, if you already own a SAS drive you can buy a PCI interface for your desktop system to connect that drive. Speed is usually similar to SATA, when used in a desktop system.

162

General Software Discussion / Re: Alternatives 7stacks for w10home

« on: January 27, 2020, 01:23 AM »

What about the standard Win10 toolbars?
Right-click on the taskbar, open Toolbars and select Desktop (like I did), or add a new toolbar, pointing to a folder where you create links to your files/applications as desired. Multiple toolbars can be defined.



Example of my (partial) Desktop toolbar:



The advantage of TrueLaunchBar (shareware) is that the menu pops out on mouse-hover, where the Windows toolbars need a mouse-click to open.

163

General Software Discussion / Re: Alternatives 7stacks for w10home

« on: January 25, 2020, 02:00 PM »

Well, it's not exactly the same, but you could have a look at 7+ Taskbar Tweaker

7 Stacks was last updated in 2011, so I have my doubts it will ever be updated again...

164

LaunchBar Commander / Re: Another configuration screen issue

« on: January 25, 2020, 04:41 AM »

You should be able to drag the right side of the setting panel to the left with the mouse:



(The drag handle moved a bit to the right when taking the screenshot...)
Just move the mouse over the separating line in the middle until it changes into a left-right drag handle, then click and drag to the left, (that might take some precision-mousing on your high-res monitor though )

165

General Software Discussion / Re: Flashing black windows in pspad when maximize

« on: January 23, 2020, 12:53 PM »

You can try several things:

• Turn off check for update option in settings
• Update your graphical drivers
• Consider using a different editor

166

General Software Discussion / Re: See the text bigger only inside one program in w10 home

« on: January 20, 2020, 01:46 PM »

Have you tried playing with the Compatibility/High DPI settings per application? It's in the <Right-Click-icon>/Properties pages of the application.

And some applications support Ctrl-scroll-wheel-scrolling for scaling only their window/font.

167

Developer's Corner / Re: Any coders here on patreon?

« on: January 20, 2020, 01:42 PM »

If you're a programmer who hangs out here and you have a patreon account

-mouser (January 20, 2020, 12:19 AM)

It could be nice to have a Patreon icon that could be configured in the profile to point to the Patreon page, and displayed on the left with the other account icons...

168

Developer's Corner / Re: Brainstorm for a cross-platform programming language

« on: January 20, 2020, 01:39 PM »

I do like the basic (pun intended) idea you are proposing, but for platform-independence I always choose Java. The required runtime is available for a gazillion different OS's. And Java is very well known programming language across the industry, so anyone else after me can pick up maintenance/extension at will, without having to learn this new, esoteric, programming language, install required tools, runtimes, etc...

169

Clipboard Help+Spell / Re: Possible suggestion -- variables in clips

« on: January 13, 2020, 02:07 PM »

You could use a custom date ('R - Time/Date TextClips' from the Quick menu of CHS, the extra format can be set on the 'Quick Paste Pop-up Menu' page in the settings), adding one in your desired format, lastpost%y%m%d would be the closest to your proposal I can think of, or replace %y with %Y for a 4 digit year.

170

General Software Discussion / Re: Thin-print - nice simple free iPad to PC printer utility

« on: January 11, 2020, 04:30 AM »

I prefer the free, manufacturer supplied, Brother iPrint & Scan solution, available for my Brother Multifunction machine (not a very sophisticated model, but it works good enough for the minimal use here), providing access to both the print and scan features of that Multifunction. It is only usable from the local network though, but that's all I need (or want, for that matter).
Works equally well across Windows, Android and iOS.

171

N.A.N.Y. 2020 / Re: NANY 2020 - KeepWatch system monitor

« on: January 07, 2020, 01:36 AM »

The program (gui) looks familiar to me...

Let me guess... its written in ahk?

-jNizM (January 07, 2020, 01:19 AM)

Source Language:

Compiled AutoHotkey script

-mat2016 (December 26, 2019, 08:10 PM)

Well, it sure looks like it...

172

Living Room / Re: When you make your 100'th Post

« on: January 05, 2020, 11:49 AM »

173

Living Room / Re: When you make your 100'th Post

« on: January 05, 2020, 05:36 AM »

And a real 'score' of 400 for BGM:

174

Living Room / Re: When you make your 100'th Post

« on: January 05, 2020, 05:31 AM »

In the 'nice numbers' category (and because I just missed the palindrome count 552255, yesterday )

For those that missed it...

55 + 22 = 77

175

N.A.N.Y. 2020 / Re: NANY 2020: ISMONISM - search Start Menu (or any folder) for 'missing' entries

« on: January 05, 2020, 05:23 AM »

• On the settings pages, one button has the caption 'Edit focused' and another 'Remove selected'. IMHO, 'focused' should be replaced by 'selected', as focused is a seldom used term in this context.

-Ath (January 03, 2020, 05:18 AM)

Hmm, not 'fixed'. You can select more than one row in the ListView and then remove them in one go. With edit you can only do that for one row at a time (the last clicked row, which has the focus...). IMHO there need to be a distinction. Suggestions are welcome for other wording.

-Winkie (January 03, 2020, 08:49 PM)

Well, 'Edit' actually works on the last selected item only, thus can be confusing to users (as the focused item isn't recognizable from other selected items). So an alternative solution could be to only enable that button when exactly 1 item is selected, less confusion, and 'selected' is correct.
Another solution could be to edit the selected items in succession (but I doubt if that would really be useful/helpful or less confusing).

the name of this app is it's hard to remember and pronounce

-mouser (January 04, 2020, 10:41 PM)

Well, SIMON then? (Shortcut In Menu Or Not)