Access 500 community-verified VBA solutions curated by Helen Feddema. From complex Access databases to Outlook integrations, your architectural answer starts here.
Data processing, dynamic reporting, and workbook automation.
Relational database design, SQL integration, and form logic.
Workflow automation, meeting management, and mail triggers.
Template automation, document generation, and formatting.
If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I…
What is the difference between the two. I always thought VBA is somewhat 'crippled' version of VB, but when a friend asked me the other day I had no idea what the actual…
I'm looking for a way to convert xlsx files to csv files in linux, i do not want to use PHP/Perl or anything like that since I'm looking at processing several millions of lines…
I'm generating a CSV file (delimited by commas rather than tabs). My users will most likely open the CSV file in Excel by double clicking it. My data may contain commas and speech…
I have a for loop over an array. What I want to do is test for a certain condition in the loop and skip to the next iteration if true: For i = LBound(Schedule, 1) To…
I need to generate a file for Excel, some of the values in this file contain multiple lines. there's also non-English text in there, so the file has to be Unicode. The file I'm…
The industry standard for JSON conversion and parsing in Excel and Access.
Advanced UI controls and ribbon customization modules for MS Access.
Seamless Outlook-to-Excel data bridge for automated reporting.
Helen Feddema’s reference guide to professional Microsoft Office automation. Build maintainable, enterprise-ready systems.
About Helen FeddemaEvery answer on this site has been peer-reviewed by the global community that ships Microsoft Office automation every day. Nothing is generated; everything is verified.
Data source: Public community Q&A snapshot from Stack Exchange, filtered to peer-verified Microsoft Office automation answers. Content rebuilt and categorized for https://helenfeddema.com/methodology/.