Showing all 20 articles in this category.
Get Folder List with VBA Dir - Remove Empty Folders To get the list of folders within a folder through VBA, it would have been nice if the command name is VBA D...
Excel VBA - Create, Delete, Exists, Copy, Move, Open Folder Operation Be it any operation on a system directory, like any of these: List Folder or check folder ...
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 i...
VBA Delete File from Computer Folder There should be multiple ways to do it. In this article, I have given 2 methods . One is by using Filesystemobject & other ...
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 directo...
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 o...
Extract File Extension from Path A file extension is the text part of a file name after the last Dot '.' . This extension name is usually used by the operating ...
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 & tim...
How to Rename a file with Excel VBA? To rename a file with VBA, use the function mentioned below. Usually, You can find a lot of function used in VBA under the ...
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 ...
VBA Code to Zip File or Folder Just like this vba code, this also uses the Windows default file compressor. There is only one difference between this code and U...
How To Save Word Document as PDF? PDF refers to “Portable Document Format”. In order to avoid copying or alteration of information by the third party or unautho...
Create Excel file copy with Date & Timestamp in Vba In Vba we can access files & create new files. While doing such file operations, You may have to save a data...
Excel VBA Macro to Copy File This page explains about 2 options to do file copy using Vba. CopyFile option from FileSystemObject VBA.Filecopy The first one has ...
PHP to verify if a File exists in Directory In PHP, to check if a file exists in a folder path - use the function: ' file_exists '. Syntax: file_exists ('filepa...
How to check if a file exists in path using Python? There are 2 functions available in Python to check this directly using os.path. Try the below Python code sn...
Delete Folder using Excel VBA Macro This Excel VBA code will get folder path as input, check if it exists. Then it will delete if it exists. Important Note: Do ...
Is Excel File already Open - Check in VBA? While opening a Excel file or be it any file with VBA, You may need to check if it is already opened by another user ...
List Files in Folder using Excel VBA To get list of files in a directory, just give the folder path as input to this function. It will read the file in the fold...
How to change Text encoding from ANSI to UTF8? If there are multiple txt files or programatically you need to change the encoding of a file from ANSI to UTF8 or...