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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Just some ideas to help you think about new pieces of art.
imagination • common • thought • catharsis • art
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
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 |