Login with username and password (forgot your password?)

SnapTimer is PERFECT, particularly knowing about the set-zero suggestion.  Couldn't ask for a better choice.

And Tranglos' Ethervane Stopwatch is a super good one, too.

Thanks to both of you!

Skwire... DONE!

[Shortcut on desktop. Double-click. Timer window comes up and starts counting up automatically. In HH:MM:SS format.]

Maybe this already exists, or can be done with some batch file.  If so, let me know.

Shortcut on desktop.  Double-click.  Timer window comes up and starts counting up automatically.  In HH:MM:SS format.

No need even for a stop button.  Can simply be able to close the window/program.

Count-up window and digits should be large enough to be able to easily see.  Preferably allow user to select colors of digits and background, to suit their mood.

A zillion advanced timers out there in cyberland.  But not what I'd like as described above.

All help greatly appreciated.

Nicholas Kormanik

Skwire, magic indeed.  Works like a charm.

And guess what, ALL my Excel xls column headers/labels lined up perfectly in the output text file your program created, exactly the same in each line, all the way down to the last.  So I can now be certain that a vertical concatenation of all the files should be doable.

I thought of asking for the additional way of knowing which file might be in error, should one be, but didn't want to add to the request.  Very glad you anticipated the need and built it in.

Only change I'd make is to rename it.  YOU deserve all the credit, Skwire.

Thanks a million!

You can mark this really tasty snack as DONE.

Max number of columns would be 250.

That large number means it'll be lots of work without some magic.

Found basically the same question here:

http://stackoverflow.com/...dy-of-a-single-excel-file

With the following vba (?) code solution:

Sub FirstRow()
    Application.DisplayAlerts = False
    Dim strFilename As String
    Dim strPath As String
    Dim wbMaster As Workbook
    Dim wsMaster As Worksheet
    Dim wbFiles As Workbook
    Dim i As Integer

    i = 1
    Set wbMaster = ThisWorkbook
    Set wsMaster = wbMaster.Sheets(2)
    strPath = "C:\path\to\your\files\"
    strFilename = Dir(strPath & "*.xls")

    Do While strFilename <> ""
        Set wbFiles = Workbooks.Open(strPath & strFilename, False)
        wbFiles.Sheets(1).Rows(RowIndex:=1).Copy
        wsMaster.Cells(RowIndex:=i, ColumnIndex:=1).PasteSpecial Paste:=xlPasteAll
        wbFiles.Close (False)
        strFilename = Dir
        i = i + 1
    Loop
    Application.DisplayAlerts = True
End Sub

"A couple of things to note:
- You'll want to change the Sheet(x) references to the appropriate values for your needs
- Ensure there is a "\" at the end of strPath when you put in your own path
- I've turned DisplayAlerts to false during the execution to avoid a pop-up on every file asking if you want to clear the clipboard or not."


Unfortunately I don't understand how to use his solution.  Wish he had have given an example, or explained it more extensively.

I need to vertically concatenate around 100 Excel files (xls) -- using a program called "Merge Excel Files."

That program assumes all files are structured the same, same column headers extending across in each file.

I must double-check that, though.

Assume 100 xls files in a single folder.  I'd like to find a way to copy the first row -- the column headers -- of every xls file over into, say, a text file.  Then in a text editor (with word wrap off) I can easily peruse down making sure all column headers are as they should be -- each column in the text file will have only one particular label.

One possible solution would be to use Skwire's ClipTrap.  Load each of the 100 xls files one at a time, highlight the first row, copy.  But this would take some time.

Hoping someone can come up with an easier way.

Thanks.

Nicholas Kormanik

I've used c.gingerich's created program -- SubCopy -- a couple of times now, and it makes the task a piece of cake.

The great thing about these threads is that anyone searching the Internet trying to find a similar solution will probably be directed here.  Makes life a lot easier.

You folks are amazing.  Another one DONE!

Thanks so much.

Sure I'm open to an AutoHotkey solution.  Anything to easily get the job done.  And that might be useful to others.  Who knows.

If, though, the best bet would be to simply write a long batch file, I'll stick with that.

Thanks.

Say we have a subdirectory -- c:\1 -- that contains 100 folders.  We have a file on our desktop -- file.txt -- that we want to go into every single one of those folders.

We could write a 100-line batch file to do this.

Is there an easier way?  A one-liner?

Thanks!

Let's mark it DONE.  Thanks guys.

So far it looks fantastic.  Really looking forward to seeing what you have in mind.

Thanks much!

Looks like a really useful thrust.  Extremely glad to have you, Skwire, and everyone else here available.  Thank you all.

Nice attempt Stephen66515.  Your program does offer something that's hard to do -- open multiple URLs at once, across multiple tabs.

However, the present task is to just use ONE tab, and open URLs one at a time into the single tab, as needed, and moving on to the next URL in line (perhaps a hundred URLs in all) with a key press or mouse click.

While not a GUI, Skwire does this in his script.

Skwire, adding the extra sleep step did the magic.  I can attest we have a working solution here now.

Maybe someone can make a stand-alone tool.  But at least we have a way that works.  Thanks much, Skwire.

Ath, are you asking ME?  I wouldn't change ANYTHING except what is suggested.

I'm kinda clueless regarding AutoHotkey.

Increased sleep to 5000, and still the same problem.

What generally happens is that the h gets chopped off at the beginning of URLs.

So only:  ttps://plus.google.com/104410043740081757281

And that, of course, doesn't go to the intended site.

Skwire's solution worked fine with the example URLs he provided.

Unfortunately not so with my case:

myURLs =
(
https://plus.google.com/104262594301276893821
https://plus.google.com/104283716002131797428
https://plus.google.com/104309222535259801633
https://plus.google.com/104392019611590500945
https://plus.google.com/104410043740081757281
https://plus.google.com/104429427297929885544
https://plus.google.com/104479772621336105362
https://plus.google.com/104541959256591361052
https://plus.google.com/104575325257916010047
https://plus.google.com/104608435688900811644
https://plus.google.com/104612126840644619266
)
etc...

The URL box entry gets broken up.  Could be do to a number of things, like the additional search box on the webpage, or possibly a conflicting add-in loaded?

So, mission not quite accomplished.  Thanks mouser for keeping the thread active.

Possible enhancement requests, though, Squire, in case there's an easy solution to the above:

-- Allow a reference to a separate file that holds the URLs.  Such as, "c:\look at sites\url list.txt"  Instead of forcing user to edit the .ahk script file.

-- Allow for a longer list of URLs.  I got error messages that I had too many (when attempting a much longer list than that shown above).

-- Perhaps allow user to choose which key to use to go forward, for instance the insert key (though a nice addition, I don't care so much about being able to go backward).

Thanks.

Unless anyone has anything else to add, mark as done.

Thanks again, Skwire.  You sure come through.

Many people have asked that Flem be ported to Chrome.  For some reason the authors of Flem decided not to.

Thanks, Skwire, for the AHK script!

There is an add-in that does roughly the same in Firefox, called Flem.  But at present I prefer using Chrome.

Say we have a list of 100 URLs, and want to load these one at a time in Chrome.  Not in different tabs, but in the same tab.  Suppose that only one tab is needed, and only one tab will then be open.

I'd like to manually move through these URLs, spending as much time as I want on the opened page, then clicking or pressing a button and moving on to the next page.

Preferably the pages already visited can be deleted from the list, at some point.

Preferably the list can be saved, and brought up again, so that progress can be continued with the remaining URLs.

Preferably one can have more than one such list.

Thanks for suggestions, or possibly a program.

Nicholas Kormanik

I've noticed that with some "system tray icons" clicking once on them opens up their window, and clicking again makes the window disappear back to the system tray.

I wonder if that could be implemented in Cliptrap?

Thanks!

FileMenu Tools is good for adding in the offered utilities, or creating shortcuts to existing applications.  And it does allow you to put these into folders.  So, that's a good thing.

But I don't think FileMenu Tools allows you to put your present context menu items into sub-folders, and reposition out of the regular context menu.

What we need is some ingenious way to 'sub-folder' the existing mess.

For many of us, Explorer Context Menus are a mess.  Every other program we install wants to add something to them.  After this happens a few times limits are reached, existing context menu entries get bumped, no longer available, new ones get added that we don't want.

I periodically use a program (Glary Utilities, one of many that can do the same thing) to disable context menu entries I don't care about.  The disabled entries number at least 10X that of the enabled ones.

I've come across one commercial program, Moo0 RightClicker Pro,

(http://www.moo0.com/?top=...om/software/RightClicker/)

that allows repositioning any and all context menu entries into separate sub-folders or sub-menus of the Explorer context menu.  Being able to do that seems a great idea.

I'm wondering if anyone knows of a free program capable of this, or if one can be made by someone here.

Thanks,
Nicholas Kormanik