How to Move a File and Add a Date Timestamp in VBScript

Описание: Learn how to move a file in VBScript and add a date timestamp to it for record-keeping. This step-by-step guide will help you implement the solution effectively.
---
This video is based on the question https://stackoverflow.com/q/66208096/ asked by the user 'TryhisBest' ( https://stackoverflow.com/u/15213648/ ) and on the answer https://stackoverflow.com/a/66212990/ provided by the user 'Étienne Laneville' ( https://stackoverflow.com/u/7319046/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Trying to move a file and add a date timestamp

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Move a File and Add a Date Timestamp in VBScript

Moving files programmatically can be a daunting task, especially if you're new to scripting. One common requirement is to not just move a file but also rename it with a timestamp. This can be useful for keeping records or versioning files automatically.

In this post, we’ll walk you through a VBScript solution that will help you move your CSV file and append the current date as a timestamp. Let’s dive in!

The Problem

Imagine you have a CSV file named ITEM INVENTORY BY PURCHASE ORDER.csv and you want to move this file to a different folder. Additionally, you’d like to rename it, adding a date stamp so you can easily track when it was moved.

The code you've tried is on the right track but needs some refining. Don't worry; we will provide you with a clear solution!

The Solution

Required Components

To achieve our goal, we need to:

Define the source file location

Define the destination folder

Create a File System Object

Check if the source file exists

Move the file and rename it with the current date

Step-by-Step Implementation

Here’s the VBScript code that accomplishes the task:

[[See Video to Reveal this Text or Code Snippet]]

Breaking Down the Code

Declare Variables:

sSourceFile: The path to the file you want to move.

sDestinationFolder: The location where you want to move the file.

sDate: A string that gets populated with today’s date in YYYY-MM-DD format.

objFSO: An instance of the FileSystemObject which enables file manipulation.

Creating the Date String:

We format the current date using Year(Now), Month(Now), and Day(Now) functions to create a string that can easily be appended to the filename.

File Existence Check:

Before attempting to move the file, it's prudent to check if it actually exists to avoid runtime errors.

Moving the File:

If the file exists, the script moves it to the specified destination, renaming it in the process to include the current date.

Error Handling:

If the file does not exist, a message box will alert the user.

Conclusion

By following the structured method above, moving a file and adding a date timestamp in VBScript becomes straightforward. This solution not only automates the file-moving process but also enhances your record-keeping by providing clear dates on when files were processed.

Remember, scripting can be a little tricky, but with practice, you can master it! Give this script a try, and you’ll be well on your way to effective file management.