In Attach Current Workbook to Current Email Doug Glancy has some VBA code to attach the current workbook to an open email (using the Outlook object model). It's early bound, but it is simple to convert it to late bound.
Continue Reading »
workbook
Add and return Excel.Worksheet references in VBA
The Workbooks.Open Method creates a new workbook, adds it to the Workbooks Collection, and returns a Workbook Object which can be set to an object reference. i.e.
Sub TestWorkbookAdd() Dim wkbks As Excel.Workbooks Dim wkbk As Excel.Workbook Set wkbks = Excel.Workbooks Set wkbk = wkbks.Add End Sub
From Excel Help:
Creates a new workbook. The new workbook becomes the active workbook. Returns a Workbook object.
True Performance Improvements in Excel 2010?
In More on Performance Improvements in Excel 2010, Excel Program Manager Joseph Chirilov writes about improved performance in Excel 2010 over 2007.
According to Chirilov, Excel 2010 has made improvements in the following areas:
- Large Data Set Performance
- Calculation Performance
- Multi-core functionality
More ways to reference Excel workbooks and sheets using VBA
Susan Harkins writes a column for TechRepublic with Office tips, including VBA code samples. In 10 ways to reference Excel workbooks and sheets using VBA, she posts a few methods for manipulating worksheets and workbooks through Excel VBA. I'd like to expand on a few of her samples.
Follow Me