Get VBA code to convert .Txt ANSI encoding to UTF8 Unicode format. ALso learn how to do UTF convertion using built in function in text editors.
Excel VBA List Files in Folder – Dir in Shell
November 17, 2024
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
November 17, 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
November 17, 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 […]
Python Check if File Exists – Get Easy code
November 17, 2024
Using Python – Check if file exists in a path Python is a versatile programming language that is widely used for a variety of tasks. One of the common tasks is to check if a file exists in a specific path. In this article, we will discuss how Python check […]
PHP Check If File Exists in a Folder path – in 2 Easy ways
November 17, 2024
Get code from PHP check if file exists in a folder. This code can be used in wordpress or any php site to find if file is present in a server folder.
VBA Copy File to Folder
November 17, 2024
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 more options like: Adding wild cards with source file & option to overwrite a file if already exists. Vba built in Filecopy function […]
Excel Vba Save a Copy of Workbook with TimeStamp
November 17, 2024
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 file with different names every time the macro is executed. In such cases, if the file name can […]
How to Convert Docx to PDF – VBA Save Word as PDF
Learn how to convert a docx to PDF file using different methods. Also using the VBA code save word as PDF or using the menu option of your choice.
How to Zip File or Folder using VBA Code – Excel Macro?
November 17, 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 & […]