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 folder one by one. Then display the file names. In this sample code, we will get list of […]
Is Excel File already open in VBA – By Another User
December 21, 2024
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 for editing. The file may present in local computer or a shared drive. In either way, […]
Excel VBA Delete Folder if Exists
December 21, 2024
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 not test this code with any important folder in your computer. You will end up in deleting important files in […]
VBA get Path to Default Temporary folder
December 21, 2024
VBA – Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, there is less coding effort required to manage the new folders. But, to do that, You need to first find the folder path. There may […]
How to Zip File or Folder using VBA Code – Excel Macro?
December 21, 2024
VBA Code to Zip File or Folder Just like this Unzip vba code, this also uses the Windows default file compressor. There is only one difference between this code and Unzip. Yuo just have to swap the parameters & Create a empty Zip file at first. Zip file path & […]
VBA – Find My Documents, Desktop & System Folder Path
December 21, 2024
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..
How to Zip Directory using Python? – Archive folder
December 21, 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 […]
Get List of All Subfolders in a Folder – Excel VBA
December 21, 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 21, 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.