VBA: Application Open FileName List all Excel File types

When you are showing a open dialog box to the user to select an excel file, by default the filter would be *.* which will show all files including excel files. and .xls and .xlsx will show only 97-2003 and 2007 excel files and failed to show .xlsb and .xlsm files. The below code (.xls*) will show all types of excel files.

Read more ...

VBA - Unzip files using VBA

The below code will Unzip a *.zip file to a specific folder. We have already seen couple of examples like 'Accessing system special folders' and 'Creating shortcut of an system application', This code also in the same series of Unzipping the files. Quite useful if you are designing a complete protect and want to install in client machine.

Read more ...

VBA - Download files from sharepoint

The below VBA code will be used to download files from a sharepoint folder at one-click. I have got this code through surfing, this is quite usefull for the people who involves their day to day job with sharepoint files.

You can now do the same kind to upload files in sharepoint, will try my best to post a code for Uploading files to sharepoint.

Read more ...

Append string to a existing notepad (.txt) file in sharepoint

The below code will be used to append string to an existing text file in a sharepoint folder, you can do the same function with an existing folder in your computer/ shared folder.

e.g. When you want to create an user's log to a workbook in a separate file, you can use this code.

Read more ...

VBA Excel: Get Directory (Folder Path)

The 'Get Directory' function will be used to get a folder path with file explorer option. mostly used to open/save a file OR list of files from a particular directory.

Read more ...

VBA Excel: Combine multiple excel files

The below source code will combine multiple workbooks in a folder into single workbook.

Read more ...

VBA Excel: Create new excel file (xls, xlsx)

If you need to create a new workbook with the collected data from Userform or existing data in the source workbook/worksheet, use the below code. This code will sense the application version (Ms2003, Ms2007 and above) and create the new excel file.

Read more ...