Recent Posts

1

Developer's Corner / Re: Site to store code snippets ?

« Last post by moonwatcher on April 21, 2011, 10:45 AM »

SnippShot, a "minimalistic snippet collecting tool":

http://snippshot.skyscarf.com

A tutorial can be found on youtube:

http://www.youtube.c.../watch?v=pKwTTOxwNb0

Probably not for everyone, because it is VERY minimalistic. Nevertheless, I like it.

2

General Software Discussion / Re: Excel - pattern matching in cells

« Last post by moonwatcher on March 17, 2011, 02:04 AM »

If you don't mind using UDFs (User Defined Excel Functions), regular expression matching is also possible:

Public Function RegExMatch(ByVal vsStringIn As String, ByVal vsPattern As String) As Boolean
    Dim objRegEx As Object
    Set objRegEx = CreateObject("VBscript.regexp")

    objRegEx.Global = True
    objRegEx.MultiLine = True
    objRegEx.pattern = vsPattern
    
    RegExMatch = objRegEx.Test(vsStringIn)
    
    Set objRegEx = Nothing
End Function

The worksheet formula would then look like this:

=RegExMatch(A1, "[A-Z]{3}\d{3}")

More about UDFs: How to Create Custom User Defined Excel Functions,  Excel Custom Functions using VBA

3

General Software Discussion / Re: What is now the best dialog box enhancer/extender?

« Last post by moonwatcher on February 21, 2011, 12:44 AM »

I really liked FlashFolder and - like many other users - was very disappointed to see the development of that great tool coming to a halt.

And totally against my expectations, there are some promising news from FF's developer:

I think I have to finally finish this Win7 stuff so I can step on with other projects without having sth. in my back that bothers me ;-). Win7 / x64 code is technically already done and working quite good on my and a friends machine. I'm currently working on some minor quality issues and final touches. I plan to finish all this before spring (it's very little time, considering the time you already had to wait ;-p ).

(http://bit.ly/hHRCLE, 2011-01-24)

4

Living Room / Re: rare news mail from ESB

« Last post by moonwatcher on December 23, 2010, 05:57 AM »

esbglenn (Glenn Crouch, ESB software developer) via Twitter:

For a short time, anyone can purchase our ESBCalc Pro Suite as a special upgrade for $15USD by using this PayPal URL: http://bit.ly/gmRw8D

5

Post New Requests Here / Re: Delete files listed in excel sheet

« Last post by moonwatcher on February 03, 2009, 07:49 AM »

There are no stupid questions, only stupid answers ;-)

It is a VBA macro:

1) open your excel worksheet
2) press ALT+F11 to start the VBA editor
3) Insert -> Module
4) Paste the code into the editor
5) Alter the code to fit your needs (e.g. starting row and/or column number)
6) press ALT+F11 to switch back to excel
7) press ALT+F8 to run a macro and select deleteFiles

(you can speedup execution if you place Application.Calculate = false before the While-Loop and a corresponding Application.Calculate = true before the end-sub command; this will prevent excel from repainting the worksheet everytime a file has been deleted)

6

Post New Requests Here / Re: Delete files listed in excel sheet

« Last post by moonwatcher on February 03, 2009, 07:32 AM »

Let excel do the work for you:

(example macro)


Option Explicit

Sub deleteFiles()
    Dim row, col As Integer
   
    row = 1 'starting row
    col = 1 'column with filenames
   
    While Not IsEmpty(Cells(row, col))
        If Dir(Cells(row, col)) <> "" Then
            Kill (Cells(row, col))
            Cells(row, col + 1) = "deleted"
        Else
            Cells(row, col + 1) = "not found"
        End If
        row = row + 1
    Wend
   
End Sub


This macro will get the filename from the first column in the active sheet, starting with the first row until the first blank cell is reached. A status is written into the 2nd column.

7

General Software Discussion / Re: Streaming in real time only?

« Last post by moonwatcher on January 03, 2008, 08:12 PM »

Most of the time I'm using SDP for downloading asf or wmv streaming media and since it IS streaming media, the time to "download" a video is equal to the video's length. Remember, you are not really downloading a video file but only recording or ripping the content sent by a media server. This should apply to all media servers using the MMS^w protocol to transport their live or prerecorded media files.

8

What's the Best? / Re: Package Management for Windows

« Last post by moonwatcher on November 16, 2007, 12:44 AM »

One more to add to your list:

9) UpdateStar (http://www.updatestar.com)