Messages

101

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

« on: February 09, 2020, 07:13 PM »

FWIW the solution to your 'problem' is the program itself.  No value in using external apps like AHK, or probably even an addin, cos its something thats easily done in excel using VBA (ie a macro).

That said, unless you can give us a sample file (or at least some reasonable details) its probably going to be difficult for someone to put something together for you (and I don't currently have access to excel or I'd knock something up)

Of course any solutions offered now will be moot because you've already resolved the issue anyway

102

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

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

if all the sheets are in the same format (all columns match and all formulas are the same) then you're only copying the data (the calculations can be done in the target sheet)

The simplest way to do this for a one time job is to copy + paste - it would have been done in less time than you've spent on this thread

if you need to do this often (ugh...), then its not as simple as just finding an addin.  Every situation is different and you have to make sure the data is clean before you even start (else you just end up with garbage)

103

General Software Discussion / Re: VirusTotal marking each and every AutoHotKey exe as Virus !!

« on: January 19, 2020, 11:52 PM »

and its not like this is news, it's been like this for years.  Clearly there's something that needs to change, but we're not seeing any activity from either side of the fence here...

104

General Software Discussion / Re: Best app to learn SQL on

« on: November 05, 2019, 12:06 AM »

The current version of SQL server isn't compatible with my OS (W7) so I guess thats out...

I understood that the various implementations all had distinct dialects so I guess I was looking for something reasonably generic to get me started

105

General Software Discussion / Best app to learn SQL on

« on: November 04, 2019, 06:01 PM »

Any recommendations? 

I'm wanting to teach myself some SQL and want to know a good place to start.  I have a couple of books, but I'm a bit confused about which software package to work with (I tried MySQL and it installed a million things that I didn't know what to do with)

106

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« on: October 08, 2019, 02:47 AM »

Then let me counter with this video. You have to get through the first 2 minutes or so with a narrator who is not too fluent in English and spouts what he does with a heavy accent. But after those two minutes or so, the engines on the bikes start doing their "thing"...

Honda CBX 1050:

-Shades (October 08, 2019, 12:12 AM)

shouldn't this be in the music thread?

107

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« on: October 07, 2019, 05:42 PM »

How motorcyclists think people react when they drive by...

108

General Software Discussion / maybe of interest - another security flaw

« on: September 29, 2019, 05:32 PM »

besides being pointless fluff, it seems all this RGB blinky stuff can also be a potential security threat 

leds-light-the-way-to-this-backdoor

109

General Software Discussion / Re: Music player that can play 60 second previews

« on: September 01, 2019, 11:57 PM »

Some feedback in case its useful to others......

I couldn't get mplayer to work with that string, nor could I decipher the command line options (there appear to be hundreds, most relating to video...)

The AHK script worked, but audio disappeared after 2 folders, and only a reboot resolved it (until the next 2 folders...).  I could open/play the files manually regardless

Final solution - I eventually found that 1by1 had a configurable 'intro scan' function that does exactly what I wanted.  I knew it was there, but last time I used I don't think the play time was configurable 

EDIT:  Maybe worth noting that the 'preview' function in 1by1 only works on a folder by folder basis.  Not quite as convenient, but it's working for me...

110

General Software Discussion / Re: Music player that can play 60 second previews

« on: August 24, 2019, 03:23 AM »

don't mind the cli, but damn if the help file for mplayer isn't exactly helpful here.  I assume that there's no option for a recursive search with this option...

that AHK script is a winner (dunno why i didn't think of that).  Only thing I would like to see is some sort of delay between the tracks, ie the instant transition from track to track is somewhat jarring, though it does keep me focused (I added a 2 second mute at the end of the loop. does the trick) 

111

General Software Discussion / Music player that can play 60 second previews

« on: August 22, 2019, 11:04 PM »

Looking for an app that I can use to review >800 tracks. 

Background is that the files were all on a USB stick in my wifes car, and some were displaying odd artifacts at the beginning of the track when played on the car stereo. 

Rather than scrapping the whole lot I'm wanting to review them to see if any are actually corrupted or whether the problem may lay with the player (its in a 4 year old subaru)

60 seconds should be more than enough to id any offenders, and I can listen to them while I do other things.  Having to do it manwelly is tedious, and gets in the way of work

Idea's or suggestions appreciated! 

112

General Software Discussion / Re: Best reliable freeware download sites?

« on: August 17, 2019, 02:06 AM »

another one that might be worth consideration, though probably not strictly a freeware site

Alternative To offers alternative solutions to a lot of mainstream apps

113

Living Room / Re: Recommend some music videos to me!

« on: August 05, 2019, 08:28 PM »

not much  of a video, but this guys worth a listen

here's a link to him doing enter sandman in the style of David Bowie

or see his other stuff on his youtube channel

114

General Software Discussion / Re: Best reliable freeware download sites?

« on: July 25, 2019, 05:23 PM »

portablefreeware.com - its my goto when I'm looking for something I can't get here. 

I monitor a handful of sites but if something catches my attention I always try and find the devs page rather than download from wherever I found it mentioned

115

General Software Discussion / Re: I need a script that will left mouse click at a specific time of day.

« on: June 26, 2019, 04:10 PM »

just to confirm, you only need to define a time?

quick and dirty AHK code...

[Select]

#persistent
MyHour = 07
myMin = 07

loop
{
  if A_hour = %myhour%
    loop
    {
if a_min = %myMin%
          click

sleep 750
    }
  sleep 750
}

116

DC Gamer Club / FarCry New Dawn

« on: June 06, 2019, 03:10 AM »

any players here?  curious to know if its worth spending any money on

I loved 3 & 4, and I've just finished 5, but it has to be one of the buggiest games I've ever seen...
 

117

Screenshot Captor / Re: Draw a rectangle on W10

« on: April 02, 2019, 12:17 AM »

try changing the blend mode

-mouser (April 02, 2019, 12:03 AM)

thanks mouser! 

For some reason it was set to multiply.  No idea why it was like that, but as an occasional user (and a non graphics person) I don't know what most of these settings do

118

Screenshot Captor / Draw a rectangle on W10

« on: April 02, 2019, 12:02 AM »

It's likely me cos I'm not a regular user, but I'm not able to change the colour of a rectangle, specifically the border

I'm trying to highlight a bunch of fields on a screenshot and can only get a black rectangle (not yellow like I specified).

Any suggestions?

119

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: March 21, 2019, 12:51 AM »

Good lord this Cranioscopicallity is spreading like a virus.

-mouser (March 19, 2019, 08:57 AM)

Do I sense some internal resistance?

-cranioscopical (March 20, 2019, 06:01 AM)

That was a circuitous path to that current pun.

-wraith808 (March 20, 2019, 02:20 PM)

Circuitous?  More like a straight conduit to the pun...

-skwire (March 20, 2019, 02:45 PM)

Just DODdering along, more like...

-cranioscopical (March 20, 2019, 07:18 PM)

This thread keeps soldering on....

-Shades (March 20, 2019, 08:41 PM)

we're determined to wiring as much out of it as possible

no doubt at some point we'll loop back to the beginning again

120

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: March 19, 2019, 05:25 PM »

he was on a charge...

-Target (March 16, 2019, 02:56 AM)

As long as he didn't charge into somebody, which might be considered battery, there should be no need to get the coppers involved.

-skwire (March 19, 2019, 08:33 AM)

we'd all end up in cells

121

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: March 16, 2019, 02:56 AM »

Wow!  Congrats!  That didn't take long at all!

-wraith808 (March 16, 2019, 01:31 AM)

he was on a charge...

122

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: March 13, 2019, 10:38 PM »

i interrupt this PUN war to report in from the field: I have somehow finished all electric wiring and plumbing, and everything works (!)

-mouser (March 11, 2019, 11:29 PM)

It all works?!  To celebrate, I volt for a Faraday for an entire week!

-skwire (March 12, 2019, 06:59 AM)

We'll just call you the generator of a new war...

-wraith808 (March 12, 2019, 09:11 AM)

Leave it to Jody Ohms to be the transformer of the conversation..

-skwire (March 12, 2019, 10:51 PM)

can someone remind me, wire are we doing this?

-Target (March 13, 2019, 05:27 PM)

Because no one will be the terminator of the arc.

-wraith808 (March 13, 2019, 05:54 PM)

Yep, we just keep plugging along.

-skwire (March 13, 2019, 06:04 PM)

I suppose for some its an outlet, but for the rest its just circuitous...

-Target (March 13, 2019, 09:06 PM)

As long as the posts are positive, and not negative, I'm happy to continue.

-skwire (March 13, 2019, 09:28 PM)

IC...

123

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: March 13, 2019, 09:06 PM »

i interrupt this PUN war to report in from the field: I have somehow finished all electric wiring and plumbing, and everything works (!)

-mouser (March 11, 2019, 11:29 PM)

It all works?!  To celebrate, I volt for a Faraday for an entire week!

-skwire (March 12, 2019, 06:59 AM)

We'll just call you the generator of a new war...

-wraith808 (March 12, 2019, 09:11 AM)

Leave it to Jody Ohms to be the transformer of the conversation..

-skwire (March 12, 2019, 10:51 PM)

can someone remind me, wire are we doing this?

-Target (March 13, 2019, 05:27 PM)

Because no one will be the terminator of the arc.

-wraith808 (March 13, 2019, 05:54 PM)

Yep, we just keep plugging along.

-skwire (March 13, 2019, 06:04 PM)

I suppose for some its an outlet, but for the rest its just circuitous...

124

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« on: March 13, 2019, 05:27 PM »

i interrupt this PUN war to report in from the field: I have somehow finished all electric wiring and plumbing, and everything works (!)

-mouser (March 11, 2019, 11:29 PM)

It all works?!  To celebrate, I volt for a Faraday for an entire week!

-skwire (March 12, 2019, 06:59 AM)

We'll just call you the generator of a new war...

-wraith808 (March 12, 2019, 09:11 AM)

Leave it to Jody Ohms to be the transformer of the conversation..

-skwire (March 12, 2019, 10:51 PM)

can someone remind me, wire are we doing this?

125

Living Room / Re: Best Programming Jokes

« on: March 12, 2019, 05:40 PM »

You either die a feature or live long enough to see yourself become a bug.

-wraith808 (March 12, 2019, 03:44 PM)

either one is irrelevant if its not documented