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
Social distance - Don't touch your face - Wash your hands for 20 seconds

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

Troubleshooting Solution

How to edit 2 cell fields in multiple excel files in a folder/subfolders automatically using VBA based on starting name of file

byJoe User
45
How to edit 2 cell fields in multiple excel files in a folder/subfolders automatically using VBA …
Article

Using Regular Expressions in Visual Basic for Applications and Visual Basic 6

byPatrick Matthews
38
Using Regular Expressions in VBA and VB6 Projects

By Patrick Matthews …
Video
Using Automation to Control Excel from Access 4m

Using Automation to Control Excel from Access

byTechMommy
1
Get people started with the process of using Access VBA to control Excel using automation, Microsoft…
Post

Once upon a time at a core conference this …

byCraig Kehler
1
Once upon a time at a core conference this…
Troubleshooting Solution

What is the excel visual basic code to open up a brand new excel application via the Start window?

byf19l
31
I have a spreadsheet that I open up each morning. It contains a macro such that when I run it a …
Troubleshooting Solution

Missing something on the deployment computers.  VB6 and Crystal 11.5

byRalph Green
28
I am a newbie with VB6 and Crystal, so I apologize for my simple question.

I am trying to …
Troubleshooting Solution

vb6 print via notepad

byrjef
36
any idea how I can make this not take focus when run

Private Sub Command1_Click()
Open App.Path …
Troubleshooting Solution

Listview sort and combine

byrjef
31
Working  with a listview in vb6 and i need to convert the below from BEFORE to AFTER
can't seem to …
Troubleshooting Solution

VB6 - Need spell checker in Word to be visible during runtime

byal4629740
30
In the below code, I need to have the spell checker visible when it runs.  The problem is that it …
Troubleshooting Solution

Rename files in a reminder program Q28908876 vb6

byisnoend2001
92
I have reminder rtf files that need renaming from just showing the date to
showing the date and …
Post

Live takes Q&A to the next level, providing an opportunity …

byExperts Exchange
Live takes Q&A to the next level, providing an opportunity for experts to stand out and earn cash. …
Troubleshooting Solution

Add a search function to a vb6 reminder program re Q28910123 using vb6

byisnoend2001
89
i have a reminder program that has a mshflexgrid and want to be able to search the mshflexgrid using…
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.
Troubleshooting Solution

Suddenly getting an error on an Access based program that has been stable for a long time

bydovidf
16
The error that suddenly appeared is  

run time error '3049'

cannot open database 'select from [sorted …
Troubleshooting Solution

search for exact string in a listbox

byal4629740
10
In the following Loop I am highlighting/selecting all the items in the listbox that match the ID …
Troubleshooting Solution

Access 2016 Check Date Is Within Date Range

byBob Collison
11
Hi Experts,
I want to determine if a date [EVENT_FI_TRAN_ADD_DATE] is between two other dates …
Troubleshooting Solution

Spell Check VB6 with MS Word

byal4629740
15
I have a form in VB6 that has a narrative text box in it.  I need to spell check that box whenever a…
Video
Executing a Windows API Function from Access 5m

Executing a Windows API Function from Access

byTechMommy
1
As developers, we are not limited to the functions provided by the VBA language. In addition, we can…
Troubleshooting Solution

converting SQL time format for DTPicker field

byal4629740
11
I have a column in an SQL table with datatype time(7).  When I try to place that value into a VB6 …
Troubleshooting Solution

Comparison of Values between two sheets

bykrishnaswamy velayudham
73
I initially had the code to do the following :
Compare the ranges between between sheet1 and sheet2…

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more