Visual Basic Classic

163K

Solutions

42

Articles & Videos

58K

Contributors

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Related Topics

  1. Microsoft Excel
  2. VB Script
  3. Microsoft Access
  4. .NET Programming
  5. Visual Basic.NET
  6. Microsoft Development
  7. Programming Languages-Other
  8. Programming
  9. Microsoft Office
  10. Microsoft Word
Refine results

Is there VBA code that will convert a mapped file path to a UNC?

Example:

P:\folder 1\myFile.xlsx  

....converts to....

\\server1\group\Public\folder 1\myFile.xlsx

415 views
Free Tool: SSL Checker
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

What I was looking for is to email the WB by selecting the name from a dropdown list and click on a button to send to outlook.

I've attached the WB as an example.  On cell N3 there is a dropdown …

537 views

Hello -

I'm trying to generate a spreadsheet of random data for a presentation.  In sheet1 column A I have a list of unique employee ID's ranging from 1 to 1000 (A2:A1001).  In sheet2 column A I …

325 views

Hello,
I was reading a similar question to mine and being very new to VBA I wondering if I could get some help.

I want to compare two different columns (A,B) on two different sheets (Sheet1, …

537 views

What I'm hoping....

On the Chart Tab I wanted to display everything that is inside the white box, the three charts and words as is on a userform that will be displayed in the Display Tab by …

328 views

After 9 years I am taking up the Access sword again...so please forgive me for asking this if it is an incredibly common and simple question.

I have two global variables (varPart, varDescription) …

424 views

Hi All,

I have a workbook with multiple sheets, i want to copy data from all sheets in to a sheet call Master.

How can i do that, i know there is VBA code available online but that didnt work …

219 views

The Macro c
This Macro works great unless it hits one or more of these three problems

1. The tab with all the data is not named Sheet1 (could this instead be the in focus tab?).
2. There are no …

442 views

Hi

I have just created a new Excel Web Add-in under the Visual Basic section in Visual Studio 2017.
So far I can only see JavaScript used with an xml page. Where is Visual Basic actually used?

968 views

We have a MySQL database we'll call DB1. We now also have a DB2 (with a different name on same server), which replaces DB1. How can I find all references to DB1 in code and behind queries and either …

340 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

i had

the
Private Declare Function timeGetTime Lib "winmm.dll" () As Long
Private Declare Function timeBeginPeriod Lib "winmm.dll" (ByVal uPeriod As Long) As Long
Private Declare Function …

223 views

I received some great help here last week but have hit a stumbling block.  I assumed I could get a text file and pull it in to excel and it would stay lined up. (doesn't seem to be the case) and then …

1343 views

i got this code referred by aikimark from https://gallery.technet.microsoft.com/scriptcenter/191eb207-3a7e-4dbc-884d-5f4498440574

now i want to use this as sub procedure

so that instead of …

430 views

I have a file that has a header record in A1 and a trailer record in it at the end.  The lines between is the data I want to edit that start in Cell A2.  So Header record in A1 then Data in A2 then A3…

249 views

I am migrating to SQL Server 2016 and my VB6 program's connection string won't open the new data base.  Can someone tell me how to modify it so that it opens?  Here is my old connection string:

2451 views

I have an Outlook (2010) Macro that sends emails with certain keywords in them to the "Deleted Items" bin.  What I would like now is an Outlook macro that will move emails having certain key words …

56107 views

I wanted to count the text color of the cells but I applied conditional formatting and the VB code with formula does not allow for it.

Without conditional formatting it works great.  Can the code …

463 views

How can I removed some item from my vb6 components list so I can browse and put them back in from the correct location.

O.S. Windows 10

See attached screen shot

330 views

Hi,
I need your help with below code. I must check all dates in MSHFlexgrid1 col (1) to see if the date is a real date with format "MM/DD/YYYY"

If the date don't exist, it will put in Col(0) the …

2374 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

How can I get the Y value of a line in VBA if I know the X value. I need the value of the line that excel creates because of the curves excel adds when it smoothes the lines between points.

Thank …

2870 views

Hi Experts;
I have an application in VB6 which uses this code to import from a .csv file.

    Set adbMain = New Access.Application
    adbMain.AutomationSecurity = 1 'Set Macro Security to Low
 …

281 views

I'm learning COM DLL. Wrote a COM DLL to display a msgbox in Visual Studio 2003. Build successful. Wrote VB6 and added a reference to the TLB. Put a button and code suggested in the tutorial I was …

652 views

Hi All,

I suspect this would be fairly simple, but I am missing it.  I am simply trying to take a number that is formatted in a time format and changing them all to seconds, so I can work with the …

347 views

I have a classic ASP web app and need some help.  How do I change my code so I can use Parameters?

(CODE)

1660 views

Hi,
I have a spreadsheet where a User keeps track of numbered Jobs.
The current Userform can be updated with more information as Jobs progress.

Is there any way to write back the data in a …

835 views
Show more content
201506-LO-Top-001

Visual Basic Classic

163K

Solutions

42

Articles & Videos

58K

Contributors

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Related Topics

  1. Microsoft Excel
  2. VB Script
  3. Microsoft Access
  4. .NET Programming
  5. Visual Basic.NET
  6. Microsoft Development