Skip to main content

Posts

Showing posts from November 2, 2022

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"