Doc Brown
  • Member for 11 years, 10 months
  • Last seen this week
1 answers
3 votes
4k views
How do I recursively compress only certain file extensions with 7zip command line?
Accepted answer
4 votes

You can repeat the -ir switch several times, like 7z a archive.7z -ir!.\*.txt -ir!.\*.doc (sometimes, just trying things out is the fastest way to get an answer ;-)

View answer
7 answers
9 votes
14k views
Looking for software to create Step-By-Step Screenshot guides
4 votes

IrfanView has all you need for this - a capture function and a plugin for drawing simple shapes like circles and numbers. And it is free for personal use.

View answer
2 answers
0 votes
2k views
Windows does not recognize the VB shell
Accepted answer
2 votes

When you get the "open with" dialog, there is an option to choose an arbitrary program. Use that option and choose either "C:\Windows\system32\cscript.exe" or "C:\Windows\system32\wscript.exe". The ...

View answer
2 answers
0 votes
189 views
How to write data after changing Excel column order to a text file in VBA
2 votes

Simple: make a copy of the current sheet and change the column order within the copy before saving. When you don't need the copy then any more, delete it.

View answer
1 answers
2 votes
876 views
How to display current time in Notepad++ console dialog?
Accepted answer
2 votes

Try cmd /c echo %time% that should do the trick. Some background information: echo is a build-in command of the windows command shell cmd, not an executable, so you cannot run it directly by ...

View answer
2 answers
1 votes
422 views
PowerPoint is removing image metadata. Can this be changed?
1 votes

If you really want to embed a certain image in its original form into a powerpoint presentation, your best bet is probably to use the feature of embedding objects / content. So you have to insert ...

View answer
2 answers
0 votes
99 views
Increase Size of Partition in Windows 10
1 votes

There are lots of partition manager tools available which can do this for you. Last week I used the free home edition of Minitool Partition Wizard for a very similar task, worked well for me.

View answer
1 answers
0 votes
63 views
Excel: How to get last result from above
Accepted answer
1 votes

You can utilize the LOOKUP formula to find the next non-empty value from above. For example, in row 7, column B (like in your example), enter =LOOKUP(2,1/(B$1:B6<>""),B$1:B6) This will find ...

View answer
5 answers
3 votes
5k views
How does ie tab firefox-addon emulate internet-explorer?
1 votes

I am pretty sure it uses the IE version that is installed on your system.

View answer
2 answers
1 votes
39 views
Windows 10: deleting a directory doesn't work... but works
0 votes

This is just a shot in the dark, but my best guess is, there is a background process which scans the files in your "building" directory, and as long as this process did not complete its task,...

View answer
1 answers
1 votes
173 views
Skipping unreadable files from damaged USB harddisk (Windows)
0 votes

You tried robocopy /w:10, but I guess what you need here is to use robocopy /r:1 (or a slightly larger number, in case you observe that this helps to save more files). Robocopy documentation says, ...

View answer
1 answers
1 votes
79 views
Amend VBA code to hide empty columns in whole workbook
0 votes

Try something along the lines of Dim wf As WorksheetFunction Dim i As Long, r As Range Dim sh as Worksheet Set wf = Application.WorksheetFunction For Each sh in ActiveWorkbook.Worksheets For i = ...

View answer
12 answers
53 votes
108k views
Windows 10 default programs keep changing
0 votes

Some of the fixes described here in 2016 do not work in newer Windows 10 versions (1809 or later). So here is what I did today to fix the problem, which manifested itself in our domain network by ...

View answer
2 answers
0 votes
94 views
Keep only one copy of the duplicated data
0 votes

(Out of my head, untested): In C2, enter =IF(B2=B1;"x";"") and copy this down to all cells in row C. This gives you an "x" for each duplicate value in column B. Now, you can set an auto filter to A-...

View answer
2 answers
2 votes
5k views
How to change the format of a cell without changing its content in Ms. Excel?
0 votes

This method should work without using VBA. Lets say your dates are in column A. add a helper column to the sheet. Lets say it is column B. add the formular =TEXT(A1,"dd/MM/yyyy") into cell B1, and ...

View answer
1 answers
1 votes
408 views
Excel conditional formatting: formula blanks treated inconsistently?
0 votes

When, for example, formatting cell A1, you can try =OR(A1=0,ISBLANK(A1)) as a condition, that should give you the same result for formular blanks as well as for empty cells. I tried it with Excel ...

View answer
8 answers
24 votes
107k views
From Word to PDF including bookmarks
0 votes

GS4Word is the only free tool I know of that does this for older Word versions (Word 2003 and before). Did not test it for Word 2007, but I suspect the chances are not bad it will work. The site I ...

View answer