VBA

6K

Solutions

19

Articles & Videos

2K

Contributors

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Related Topics

  1. Microsoft Excel
  2. Microsoft Access
  3. Microsoft Office
  4. Visual Basic Classic
  5. VB Script
  6. Microsoft Word
  7. Outlook
  8. Microsoft Applications
  9. Programming
  10. Spreadsheets
Refine results

Hi - I need to allocate a colour to each person in my database. It is an Access database with a SQL Server back end.

As I add each new contact to the database, I want to randomly allocate a valid …

321 views
Free Tool: Subnet Calculator
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

This code creates a Word document using automation (from Access).  It works but is not efficient and makes heavy use of Selection (which I would like to get rid of).  

I am looping through 2 …

139 views

Hi
I'd like to create a schedule of 12 records (monthly payments) in the "paymentSchedule" Sheet for each record in the "sales" sheet.
If you add a new record in the sales sheet, excel should append…

1033 views

I have a button called "Open Word" that opens a word doc from my excel sheet.

What I'm requesting is that when you open the word doc that the RFQ number that is on cell B3 populate the Doc Ref # …

232 views

Hi,

I am trying to create a form with 3 search engines, one for each of 3 different tables containing unique Record IDs.  I got the first section of code to work for one of the tables, but on the …

510 views

I have a protected sheet (that emanates from a protected macro-enabled template) that requires the ability to sort.  Even though I have the Sort function checked to allow users to sort, it does not …

514 views

Hello, I have hundreds of Excel files that I need to automatically import to separated Tables of the same Access database.

The Excel files have all the same headers.

The Excel files are inside …

3733 views

I want a macro that asks the user to select a folder, and then to automatically open all the xlsm files in that folder, and copy data from them. The data from the source files are always at the same …

1023 views

I have a spreadsheet that list campaign donations sorted by the organization.  Some organizations have hundreds of rows which makes my loops very inefficient when I have to loop thru an entire …

334 views

Hi, I need the vba code to send an email from Access 2013.  I need to have in the body of the message the ability to insert information from the access database i.e. owner last name, etc.  Also how do…

1226 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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'm running a code that has always worked, but now when I try to run it, it eventually balks, throwing the error you see in the title. Sometimes on the 30th sheet, sometimes on the first. Is it a …

334 views

I need a help. I want to create a subfolder in

SpecialFolders ("A5"). The subfolder name must be ActiveSheet.Range ("B5"). Inside the subfolder the file SaveName = LDate & "_" & Hour(Now) & …

1122 views

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 …

2833 views

Our companies fiscal year starts on the last Sunday in July. Each month starts on the last Sunday of the previous month. I will be given a date and I will have to give the number of weeks in that …

830 views

Hi,

I am running the following code in Excel to delete a record in an Access database, and it suddenly won't recognise docmd.

With docmd
    .SetWarnings (False)
    .RunSQL stSQL
    …

313 views

Hello,
I am using split Form. Presently, on clicking a single filed (Supplier in this example), three list boxes get updated.

Private Sub Supplier_Click()
Call Me.List164.Requery
Call …

515 views

When I send the SQL UPDATE statement below from Excel to Access via ADO I get 'no value given for one or more parameters'.
BUT when I run the query in the Access query window it does not give me that…

814 views

I have several named ranges in a template.  I have built into the template an ability to copy and paste non-contiguous cells from one template to another template (both are the same template, just …

1335 views

I'm a novice and I need some help.
In this existing VBA code I have to add a subfolder in which to store the files.
The subfolder should be = Range ("B 5") .Value
The ready VBA code below creates a…

514 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.

Hello all:
I am creating a vba script in Excel that need to retrieve data based on certain critieria.  What I want to do is to first load the data in an array (or collection) and then be able to …

727 views

I have an Excel Template file that is protected and includes several combo box lists in an excel table format.  In addition, there is extensive code that expert Martin Liss helped me figure out, as …

1021 views

On my ms/access app I want to use the file dialog to let the user select a folder, as I do already have the file name.

I am using this code, recommended  a few years ago by EE.

ublic Function …

533 views

Hi,

I have an application that launches Outlook from Access VBA using the following code:

Shell "C:\Program Files(x86)\Microsoft Office\Office 14\Outlook.exe"

I need for that code to open …

636 views

Need to get familar with Access Basic Coding to solve business rules.  I have a table I need to loop through and bring back records for customers that place multiple orders with 30 days of there …

4470 views

Hi all,

So, I have an Access BE database with tables containing the following fields:

transaction_dtm
create_user
create_dtm
modify_user
modify_dtm

In each table containing the above …

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

VBA

6K

Solutions

19

Articles & Videos

2K

Contributors

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Related Topics

  1. Microsoft Excel
  2. Microsoft Access
  3. Microsoft Office
  4. Visual Basic Classic
  5. VB Script
  6. Microsoft Word