When we use VBA to automate Excel operations on data or tables, one of the most common things we want to do is to find the number of rows of data or the number of records, in a worksheet. In this article, we’ll go through
One of the more frustrating errors to occur in VBA is the Automation Error. It can often pop up for no apparent reason despite your code looking perfect. Reasons for This Error There are a variety of reasons that this can occur. Microsoft Office is
With Application.OnTime, you can schedule a macro (a procedure) to run at a specific time in the future. This is especially useful for setting up scheduled tasks which you want your computer to kick-off while you’re away from your computer, such as night jobs. OnTime
The VBA Wait method is used to pause the execution of a macro, suspending all Microsoft Excel activities until a certain time is elapsed. Syntax Application.Wait(time) The function requires one mandatory parameter input of time, which is the time you want the macro to resume,
In this article I will explain how you can export values from an excel worksheet to a new blank Access table. – Step 1: The first step would be to connect to an existing access database or create a new access database. In this example we
In this article I will explain how you can use VBA for Excel to get data from another workbook. – Excel Object Model: In the figure below you can see the basic object model of an Excel application: Application: As you can see at the top of
In this article I will explain how you can use VBA for Word to split a word document every X pages. Each section will be saved in a separate document. – Splitting Every X Pages: In this example the word document will be split every 3 pages.
In this article I will explain how you can open an existing Access database from Excel using VBA. If you wish to only import the data into excel you could use the topic covered in the article below: Excel Connect To External Data (Access Database ) In
In this article I will explain how you can automate an Excel workbook from another application. There are basically two methods for automation: Early binding Late binding I have explained the difference between these two methods when I was explaining about word automation: VBA, Automating
In this article I will explain how you can write data from an excel workbook to a word document. The first step in doing this is to determine where the code is going to be written. There are 3 options: In the excel workbook In the