VBA Samples for Working with Excel 2003 Worksheets
Good VBA examples for beginners at MSDN. VBA Samples for Working with Excel 2003 Worksheets
Continue reading
- Home
- Blog
How 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: “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 reading1 Isworksheetopen and Isworkbookopen functions
Here’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 readingChange the creation date of a workbook
Two 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 reading2 Importing IE bookmark
Steps to get your bookmarks in a database format First way: Open Excel>Data>Import External Data>New Web QueryPaste the address of your bookmark on your hardisk in the web query addressSelect the tableImport it to ExcelYou’ll see first column has all the addresses of the links, and after few columns the text for that hyperlinkPress Ctrl […]
Continue reading