VBA

5K

Solutions

18

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. Visual Basic Classic
  4. Microsoft Office
  5. VB Script
  6. Microsoft Word
  7. Outlook
  8. Microsoft Applications
  9. Programming
  10. Spreadsheets
Refine results

I had this question after viewing Export CSV from Excel and exclude rows based on cell value …

421 views
Free Tool: Path Explorer
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

I am looking for a formula to put the "status" of a project from the worksheet Matrix (2) in the right row of the reference table (1). I tried index match but could not solve the problem.

In the ws…

613 views

Every where I`ve researched I just find how to save files in a different format, would someone be able to assist me to fix the following code?

(CODE)


I want to save a new file whit out closing…

5030 views

I have a worksheet with multiple sheets within. In column A (RUP) of sheet 1 I have check boxes (which aren't working). I need all of the data in each row from the main sheet to copy to the RUP sheet …

319 views

I have a daily routine that involves downloading a list that I need the cell contents of several columns to be populated into a comment for the cell in column A for the same row -- but also have the …

811 views

Hello everyone.
Please I really need help.
I have a matrix that I want to square (multiplying it by itself).
and then I'm gonna add the value of each row of this matrix, and then add the value of …

1640 views

I have three forms.
A, B, C On which all the field names are standard
I have a second form (NOINE) which I would only like to code once.
When A is open and I push a button I want NOINE to open and …

1614 views

I need a vba loop to remove all instances of these shapes.
There are multiple, and for some reason and this code only removes one, not all.
I need to loop through until there are no more.


410 views

Hey all - Looking for ideas on how to accomplish this.  I have the table below in Access.  For every location I need to create a records in a table equal to the value of source count.  The table below…

410 views

I am trying to change shapes using VBA, but getting error on the  With Selection.Shapes("ARROW_US_EMEA_DC").
Can anyone help?

(CODE)

610 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 have an MS Access application that prints to file and then sends the file to the IP address of the Intermec PC43d label printer that the user chooses.  On the user's computer the printer is …

619 views

I NEED TRANFER A BIG DATA COLUMN

LIKE THIS SAMPLE   ANY HELP ??

721 views

Hi,

A few years ago I put the following code together which connected to an SQL server on my network and returned a list of available databases on that server.  I have returned to this project to …

1025 views

Hi,

I have the following code

(CODE)

I have a form with two fields (From & To) dates.  I am trying to filter the report to display only the records between the two dates.  What is wrong with…

1042 views

I have an access based file monitor app that basically scans folder sizes to see if they have increased after x seconds (set by form timer property).  Each folder being scanned is being filled with …

826 views

I need to add a button that, if clicked, will
copy C2:G2 to the next empty line line.
then copies MOVES VIA, COUNTRY & CONSIGNEE into the new line.


314 views

I have been given a text file which I need to place the data into a MySQL table, Excel or Even Access.

The text file contains:
A | win
B | howdy
C | go home
D | have lunch
A | happy
B | sad

1236 views

I have a daily routine that involves downloading a list that I need the cell contents of column H (BRKR) and column I (CUSIP) to be populated into a comment for the cell in column A for the same row. …

614 views

Attached is a Workbook where Column B (Table1 Worksheet) is filtered and the results for Col A can be recorded in P1, Q1, R1, etc.  Currently, it's a bit of a work around to display the values of Col …

2119 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Programming in PowerPoint 2010 VBA, an automatic bio slide maker.  The user selects up to 6 bios from a picklist, then the macro inserts photos and text elements.  Name, title, and bio text for each …

835 views

I have VBA that will create an email when you click the generate email button. However, I have tried to make it pop up but it is inconsistent. How do I make this window pop up in front of any window …

312 views

Access 2010 vba

After i record has been posted in a form.
I'm using this api call to bring upa popup form that goes away after 1 sec...

I want to get rid of the  "OK" that is displayed on the …

319 views

I'm looking for a code in Excel that computers Fibonacci results using two numbers then finding the greatest common factor between the two.   For example, if I typed in 13 in A1 and 17 in A2, the …

713 views

In Microsoft Access, I want to "read" a Microsoft Word document that was created through a Mail Merge and split it into as many documents as there are pages. I would like to name each document based …

1512 views

Hi every one, I hope this can be done, I have this code below I need to update it so it saves the excel file but with PASSWORD.

Function ExsTexl()
Dim OutputFileName As String  
OutputFileName =…

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

VBA

5K

Solutions

18

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. Visual Basic Classic
  4. Microsoft Office
  5. VB Script
  6. Microsoft Word