Always remain updated about current software development trends

Articles having tag: VBA

Microsoft Access Application Development Guidelines

By Marco Sorich

Some guidelines for developing better MS Access solutions.

Problem with Microsoft.ACE.OLEDB.12.0 when source file has more than 32k rows

By ajeanson

Solution to my pb:It seems that there is no EOF if they are more than 32K rows.To detect the EOF and exit the 'while' loop I need to check if the data in the excel record set is not null. stillData = True While (Not rsEX.EOF And stillData) If IsNull(rsEX!Date)...

A quick & simple VBA FIFO Queue Implementation

By BorysT

This is an alternative for "A quick & simple VBA FIFO Queue Implementation"

Import Export Wizard

By Sachin Chandanshive

Read / Write data from CSV to Excel

Manage business logic in Access forms

By Torsten Tiedt

Avoid event spaghetti code when business logic becomes complex.

Functors in VBA

By Yiannis Spyridakis

This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.

VBA Extend

By NewPast.Net

Format, add line numbers, error handler and expose some dot Net library to VBA

VBE CreateToolWindow

By sam gerene

Create a custom dockable window in the VBA editor.

Functors in VBA

By codeproject

This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.

Reflection in VBA (a CreateObject() function for VBA classes)

By codeproject

A method for instantiating classes using Reflection.