Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite as well as other applications.
I am using DateTime.Now in my Excel Macro to show the current timestamp. It shows timestamp in "dd-MM-yyyy hh:…
excel vbaDoes VBA have dictionary structure? Like key<>value array?
vba dictionary data-structures vb6I have an Excel spreadsheet with three sheets. One of the sheets contains formulas for one of the other sheets. …
excel vba ms-officeHow to get the column number from column name in Excel using Excel macro?
vba excelI'm doing an Excel app that needs a lot data updating from a database, so it takes time. I want …
excel vbaI am new to VBA and I am trying to come up with a way to delete all rows (and …
excel vba excel-2010 excel-2007Possible Duplicate: How to search for string in MS Access VBA array I am currently working on an Excel macro, …
arrays vba substringI am using MS Excel 2010 and trying to get the current directory using the below code, path = ActiveWorkbook.Path But …
excel vbaI'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort …
arrays sorting vba vb6 ms-projectI have an Excel VBA macro which I need to run when accessing the file from a batch file, but …
excel vba batch-file command-line