Search
  • Kalpesh Agrawal

VBA Create Workbook

Introduction of workbook

If you have confusion with Worksheet and Workbook, I am trying to clear it.


Workbook: When you open a new Excel document it is called Workbook. There may be many Workbooks in a single folder. A workbook is an Excel file that contains one or more worksheets.


Worksheet: You open a new Excel Workbook or Excel file, and the page on which you are working is called Active Worksheet. In other words, a Worksheet is a collection of cells where you can keep and work with data.


Create workbook

If you want to create a new Excel Workbook, you can simply Right-click on the screen ➡ go to New ➡ click on Microsoft Excel Worksheet, and a new workbook created on the screen.


If want to do this process multiple times, you can easily do this by VBA code.


You can create an Excel workbook without a name and with a name.


I have been saved the file in G drive, you can save it at any particular location.

Let’s see…


Related: Excel VBA common basic questions
Related: How to Record, Run and Save Macro
Related: How to add VBA to the Excel and common terms of VBA

Written by: Kalpesh Agrawal (Actuarial Intern - IIB)


0 comments

Related Posts

See All