2 Ways to remove #N/A Excel error in VLOOKUP, Worksheet or VBA Macro code. Fix Vlookup #n/a & Excel #n/a common errors formula. Hide n/a Excel Error.
Add Excel VBA Drop Down Data Validation List
August 13, 2020
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here – but all are related to validation list. Note: Combo-box control that also display list of values in dropdown is not explained in this page. Adding Drop Down […]
[VBA] How to Convert Word Document to PDF?
August 13, 2020
This page explains how to save a word document to PDF using: VBA Code PDF Converter Manually Save Word as PDF Both the methods are simple & straight forward. Lets start with the automation code first. 1.VBA Code to Convert Word to PDF Word VBA has a direct function to […]
20% Discount Offer link for Fiverr – Hire Experts at affordable Prices
August 13, 2020
Fiverr – Microjobs Posting Platform If you are looking to hire quality expert to get your job done, Fiverr is right choice. Either you can post Job details with price & timeline, wait for experts to bid for it. Or you can directly filter available experts & pay for the […]
Is Excel File already open in VBA – By Another User
August 13, 2020
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
August 13, 2020
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 Msgbox with Yes No Cancel Options
August 13, 2020
User Input Msgbox with Yes No Cancel Some time the VBA code has to get approval from user with Yes/No/Cancel optop. Here is the simple code snippet that get the Yes, No, Cancel options in a popup window. Example scenario for this would be like if there is any file […]
[Python] Check if File Exists
August 13, 2020
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 snippet. Both functions take same parameter (file path) & return a boolean response. i.e., True if file exists or False if […]
How to check if File Exists in PHP?
August 13, 2020
Verify if a File exists with PHP In PHP, function to check if a file exists in a folder path is file_exists. Just pass the file with complete path to this function. If the file is present, then this function will return True. Otherwise you will get a False as […]
VBA Copy File to Folder
August 13, 2020
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 […]
