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.
So I'm having to run someone else's excel app on my PC, and I'm getting "Can't find Project or Library" …
excel vba reference namespacesI have an Excel Workbook that on form button click I want to save a copy of the workbook with …
excel excel-2007 archive save vbaDoes anyone have an Excel VBA function which can return the column letter(s) from a number? For example, entering 100 …
excel vba excel-udfThis is one of those things that I'm sure there's a built-in function for (and I may well have been …
excel vba loops excel-2003The problem is that != does not work as a function in excel vba. I want to be able to use …
excel vba function syntax inequalityI have a column of numbers of over 500 rows. I need to use VBA to check if variable X matches …
excel vba matchingI created a macro for a file and first it was working fine, but today I've been opening and restarting …
excel excel-2010 vbaI am using a While...Wend loop of VBA. Dim count as Integer While True count=count+1 If count = 10 Then …
excel vba while-loopI work in VBA, and want to parse a string eg <PointN xsi:type='typens:PointN' xmlns:xsi='http://…
xml vba parsing xml-parsing