Macro (SVB) Programs Example - Customizing Workbooks
Some examples of how to move individual graphs or spreadsheets into
a workbook are presented in Accessing
Multiple Modules in a Single Program and Opening
and Saving Spreadsheets, Graphs. The Workbook
object
contains a number of properties
and methods
to edit and customize the appearance and layout of items. Here is an example:
' This program creates a new Workbook;
a new
' Folder is then created in the Workbook, and
' named; then a new empty Spreadsheet is
' placed in the Folder, and named.
Sub Main
' declare the Variables: a Workbook, a Workbook
' item to which we will assign a new Spreadsheet,
' and a Workbook item, to which we will assign a
' new Folder
Dim NewWBook As Workbook
Dim NewItem
As WorkbookItem
Dim NewFolder
As WorkbookItem
' Create
the new Workbook
Set NewWBook=Workbooks.New
' Make
it visible
NewWBook.Visible=True
' Create
a new Spreadsheet
Set NewSSheet=Spreadsheets.New
' Create
a new folder, inside the new Workbook
Set NewFolder=NewWBook.InsertFolder(NewWBook.Root,scWorkbookFirstChild)
' Assign
a name to the new folder
NewFolder.Name="New Workbook Folder"
' Insert
the new Spreadsheet into the Workbook, inside
' the new Folder
Set NewItem=NewWBook.InsertObject(NewSSheet, NewFolder, )
' Name
the new Workbook item (Spreadsheet)
NewItem.Name="This is a new Spreadsheet in the Folder"
End Sub
After running this program, the tree structure for the newly created
workbook will look like this:

Again, the workbook can be customized by applying
the methods and setting the properties associated with this object. The
Object
Browser will provide a complete listing of these methods and
properties.