VBA Code to Find My Documents Folder Path This code will get the folder path directly pointing to the ‘Documents” folder. Using this code, the documents folder path can be returned in a string variable. This technique is used when You need to save any log or temporary file in […]
Excel VBA Rename File – Without opening the File – 2 Easy Ways
Get Excel VBA Rename file – Macro code to change file name. Input existing file name with itspath & new name. This VBA code will rename file to new name..
Add Time Stamp to Notepad Text File
December 19, 2024
How to add Date Time stamp in Notepad File There are 2 ways to do this. First one is manual & the other is automatic. 1. Press F5 will insert current date & time 2. Type .LOG as first line of notepad file. (case-sensitive) What is the difference between these […]
Excel VBA Get File Extension – 2 Simple Methods
December 19, 2024
Using Excel VBA get File extension from file name using this simple macro code. The code extracts the File extension using VBA File system object.
Excel vba Add Date Time Stamp to File Name
December 19, 2024
Save File with Date Time Stamp In Excel vba we can create new file or save the current workbook with different name. In that case, sometimes we add date, time or both at end of file. This way, the file names will be unique & also the file versioning can […]
How to Zip Directory using Python? – Archive folder
December 19, 2024
Archive or Zip all files in Directory The code in this page will Zip directory full of files. It will first get folder path as input. Then loop thru the directory & its sub-directories to get all the files list. Then each file in the list is added to the […]
VBA to Delete File in a Folder
December 19, 2024
Get VBA code to delete file from a system folder. It uses filesystemobject.deletefile function & the VBA.kill function. Both uses the filepath as parameter.
Get List of All Subfolders in a Folder – Excel VBA
December 19, 2024
Excel VBA Dir – Directory Listing – All Subfolders The macro will fetch all subfolders & folders under subfolders till its last child folder. You just have to input the root folder path for this macro. It is a complete code that will search or process all the files in […]
Excel VBA – Folder Operation – Exists, Create, Copy, Delete Directory
December 19, 2024
VBA code to Check folder Exists or not, Create Folder, delete folder, copy folder, move folder, create file, change current working directory & lot more.
Removing Empty Folder is Now Easy – Get Folder List with Size
December 19, 2024
Fully Functional code that can fetch you folder list along with its size. This helps ur to find empty folders in our system. Once we get the list, we can remove the empty folders and on the other hand if the folder size is so huge, we can dig in and find why it’s size is so much huge.