

Monthly Archives: March 2005

Home >>
Blog >>
Archive: March, 2005

0 To check if a workbook is open, if it’s not open it

This Procedure will ask for a file name to the user, will check if the file is open and if it’s not open it will open the file otherwise give a message to the user. Public Sub IsWorkbookOpen()Dim Wb As Workbook, wkbk As Variant‘get the dialog box to open the filewkbk = Application.GetOpenFilename(“Excel Files,*.xls”)If wkbk […]

0 Super-Easy Guide to the Microsoft Office Excel 2003 Object Model

One more tutorial for VBA beginners. It’s really great, you’d be amazed by the power of VBA and it is very easy to learn. So why wait? start programming right now Super-Easy Guide to the Microsoft Office Excel 2003 Object Model Summary: Learn how easy it is to use the Excel object model to customize […]

0 VBA Samples for Working with Excel 2003 Worksheets

Good VBA examples for beginners at MSDN. VBA Samples for Working with Excel 2003 Worksheets

« Previous 1 2