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 […]
Continue readingGood VBA examples for beginners at MSDN. VBA Samples for Working with Excel 2003 Worksheets
Continue readingHow to loop through a list of data on a worksheet by using macros in Excel: “How to loop through a list of data on a worksheet by using macros in Excel Article ID:299036 Last Review:September 23, 2004 Revision:1.0 This article was previously published under Q299036 SUMMARY When you write a Microsoft Visual Basic for […]
Continue readingHere’s a IsWorkbookOpen function to check if a workbook is open or not. Returns TRUE or FALSE Public Function IsWorkbookOpen(ByVal wkbkname As String) As Boolean Dim Wb As Workbook ‘check if its already opened in the Windows collection For Each Wb In Workbooks If Wb.Name = wkbkname Then IsWorkbookOpen = True GoTo exitsub End If […]
Continue readingTwo of my colleagues in the office wanted to know how can they change the creation date of a workbook, and I knew there would be some property of the Workbook, which can be accessed thru VBA. So here is the simple sub to get the new creation date and the message boxes will show […]
Continue reading