Including Last row/column functions. http://www.rondebruin.nl/win/s9/win005.htm
Last two days I had a hard time trying to figure out why my vba macro failed to position pictures in cells. My goal was to add pictures of products loaded from external JPG files (previously resized to 64×64) to each row, so user can easily distinguish the product she is working with just by […]
Many thanks to two great blogs RAD Excel and Daily Dose of Excel for covering hard topic on working with array formulas and setting long array formulas for the Range objects in Excel.
This forum post saved my day.I was trying to run Oracle stored procedure with output parameters from Excel VBA with the following piece of code: Dim cmd As ObjectDim resultSet As ObjectSet cmd = CreateObject(“ADODB.Command”)With cmd .CommandText = “PK_AUTH.LOGON” .NamedParameters = True .Parameters.Append .CreateParameter(“login”, adVarChar, adParamInput, 50, login_) .Parameters.Append .CreateParameter(“pass”, adVarChar, adParamInput, 50, pass_) .Parameters.Append […]
Here some prototyping code of a class that is able to connect to Oracle through OleDB and to check if the connection is up before doing some application logic. Class name is TUploadHelper. Private m_conn As ObjectPrivate Function GetConn_() As Object If m_conn Is Nothing Then Set m_conn = CreateObject(“ADODB.Connection”) End If Set GetConn_ = […]