Knowledge Base

Excel VBA example

 'Select cells and copy
 Range("I2:L14").Select
 Selection.Copy
 
 'Create new sheet and rename
 Sheets.Add After:=ActiveSheet
 ActiveSheet.Name = Format(Now(), "dd-MM-yy hh-mm-ss")
 
 'Paste
 Selection.PasteSpecial Paste:=xlPasteAll
 Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
 
 'Cleanup
 Sheets(1).Select
 
 Range("E1").ClearContents
 Range("B4:B5").ClearContents

 Range("A1").Select
Excel VBA example was last modified: July 25th, 2018 by tabcom

Move files into folders

I have a set of files:

.\Cat.txt

.\Dog.txt

I want to end up with this:

.\Cat\Cat.txt

.\Dog\Dog.txt

Solution:

for %i in (*) do md "%~ni"

for %i in (*) do move "%i" "%~ni"
Move files into folders was last modified: May 15th, 2018 by tabcom

Password expiration interval vs Account expiration date

Password Expiration

Windows may notify you at log-on that your password is expired and ask whether you want to change it now. The default interval that users were notified of password expiration is 5 days before expiration.

Password expiration interval specifies the number of days allowed before a password must be changed. Its purpose is to help enforce password policies in a business environment.

User Account Expiration

User account expiration is another similar built-in feature in Windows. It allows you to create a temporary user account that will expire automatically on the specified dates.

Upon reaching the expiration date, the user account is expired and you are unable to log on Windows any more. This feature is very useful when you need to create a Windows user account on a temporary basis. Continue Reading →

Password expiration interval vs Account expiration date was last modified: April 10th, 2018 by tabcom