A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Please see my completed XLSM document, screenshot of the results, separate VBA script file, and README file found in the linked GitHub repository above. StockMarketAnalysis Macro This macro performs a ...

Yearly change from the opening price at the beginning of a given year to the closing price at the end of that year. The percentage change from the opening price at the beginning of a given year to the ...

I have a table that is populated from a database. I want to populate some cells of the table with images instead of the text gathered from the query. When I run the page, every thing works fine but ...

Public Sub SendKeys(ByVal Keys As String, Optional Wait As Boolean = False) Dim wsh As Object ' Only mess with shell object under constraint. If (IsVista() = True) And (Compiled() = False) Then ' ...

at work, i made up a vbs file that serves as our login script. it basically just maps various network drives. some are defaulot for everybody, and others are decided by simple if/then statements based ...