Messages

301

Post New Requests Here / Re: For Serious Research: Cadillac of "ClipBoard Managers" vs. "Info/Data Manager"

« on: February 13, 2014, 09:14 PM »

TaoPhoenix, I haven't even gotten to the 'nested' subfolders yet.  Just a single folder jammed with an assortment of snippets.

Tomos, would you please share how outlines seem limiting?  Outlines are what I've been thinking of doing.  If there is some other approach I'd love to learn about it.

302

Post New Requests Here / Re: For Serious Research: Cadillac of "ClipBoard Managers" vs. "Info/Data Manager"

« on: February 13, 2014, 03:35 AM »

TaoPhoenix, thanks for sharing with us your work process.  Complicated, huh.

For serious research we must have some sort of system.  Reading through web pages, ebooks, papers, etc., to find potential 'puzzle pieces'.  Storing these, perhaps into some basic categories (as opposed to one huge messy 'shoebox'=folder).  Importing into a program permitting restructuring.  Then structuring and organizing, down to the finest detail.

Would be interesting to hear how others have managed.

303

Post New Requests Here / For Serious Research: Cadillac of "ClipBoard Managers" vs. "Info/Data Manager"

« on: February 10, 2014, 08:44 PM »

Thanks to the above members TaoPhoenix, Tomos, Rjbull for offering suggestions.

Tomos asks what am I "managing" the data with.  That seems to really point to the crux of the issue.  Having used Clipboard Trap..., I have a 'shoebox' (=folder) of long text files, each one with an assortment of topics.

Perhaps the focus of my query should NOT be with the clipboard manager point-in-time so much, but instead with "managing" the data.

Once the data is copied -- through any clipboard manager -- THEN what to do with it.  AT THAT POINT the data could be divided up into topics and sub-topics, arranged and re-arranged.

Skwire has built into Clipboard Trap the option of using a customizable 'delimiter', which separates snippets of text.  For that delimiter I use "=====" plus linefeeds above and below.  The delimiter could be used to automatically break apart the snippets when, say, importing the text files into a data management program.

Skwire, do you know of a program, or have you already written one, that can import delimited Clipboard Trap text files?  What would you suggest?

So, maybe the clipboard manager matter has already been adequately handled.  Maybe we need to figure out what to do with those copied files once we have them, to be further "managed".....

For such data management..., I would think an outliner-type program would be best.  The one I presently view as top pick is Scrivener:

http://www.literatur...te.com/scrivener.php

Followed by TreeLine:

http://treeline.bellz.org/

If you know of any better, please speak up.

So, once again..., surf the internet for relevant info, copy snippets using delimiters, import into data-holding-and-managing program.  Then massage, organize, edit, etc.

304

Post New Requests Here / For Serious Research: Cadillac of "ClipBoard Managers" vs. "Info/Data Manager"

« on: February 09, 2014, 09:36 PM »

For single topic clipboard saving I prefer Skwire's Clipboard Trap.  One long string of 'snippets' is created, in a single text file.

Presently, though, I'm researching an area with several sub-topics.  Perhaps a super-high-powered clipboard manager would be the best approach, one with configurable direction where items are to be saved.

Let's assume 5 sub-topics.  We cruise the Internet reading this and that.  We come across an item we want to save to Sub-topic 1.  Copy and save it to a Sub-topic 1 file.  Then we come across an item that belongs in Sub-topic 3.  Copy and save to a Sub-topic 3 file.  Etc. regarding Sub-topic 5, Sub-topic 2, Sub-topic 4.  So... five different files, as appropriate, are created and saved, with the relevant information in each.

I'm curious to hear views as to what might be the very best such research saving software presently available in the realm of clipboard managers.

Greatly appreciate your input.

Nicholas Kormanik

305

Post New Requests Here / Re: Batch file or vbs code to change name of xls worksheet back to "Sheet1"

« on: December 21, 2013, 05:02 AM »

Outstanding, 4wd.  Worked perfectly.  One double-click and it took care of the entire huge job.

Thank you very, very much.

306

Post New Requests Here / Re: Batch file or vbs code to change name of xls worksheet back to "Sheet1"

« on: December 21, 2013, 03:33 AM »

Seemed enormously promising, 4wd.  Hopefully just a tweak and it'll work.  Did as instructed.  In command window here's the error message continually received with each recursion/iteration:

C:\6>(cscript.exe ExcelWSRename.vbs "c:\6\15-3\data.xls" )
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

C:\6\ExcelWSRename.vbs(12, 1) Microsoft VBScript runtime error: Type mismatch: 'Sheet'


C:\6>(cscript.exe ExcelWSRename.vbs "c:\6\15-4\data.xls" )
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

C:\6\ExcelWSRename.vbs(12, 1) Microsoft VBScript runtime error: Type mismatch: 'Sheet'


C:\6>(cscript.exe ExcelWSRename.vbs "c:\6\15-5\data.xls" )
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

C:\6\ExcelWSRename.vbs(12, 1) Microsoft VBScript runtime error: Type mismatch: 'Sheet'

307

Post New Requests Here / Re: Batch file or vbs code to change name of xls worksheet back to "Sheet1"

« on: December 20, 2013, 07:08 PM »

Another possible lead:

http://www.extendoff...name-worksheets.html

VBA code to rename multiple worksheets by the name you want at once

Using the following VBA code, you can quickly rename all worksheets of the current workbook with the same prefix in their worksheet names, such as: KTE-order1, KTE-order 2, and KTE-order 3…

Step 1: Click on Developer > Visual Basic, and click Insert > Module in the Microsoft Visual Basic Application Windows.

Step 2: Please copy and paste the following code into the Module.

Sub ChangeWorkSheetName()
Dim WS As Worksheet
i = 1
On Error Resume Next
For Each WS In Worksheets
WS.Name = "KTE-order"&i
i = i + 1
Next
End Sub

308

Post New Requests Here / Re: Batch file or vbs code to change name of xls worksheet back to "Sheet1"

« on: December 20, 2013, 06:55 PM »

Here is vbs code that renames a worksheet, and various other things.  Note, unfortunately, that one must include the present name of worksheet.  That won't do in my present case, as I might as well just manually go in and rename....

http://stackoverflow...heet-with-batch-file

'launch Excel and open file
Set xlObj = CreateObject("Excel.Application")
Set xlFile = xlObj.WorkBooks.Open("c:\temp\filename.xls")
'turn off screen alerts
xlObj.Application.DisplayAlerts = False
'loop through sheets
For Each Worksheet In xlFile.Worksheets
   'change sheet to desired worksheet name
   If Worksheet.Name = "SheetToRename" Then
      Worksheet.Name = "NewName"
   End If
   'change all sheets to desired font
   With Worksheet.Cells.Font
       .Name = "Verdana"
       .Size = 12
   End With
Next 
'save, close, then quit
xlFile.Close True
xlObj.Quit

309

Post New Requests Here / Batch file or vbs code to change name of xls worksheet back to "Sheet1"

« on: December 20, 2013, 06:43 PM »

Because I divided many large xls workbooks (single worksheet only) into multiple worksheets, each worksheet (after being separately saved) has a unique name, not the standard "Sheet1."

Another program I'm using (SAS) is expecting each worksheet name to be "Sheet1."

I can, of course, manually go into each of the workbooks and rename the worksheet back to "Sheet1."

Would be lots easier, though, to have a batch file, vbs code, ahk code, or something, to place in respective folder, double-click, and do the name-change automatically.

In present case all the workbooks (in different folders) have the same name:  data.xls

Only one worksheet per workbook, worksheets have various names (like 15-1, 17-3, etc.).

Would someone please write the code that changes first worksheet (and only) in a workbook to "Sheet1"?

Note:  If it would be necessary to edit code to put the name of existing worksheet, then never mind.  That would be just as much work as manually renaming worksheets.

Any thoughts appreciated.

Thanks.

Nicholas Kormanik

310

Finished Programs / Re: DONE: Copy one particular file into every folder in a subdirectory

« on: December 20, 2013, 01:54 AM »

Okay, Skwire, the renaming approach worked.

Chris, For some reason SubCopy doesn't allow directly inputting or even editing the field "Source file."  (Only option is Windows navigation and selecting.)  If user could do that, it may be possible to place the full path and name of the shortcut file.

Example:  c:\downloads\do.lnk

That would be easier than having to rename, copy to subfolders, and then recursively rename back again.

But, hey, at least the task can be accomplished.  I'm quite thankful for that.

311

Finished Programs / Re: DONE: Copy one particular file into every folder in a subdirectory

« on: December 18, 2013, 09:44 PM »

Just in case I decide to recursively rename Do.lnkz back to Do.lnk...

...can you please remind me how to do that?

Do.lnkz ---> Do.lnk

In 75 sub-folders.

312

Finished Programs / Re: DONE: Copy one particular file into every folder in a subdirectory

« on: December 18, 2013, 08:55 PM »

I find that indeed since the shortcut is a file..., if I RENAME the extension, yes, I can use SubCopy to copy to the various sub-folders.

Example:  Do.lnk ---> Do.lnkz

But without such renaming the extension, SubCopy won't copy the shortcut itself.

Trouble with the renaming of extension, one has to recursively go in and change the extension back to what it should be.

Recursively changing filename extension creates its own issue.  In present case..., 75 nested instances of Do.lnkz.

313

Finished Programs / Re: DONE: Copy one particular file into every folder in a subdirectory

« on: December 18, 2013, 08:17 PM »

Two questions:

1.  SubCopy seems not to work with copying "shortcuts" into the target folders.  Can Chris or anyone explain why it's hard to handle shortcuts?

2.  SubCopy presently doesn't allow copying "folders."  While I have a small use for doing that, does such a request seem a bit over-the-top?

===

Yesterday using SubCopy I repeatedly copied various files into 75 different sub-folders.  SubCopy saved a huge amount of time, energy, tedium.  Great little gem.

314

Post New Requests Here / Re: IDEA: Delete all files except two particular ones

« on: December 10, 2013, 05:55 PM »

Thanks, rjbull.  I found and downloaded both.

After reading the help files, and knowing they are DOS, I'll take Skwire's solution.

Too, of huge importance, doesn't appear those programs are capable of "recursive" action.  Skwire's handles huge trees of folders, easy peasy.

315

Post New Requests Here / Re: IDEA: Delete all files except two particular ones

« on: December 10, 2013, 04:09 AM »

Works great, Skwire.

One double-click takes care of a huge task.  Amazing.

I'd say it's good to go.

Thanks!

316

Post New Requests Here / Re: IDEA: Delete all files except two particular ones

« on: December 09, 2013, 08:34 PM »

Worked well, Skwire.

Two suggestions:

1. I'd prefer typing into the script the name of the folder to act upon in the deletion process, just to be absolutely sure.  Would save user time as well, as opposed to the Windows navigation routine.

Example:  c:\5

2.  Possibly a way of giving a signal that task has been completed.  "Done."

I was waiting and holding my breath.

Fortunately all went as hoped.

Thanks a bunch!

317

Post New Requests Here / Re: IDEA: Delete all files except two particular ones

« on: December 08, 2013, 11:27 PM »

I think your "snippet" deserves a name.  Like, "Delete Except."

Maybe compile it, and allow user to put parameters into an .ini file?

318

Post New Requests Here / Re: IDEA: Delete all files except two particular ones

« on: December 08, 2013, 11:22 PM »

Outstanding, Skwire.  I'll give it a try.

Love that you've made it flexible, so that user can put in four files, ten files, a single file, etc.

Too, user can edit to focus on, say, .jpg files instead of .png files.

And, I presume, all other files will be left alone.

319

Finished Programs / Re: DONE: Program to Start another program, and then shut down after xx:xx time.

« on: December 08, 2013, 07:44 PM »

Skwire, this gem is completed.  Can be moved if you want.

320

Post New Requests Here / IDEA: Delete all files except two particular ones

« on: December 08, 2013, 07:39 PM »

This little challenge probably just involves some correct batch code, I'm guessing.  But maybe someone writing a small program would be worthwhile.  Don't know.

Suppose we have a tree-full of folders.  Each folder has lots of .png files of various names.

I want to delete every single .png file in the entire folder-tree (recursive?) EXCEPT for two:

"keep_this_one.png"
"save_me_as_well.png"

"keep_this_one.png" and "save_me_as_well.png" MUST be kept (i.e., leave alone), in the various folders they are located in.

All the other .png files are to be deleted.

Leave any non-png files alone.

Any help?

Thanks much.

As always, if the solution already exists, please direct me.

Nicholas Kormanik

321

Finished Programs / Re: DONE: Program to Start another program, and then shut down after xx:xx time.

« on: November 21, 2013, 04:38 PM »

Wow, that was fast.  Sounds super!

322

Finished Programs / Re: DONE: Program to Start another program, and then shut down after xx:xx time.

« on: November 21, 2013, 03:58 PM »

You might want to change the ini file to say time is "third" parameter, instead of "second", for those wanting to use command line.

As a possible enhancement, though not at all necessary, would be to show somewhere how much time remains before program termination.  Just a thought.

323

Finished Programs / Re: DONE: Program to Start another program, and then shut down after xx:xx time.

« on: November 21, 2013, 03:51 PM »

B I N G O !!!

Nuked that baby!!!!

And..., icon in system tray was different this latest time.  Instead of generic, was the icon of program to be nuked.

Great job, Christopher.  Mission accomplished.

Thanks much.

324

Finished Programs / Re: DONE: Program to Start another program, and then shut down after xx:xx time.

« on: November 21, 2013, 03:34 PM »

Downloaded from link.  ini file still appears the same as yesterday.  You made some change to it?

I see the new RunAndKill is version 1.0.2.0, as would be expected today.

325

Finished Programs / Re: DONE: Program to Start another program, and then shut down after xx:xx time.

« on: November 20, 2013, 09:39 PM »

In Windows Task Manager... there is no parameter shown after the program name.

Just "ace.exe"