Articles related to "Vba"



MS Visual Basic for Applications
Using VBA with Office tools, theory of VB and VBA, and an up to date list of resources available on Suite 101.
vba vb ms microsoft excel

Automating Word and Excel with VBA and VBScript
Programmers can quickly automate Microsoft office applications by using VBA, and when combined with VBScript they have a very powerful tool at their disposal.
vba vbs vbscript microsoft office application automation windows programming word excel programming word document select

Changing Cell Color w/VBA in Excel
This article covers a useful technique for changing cell properties in a range based on the contents of each cell.
microsoft excel vba vb visual basic applications

Create a Word Document with VBA and VBScript
MIcrosoft Word is used throughout the would in thousands of offices to produce millions of reports - many of which can be automating using VBA and VBScript
vba visual basic for applications vbscript programming microsoft office word automation create new word document vba vbscript file system object filesystemobject fso word.appli

Introduction to VBA for MS Word
This article explains how VBA and macros can be used in Microsoft Word to add, modify, and format text.
microsoft word vba visual basic macros ms word

Starting with VBA for MS Excel
Decision based calculations are often at the core of many programming tasks. Combining Excel and Visual Basic for Applications can help to build efficient solutions.
microsoft excel vba vb visual basic applications

Using FIND and MID in Excel VBA
How to use the FIND and MID functions provided by VBA to split text up into pieces for processing by Visual Basic macros using Excel sheets as an example.
using find andmid functions len visual basic vba for excel char

A Computer Program for the Chaos Game
Copying and pasting a few program steps into an Access 2007 report and previewing, generates the self-similar Sierpinski fractal. Then it's a simple matter to experiment.
sierpinski triangle sierpinski gasket sierpinski sieve ms access 2007 vba computer program

Conditional Sum Examples in Excel
Some examples of the conditional sum algorithm that can be used by those with a little programming background
conditional sum excel vba visual basic cell properties

How to Loop in Cell Range in Excel
This Excel VBA programming tutorial article takes the reader through three ways to loop through cell ranges. It covers counted, uncounted and user defined loops.
vba excel loops ranges cells

Microsoft Excel - Change Text to Sentence Case
One function missing from Excel's built-in library is a method to convert text into sentence case. This article contains a simple VBA function for this purpose.
excel function excel formula excel macro excel vba excel convert sentence case

Programming MS Access Applications
An industry application written in Access 2007 is presented for inspection to learn how applications can be made more professional, using macros and VBA programming.
microsoft access 2007 vba programming vba macro programming microsoft office 2007 products access database excel word programming how to access form event procedures

Programming a User Interface in MSAccess 2007
The user interface may contain many object types (text boxes, labels, etc.). Interaction is achieved when objects respond to user events, which then activate programs.
visual basic for applications vba program microsoft access 2007 vba programming microsoft office 2007 products

An Introduction to Microsoft Excel Macros
Excel macros provide an easy method of avoiding repetitive tasks. The built in recording feature enables users to create macros with no prior VBA programming knowledge.
excel macro excel vba visual basic for applications recording an excel macro introduction to macros

Using Microsoft OLE Objects
This article discusses on how you can use OLE objects from a Perl script. This requires familiarity with Microsoft OLE objects and their methods. This will work only on Microsoft Windows operating systems.
perl windows win32 win32::ole ole

How to Concatenate a Range of Cells in Excel
Excel's concatenate function is useful for joining cells. However, it can be time consuming and laborious if joining numerous cells or when joining cells and a delimiter.
concatenate concatenate excel excel vba function excel range excel cell

Learn to Program with BBC BASIC
This article explains why BBC BASIC is a good learning language, which BBC BASIC to choose, programming, and a starter set of links to programming articles.
programming bbc basic learning to program how to program coding

Computer Security Weekly, July 24, 2000
July 24, 2000, This week's events in computer security, both on and off the net.
computer security network internet virus

AutoCAD Viruses
ACAD Virus Alert, Automated Scripting, Animated Accurender, A2k Change Pervious LISP
autocad cad drafting drawing architect

Using Macros in MS Office 2007
Macros are available across the full range of MS Office 2007 products. Described are ease of learning, writing and running macros, and security risks.
microsoft office 2007 macros ms office 2007products ms access word excel project visio record a series of actions write a macro to achieve a task

Even More Totaly Cool ACAD Links!
LISP's, the beginning of Autodesk, and more!
lisp acad cad autocad drafting

Computer Security Weekly, July 3, 2000
July 3, 2000, This week's events in computer security, both on and off the net.
computer security network internet virus

Computer Security Weekly, Sep.10. 2000
Sep. 10, 2000, This week's events in computer security, both on and off the net.
computer security network internet virus

Microsoft HTML Help Workshop (HHW)
HHW is a free documentation project for producing an external Help module, which can be called from the main program application or from any MS Office product.
microsoft html help workshop user documentation help for desktop applications hhw interface compiling the help executable

OpenOffice Macros: Accessing Calc Cells
This tutorial shows how to do one of the most important things that an OpenOffice Calc macro must do - reading from (and writing to) cells.
openoffice calc macros macro to access cells thiscomponent getcellbyposition getcellrangebyname

Spreadsheet Formula to Count Words in Cell
This Excel / Calc formula tutorial article is designed to help spreadsheet users create formulas to count words in cells, or characters in cells, without using macros.
excel formula help calc formula help excel formula count words count words in cell count characters in cell

Sources of Inspiration 3
Just some ideas to help you think about new pieces of art.
imagination common thought catharsis art

More for Less?
autocad acad cad drafting lt97

What to Do When You Lose Your Job
Thousands of older individuals, throughout America, have had dramatic life changes due to unemployment. Knowledge is the tool they require.
what to do when you lose your job over 50 and unemployed displaced older workers call center in india job retraining


| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | 0-9 |