Excel export Excel to PDF with and without VBA

Posted on June 27, 2015December 14, 2015 by Wyman W

This Excel tutorial explains how to export Excel to PDF with and without VBA, how to export all worksheets to one PDF, and export all worksheets to separate PDF. You may also want to read: Select multiple worksheets using Excel VBA Excel export Excel to PDF In Excel, navigate to File > Save As, in the Save As Type, you can save a file as different file types. Below is the available types in Excel 2013. In this tutorial we are going to focus on exporting Excel to PDF. Now se...

Excel VBA Inputbox and Application.Inputbox

Posted on June 21, 2015February 6, 2017 by Wyman W

This Excel tutorial explains difference between VBA Inputbox and Application.Inputbox and how to use them. You may also want to read: Excel VBA Msgbox and handling of return value Excel VBA use Inputbox to select options Excel VBA Inputbox and Application.Inputbox Inputbox is a pop up dialog box that displays a message and provides a text box for users to input free text. It is very similar to Msgbox except that Msgbox does not have a text box for user input. There are two kinds o...

Access Excel FSO File Methods

Posted on May 5, 2015May 5, 2015 by Wyman W

This Access / Excel tutorial explains how to use FSO File related Methods including FileExists, DeleteFile, MoveFile, CopyFile You may also want to read: Loop workbooks in folders and subfolders Access Excel FSO Folder Methods FSO File Methods FileSystemObject (FSO) provides an API to access the Windows filesystem such as accessing Drive, TextStram, Folder, File. In this tutorial, I will only explain the use of some important File related Methods. For details, please read the MSDN lib...

Access Excel FSO Folder Methods

Posted on May 4, 2015May 5, 2015 by Wyman W

This Access / Excel tutorial explains how to use FSO Folder related Methods including FolderExists, CreateFolder, DeleteFolder, MoveFolder, CopyFolder You may also want to read: Loop workbooks in folders and subfolders FSO File Methods FSO Folder Methods FileSystemObject (FSO) provides an API to access the Windows filesystem such as accessing Drive, TextStram, Folder, File. In this tutorial, I will only explain the use of some important Folder related Methods. For details, please read...

Excel VBA Application Volatile Method to force recalculate

Posted on April 21, 2015April 21, 2015 by Wyman W

This Excel tutorial explains the use of Application Volatile Method to recalculate custom Function (User Defined Function). You may also want to read: Excel Workbook Calculation Automatic and Manual Excel VBA Application Volatile Method In Excel VBA, you can create your own Functions, we call it User Defined Function (UDF), usually I simply call it custom Function. Function is a Procedure that can take argument and return a value. There are two kinds of custom Functions. The first ...

Excel Range Sort Method to sort data

Posted on April 20, 2015April 20, 2015 by Wyman W

This Excel tutorial explains how to sort Excel data using Excel VBA Sort Method, and how to sort dynamic Range. You may also want to read: Sort data using custom Function by Bubble Sort Sort data using custom Function by assigning number to Text Sort data using Table AutoFilter Sort data using Worksheet AutoFilter Excel Range Sort Method to sort data There are mainly three kinds of sorting in Excel. 1 - Table AutoFilter sorting, using List Object to access AutoFilter. 2 - ...

Excel VBA Workbook LinkSources Method to find external links

Posted on April 13, 2015December 24, 2016 by Wyman W

This Excel tutorial explains how to use Workbook LinksSources Method in Excel VBA to find all external links. You may also want to read: How to refresh all external data of closed workbook Excel find all external links and broken links in workbook Excel VBA Workbook LinkSources Method LinkSources can be used to return an array of names of linked documents, editions, DDE or OLE servers. Assume that you have two formula that link to another workbook, for example ='C:\Users\WYMAN\Des...

Access Excel Scripting Dictionary store unique array item

Posted on April 7, 2015February 26, 2017 by Wyman W

This Access Excel tutorial explains how to use Scripting.Dictionary in VBA to store unique array item. You may also want to read: Access Excel VBA Array Remove duplicates in text using Dictionary Access Excel VBA Scripting.Dictionary to store unique array item An associative array, map, symbol table, or dictionary is an abstract data type composed of a collection of (key, value) pairs, such that each possible key appears just once in the collection. Put it simply, you can avoid duplica...

Excel VBA Application.OnTime Method to schedule event with timer

Posted on April 4, 2015July 19, 2016 by Wyman W

This tutorial explains how to use Excel Application.OnTime Method to trigger / schedule event at specified time. You may also want to read: Auto Open Excel with Windows Task Scheduler Excel automatically refresh pivot table Excel VBA Application.OnTime Method to trigger event at specified time You can do the followings with Excel VBA Application.OnTime Method - schedule a procedure to be run at a specified time in the future - schedule a procedure to be run after a specific amou...

Excel VBA Worksheets.Add Method to add new worksheet

Posted on March 5, 2015July 16, 2015 by Wyman W

This tutorial explains how to add new work sheets using Worksheets.Add Method in Excel VBA, or add new worksheets at the back or before specific worksheet You may also want to read: Excel VBA Worksheets.Copy Method to copy worksheet Excel VBA Worksheets.Add Method to add new worksheet Excel VBA Worksheets.Add Method is to add new worksheet in a workbook. Syntax of Excel VBA Worksheets.Add Method Worksheets.Add([Before],[After],[Count],[Type]) Before Optional. Add new worksheet ...