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
Martin Liss
Keep everyone healthy; Get Vaccinated

Almost 50 years of programming experience. Click '+ More' in 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

byRyan Chong
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

byMartin Liss

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

byMartin Liss
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

byHector2016
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

byJoe Howard
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

byMartin Liss
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

byMartin Liss
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

byJamie Garroch (MVP)
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

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

Array() and Split() performance comparison

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

Range Iteration

byaikimark
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

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

Documenting changes to VB6 or VBA code

byMartin Liss
11
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.

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

How to Time Code

byMartin Liss
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

byltlbearand3
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

byMartin Liss
4
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.
Article

Simple Games

byMartin Liss
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

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more