Learn VBA Programming
-
Excel 2010: The Missing Manual
BookExcel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less ma
10 years ago by Matthew MacDonald
-
Office 2010 and companions reach public beta
NewsOffice 2010, SharePoint Server 2010, Visio 2010, Project 2010, Office Mobile 2010 and Office Web Apps for business customers have all been released as public betas.
11 years ago by Mike James
-
AutoCAD 2010 and AutoCAD LT 2010 Bible
Book10th anniversary edition of the bestselling AutoCAD BibleEven AutoCAD developers turn to this book for answers!Find out what fans of all the previous bestselling editions of this book already know: th
11 years ago by Ellen Finkelstein
-
OpenXML - Open for business
ArticleThe new file format introduced with the 2007 Microsoft Office System opens up many business opportunities. Matt Nicholson finds out who is doing what.
13 years ago by Matt Nicholson
-
Inside Open XML
ArticleAs Matt Nicholson explains, Open XML is not just a new file format for the latest version of Microsoft Office, but an open standard capable of expressing any Word, Excel or PowerPoint document.
13 years ago by Matt Nicholson
-
Understanding Open XML
ArticleMatt Nicholson introduces a range of articles covering the new Ecma Office Open XML standard, as supported by 2007 Microsoft Office system.
13 years ago by Matt Nicholson
-
Read and write Open XML files (MS Office 2007)
ArticleLearn how to read and write Open XML files in the new Microsoft Office 2007, with a particular examination of the Excel file format.
14 years ago by Zeljko Svedic
-
Storing Documents with MS Access - SharePoint lists or Access BLOB fields
CodeThis is an Access 2003 project file that demonstrates how to do a few cool things with documents. You can grab the project file (zipped)
14 years ago by Sean Brady
-
Working with Excel Files Using VB6
CodeThis code snippet demonstrates how to open, read and write to excel files. The concept is very simple. Totally aimed at beginners and well commented!
15 years ago by Adil Hussain Raza
-
Converting an Excel file to Tab Delimited Format
CodeDemonstrates how to use the Excel object model to load an excel file and convert it to tab delimited format.
17 years ago by Vipin Mohandas
-
A better rounding function
CodeVB's built in round function will round numbers like 12.085 down to 12.08. This is not correct in all cases as this number should be rounded up to 12.09. This round function allows for this.
17 years ago by Luke Lesurf
-
Form filter example
CodeAn example of filtering the data displayed in Microsoft Access Forms using VBA.
18 years ago by Thamar
-
Manipulate CorelDraw layers
ArticleManipulate CorelDraw! layers using VBA
18 years ago by Thamar
-
Excel worksheet search/find function
CodeHaving problems with finding the right worksheet? This code makes it easier find what you are looking for. The search criteria is the worksheet names that is put into a combobox automatically.
18 years ago by Per A. Bergersen
-
Formatting text received in E-Mail
CodeAll of us have received at sometime jokes or nice texts by E-Mail. Sadly, they're usualy plagued with starting '>' characters, split sentences, etc.
18 years ago by Carlos Ivan Conde Martin
-
Excel inside MDI
CodeEver wanted to have an instance of Excel appear inside yout MDI app? Here you go
18 years ago by nzjonboy
-
Excel Coloured Cursor
CodeCreate a coloured cursor on an Excel Worksheet - enabling you to see where you are in large lists of data.
18 years ago by gravitycure
-
ORBIT CopyBook-manager
CodeTakes a COBOL copybook and calculates Length & Startposition for each field.
19 years ago by obetgen
-
Make cells bold using criteria
CodeLooks through a range of data on an Excel worksheet. Finds a criteria and makes the cells to the right 'Bold
19 years ago by Neil Derek
-
Increment Cell Value
CodeIncrements a number on an Excel spreadsheet
19 years ago by Neil Derek
Jobs
-
VBA / Access / Excel Developer – Central London
Fruitful Business Services in London (EC1V), United Kingdom
£23-45k (DOE)
Discussion
-
Problem with printer...new computuer
1 year ago by jhonbrighton11 (12 replies)
-
Calling C++ from VBA
9 years ago by tsunadesama11 (0 replies)
-
Excel rows removal, if not bewteen two given dates.
9 years ago by ptjohn1980 (0 replies)
-
How to set ListView table with Horizontal scroll
9 years ago by New Commer (0 replies)
-
marking asstitant
9 years ago by sholajah (0 replies)
-
VBA cursor color problem (excel)
9 years ago by rylee_pds_pdms (0 replies)
-
Need profesional help on kinect sdk
9 years ago by ckmjyx (1 replies)
-
Connecting to SQL
9 years ago by sathishkumar1 (0 replies)
-
Visual Studio 2008 - Report Layout
9 years ago by zorrs.fanai (1 replies)
-
Recorded Excel macro not working
10 years ago by ruthyang (1 replies)