Explore VbClassic on Experts Exchange

Expert Solutions for Your Tech Problems

VbClassicVisual Basic Classic

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) pro...

Read more
  • 164K Content
  • 21K Contributors

Expert Spotlight
Protect yourself and your loved ones. Stay home for the holidays.

Over 40 years of programming experience. Expand my "Full Biography" to see links to some articles I've written.

Article

The Effective Way to Find the Last Line Content of a Large Text File

Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate an effective way to find the last line content of a large text file using VBA codes.
Article
My image

The Case for Select Case

As a person who answers a lot of questions, I often see code that could be simplified, made easier

Article

A Game of Draw Poker

2
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Article

VBS script to start Windows Updates installation

1
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Article

Installing Smart Indenter in Office 2013-2016

8
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Article
Eggs in one array

How to store data of different types in the same array

2
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes a way to elegantly solve the problem.
Article
Oh no

A Guide to Writing Understandable and Maintainable VBA Code

14
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Article
Example PowerPoint Add-In

Intercepting Office Ribbon Control Events with VBA using "Repurposing" Commands

3
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Article

MS Access VBA - converting linked tables to local tables

byDon
1
Background
What I'm presenting in this article is the result of 2 conditions in my work area:
Article

Efficient String Clean-up -- Removing Internal Duplicate Spaces

IntroductionI frequently answer questions where strings need to be 'cleaned' of multiple …
Article

Array() and Split() performance comparison

IntroductionOn a recent question, I supplied a simple function to format a number with a …
Article

Range Iteration

5
IntroductionI recently answered a question where the solution involved creating files …
Article

Size and Position Painter Add-In for Excel and PowerPoint - xyPainter

byRavi N
2
Hi,

xyPainter - It is a generic Add-In useful for anybody working extensively on …
Article

An Examination of Visual Basic's Random Number Generation

1
IntroductionWhile training and mentoring a new user with a Microsoft Access application …
Article

Documenting changes to VB6 or VBA code

7
When changes need to be made to code, the easiest thing to do is obviously to just add, change or …
Article

Visual Basic tool for renaming files en masse.

4
Applications concerned with document scanning and archiving, and other automatic file generation …
Article

How to Time Code

2
There is often more than one way to accomplish a particular coding task and one of the criteria that…
Article

The end of a pilgrimage to find a more robust WordWrap function

1
What Started It All
I had an instance recently where I needed to take text from a textbox on…
Article

Using Enums in VB6 and VBA

4
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite …
Article

Simple Games

5
Here are a few simple, working, games that you can use as-is or as the basis for your own games.

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more