Python vba to create a date string for creating a file name

Creating a file name is essential for scraping. Is the file name most often date + serial number? In many cases, date + time is fine, but If the number is small, the date + serial number is the most popular, so I made a note of how to create the file name.

For Python

Premise Windows Python3.7 The following is when creating a CSV file name with date + serial number If you format () with strftime, it can be treated as a character string. You can add the desired string to the end.


import datetime
hizuke =
hizuke = hizuke.strftime('%Y-%m-%d')
file1 = hizuke+"-1.csv"  #2020-08-11-1.csv * Today's date
file2 = hizuke+"-2.csv"    #2020-08-11-2.csv

Click here for detailed date format

For vba


 Dim strFileNm As String
 strFileNm = Format(Now(), "yyyy-mm-dd") & "-1.csv" '2020-08-11-1.csv * Today's date

Click here for detailed date format

In the case of vba, the date formatting is the same as the one used in Excel, so it is familiar.

Recommended Posts

Python vba to create a date string for creating a file name
How to create a JSON file in Python
Parse a JSON string written to a file in Python
[python] Convert date to string
Python script to create a JSON file from a CSV file
[python] Change the image file name to a serial number
[Python] Create a date and time list for a specified period
Create a message corresponding to localization with python translation string
Create a binary file in Python
5 Ways to Create a Python Chatbot
Create a random string in Python
How to create a config file
[For Python] Quickly create an upload file to AWS Lambda Layer
Creating a simple PowerPoint file with Python
Let's create a virtual environment for Python
[Python] How to invert a character string
Create a deb file from a python package
[GPS] Create a kml file in Python
Script to create a Mac dictionary file
Things to watch out for when creating a Python environment on a Mac
Create a shortcut to run a Python file in VScode on your terminal
[Python] Create a linebot to write a name and age on an image
[Python / Tkinter] Search for Pandas DataFrame → Create a simple search form to display
Tips for Python beginners to use Scikit-image examples for themselves 3 Write to a file
[Python] List Comprehension Various ways to create a list
Edit Excel from Python to create a PivotTable
How to read a CSV file with Python 2/3
Create a GIF file using Pillow in Python
How to create a Python virtual environment (venv)
How to embed a variable in a python string
How to create a function object from a string
Create a LINE BOT with Minette for Python
I want to create a window in Python
Procedure for creating a LineBot made with Python
Python Note: When assigning a value to a string
Steps to create a Twitter bot with python
How to create a shortcut command for LINUX
Commands for creating a python3 environment with virtualenv
Export Python3 version OpenCV KeyPoint to a file
Procedure for creating a Python quarantine environment (venv environment)
Create a datetime object from a string in Python (Python 3.3)
Create a Photoshop format file (.psd) with python
Create a MIDI file in Python using pretty_midi
A memo for creating a python environment by a beginner
I want to write to a file with Python
String to Unicode Escape Sequence Format for Python
[Python] Create a list of date and time (datetime type) for a certain period
I want to create a nice Python development environment for my new Mac
[Python] I tried to get the type name as a string from the type function
<Python> A quiz to batch convert file names separated by a specific character string as part of the file name
Create a dataset of images to use for learning
Create a Python module
[Python] 2 Create a risk-return map for your asset portfolio
Create a plugin to run Python Doctest in Vim (2)
[Go] How to create a custom error for Sentry
A memorandum to run a python script in a bat file
[Introduction to python] A high-speed introduction to Python for busy C ++ programmers
I want to randomly sample a file in Python
Steps from installing Python 3 to creating a Django app
[Python2] Date string-> UnixTime-> Date string
Python program that looks for the same file name