Skip to main content

Posts

Directory in CMD

 Microsoft Windows [Version 10.0.22543.1000] (c) Microsoft Corporation. All rights reserved. C:\Users\somet>dir /? Displays a list of files and subdirectories in a directory. DIR [drive:][path][filename] [/A[[:]attributes]] [/B] [/C] [/D] [/L] [/N]   [/O[[:]sortorder]] [/P] [/Q] [/R] [/S] [/T[[:]timefield]] [/W] [/X] [/4]   [drive:][path][filename]               Specifies drive, directory, and/or files to list.   /A          Displays files with specified attributes.   attributes   D  Directories                R  Read-only files                H  Hidden files               A  Files ready for archiving                S  System files               I  Not content inde...

Delete in CMD

 Microsoft Windows [Version 10.0.22543.1000] (c) Microsoft Corporation. All rights reserved. C:\Users\somet>del /? Deletes one or more files. DEL [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names   names         Specifies a list of one or more files or directories.                 Wildcards may be used to delete multiple files. If a                 directory is specified, all files within the directory                 will be deleted.   /P            Prompts for confirmation before deleting each file.   /F            Force deleting of read-only files.   /S            Delete specified files from all subdirectories.   /Q            Quiet mode, do no...

robocopy

 Microsoft Windows [Version 10.0.22543.1000] (c) Microsoft Corporation. All rights reserved. C:\Users\somet>robocopy /? -------------------------------------------------------------------------------    ROBOCOPY     ::     Robust File Copy for Windows -------------------------------------------------------------------------------   Started : Wednesday, November 2, 2022 10:30:21 PM               Usage :: ROBOCOPY source destination [file [file]...] [options]              source :: Source Directory (drive:\path or \\server\share\path).         destination :: Destination Dir  (drive:\path or \\server\share\path).                file :: File(s) to copy  (names/wildcards: default is "*.*"). :: :: Copy options : ::                  /S :: copy Subdirectories, ...

VBA Operators

  VBA Operators VBA uses a handful of simple operators and relations, the most common of which are shown in  Table 5-5 . Table 5-5. VBA Operators and Relations Type Name Symbol Arithmetic Operators Addition +   Subtraction -   Multiplication *   Division /   Division with Integer result \   Exponentiation ^   Modulo Mod String Operator Concatenation & Logical Operators AND And   OR Or   NOT Not Comparison Relations Equal =   Less than <   Greater than >   Less than or equal to <= or =<   Greater than or equal to >= or =>   Not equal to <> or >< The  Mod  operator returns the remainder after division. For example: 8 Mod 3 returns 2, since the remainder after dividing 8 by 3 is 2. To illustrate string concatenation, the expression: "To be or " & "not to be" is equivalent to: "To be or not to be"

Open Microsoft office applications

How to open Microsoft office applications from run command prompt without a mouse Are you tired of mouse clicks? Do you often leave the keyboard to simply move your mouse around to look for a Microsoft application to open? In this article, we shall draw the keyboard closer to us when opening any Microsoft application by availing the commands that you can put in the run command prompt to open MS word, MS excel, MS PowerPoint, MS publisher, MS access, and MS outlook without any mouse click. I am pretty sure that your business or you personally use Microsoft packages so often to create documents. These documents include reports, proposals, shopping lists, etc. Knowing simple keyboard shortcuts can increase your efficiency. That’s why in this article we shall cover how to start up MS Word, MS Excel, MS PowerPoint, MS Publisher, and MS access from the run command prompt with simple commands which will remain part of you forever. This will require no mouse. There are many methods that you ca...

Quits the CMD.EXE program

Exit the CMD.EXE program  C:\Users\somet>exit /? Quits the CMD.EXE program (command interpreter) or the current batch script. EXIT [/B] [exitCode]   /B          specifies exiting the current batch script instead of               CMD.EXE.  If executed from outside a batch script, it               will quit CMD.EXE   exitCode specifies a numeric number.  if /B is specified, sets               ERRORLEVEL that number.  If quitting CMD.EXE, sets the process               exit code with that number.

Code of shutdown in CMD

 Code of SHUTDOWN in CMD C:\Users\somet>shutdown /? Usage: shutdown [/i | /l | /s | /sg | /r | /g | /a | /p | /h | /e | /o] [/hybrid] [/soft] [/fw] [/f]     [/m \\computer][/t xxx][/d [p|u:]xx:yy [/c "comment"]]     No args    Display help. This is the same as typing /?.     /?         Display help. This is the same as not typing any options.     /i         Display the graphical user interface (GUI).                This must be the first option.     /l         Log off. This cannot be used with /m or /d options.     /s         Shutdown the computer.     /sg        Shutdown the computer. On the next boot, if Automatic Restart Sign-On                is enabled, automatically sign in and lock the last intera...