https://www.developerfusion.com/t/vba/ Latest VBA developer content from Developer Fusion http://www.rssboard.org/rss-specification en-GB Tue, 08 Mar 2011 22:42:16 GMT Excel, 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 master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. *Navigate with ease. Master Excel's tabbed toolbar and its new backstage view *Perform a variety of calculations. http://www.developerfusion.com/book/90951/excel-2010-the-missing-manual/ http://www.developerfusion.com/book/90951/excel-2010-the-missing-manual/ Tue, 08 Mar 2011 22:42:16 GMT Matthew MacDonald Office 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. http://www.developerfusion.com/news/114720/office-2010-and-companions-reach-public-beta/ http://www.developerfusion.com/news/114720/office-2010-and-companions-reach-public-beta/ Tue, 08 Mar 2011 22:42:08 GMT Mike James 10th 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: this is the top all-in-one guide to everything you need to master AutoCAD. Whether you're a novice looking to start with the basics and progress to programming, or an AutoCAD veteran exploring what's new or seeking a quick refresher, every feature is covered. http://www.developerfusion.com/book/77714/autocad-2010-and-autocad-lt-2010-bible/ http://www.developerfusion.com/book/77714/autocad-2010-and-autocad-lt-2010-bible/ Tue, 22 Feb 2011 11:44:47 GMT Ellen Finkelstein The new file format introduced with the 2007 Microsoft Office System opens up many business opportunities. Matt Nicholson finds out who is doing what. http://www.developerfusion.com/article/7573/openxml-open-for-business/ http://www.developerfusion.com/article/7573/openxml-open-for-business/ Wed, 09 Feb 2011 18:18:45 GMT Matt Nicholson As 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. http://www.developerfusion.com/article/7571/inside-open-xml/ http://www.developerfusion.com/article/7571/inside-open-xml/ Wed, 09 Feb 2011 18:18:45 GMT Matt Nicholson Matt Nicholson introduces a range of articles covering the new Ecma Office Open XML standard, as supported by 2007 Microsoft Office system. Find out how Open XML works, how to use it and what you can do with it. http://www.developerfusion.com/article/7570/understanding-open-xml/ http://www.developerfusion.com/article/7570/understanding-open-xml/ Wed, 09 Feb 2011 18:18:45 GMT Matt Nicholson Learn how to read and write Open XML files in the new Microsoft Office 2007, with a particular examination of the Excel file format. http://www.developerfusion.com/article/6170/read-and-write-open-xml-files-ms-office-2007/ http://www.developerfusion.com/article/6170/read-and-write-open-xml-files-ms-office-2007/ Wed, 09 Feb 2011 18:11:48 GMT Zeljko Svedic This is an Access 2003 project file that demonstrates how to do a few cool things with documents. You can grab the project file (zipped) from here: http://www.guardianbob.com/support/public_files/DocumentStorageTest.zip This project will show you how to store and retrieve documents from both an Access table with a BLOB field as well as a SharePoint list (via linked tables and the list web service). http://www.developerfusion.com/code/5658/storing-documents-with-ms-access-sharepoint-lists-or-access-blob-fields/ http://www.developerfusion.com/code/5658/storing-documents-with-ms-access-sharepoint-lists-or-access-blob-fields/ Wed, 09 Feb 2011 18:11:47 GMT Sean Brady This code snippet demonstrates how to open, read and write to excel files. The concept is very simple. Totally aimed at beginners and well commented! http://www.developerfusion.com/code/5322/working-with-excel-files-using-vb6/ http://www.developerfusion.com/code/5322/working-with-excel-files-using-vb6/ Wed, 09 Feb 2011 18:11:46 GMT Adil Hussain Raza Demonstrates how to use the Excel object model to load an excel file and convert it to tab delimited format. http://www.developerfusion.com/code/4405/converting-an-excel-file-to-tab-delimited-format/ http://www.developerfusion.com/code/4405/converting-an-excel-file-to-tab-delimited-format/ Wed, 09 Feb 2011 18:11:45 GMT Vipin Mohandas VB'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. http://www.developerfusion.com/code/4252/a-better-rounding-function/ http://www.developerfusion.com/code/4252/a-better-rounding-function/ Wed, 09 Feb 2011 18:11:44 GMT Luke Lesurf An example of filtering the data displayed in Microsoft Access Forms using VBA. http://www.developerfusion.com/code/2656/form-filter-example/ http://www.developerfusion.com/code/2656/form-filter-example/ Wed, 09 Feb 2011 18:11:43 GMT Thamar Manipulate CorelDraw! layers using VBA http://www.developerfusion.com/article/2657/manipulate-coreldraw-layers/ http://www.developerfusion.com/article/2657/manipulate-coreldraw-layers/ Wed, 09 Feb 2011 18:11:43 GMT Thamar Having 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. when clicking on the name or writing it, the worksheet with that name appears. http://www.developerfusion.com/code/2607/excel-worksheet-searchfind-function/ http://www.developerfusion.com/code/2607/excel-worksheet-searchfind-function/ Wed, 09 Feb 2011 18:11:43 GMT Per A. Bergersen All of us have received at sometime jokes or nice texts by E-Mail. Sadly, they're usualy plagued with starting '>' characters, split sentences, etc... This macro will alloy you to get a more proper text automatically. http://www.developerfusion.com/code/2177/formatting-text-received-in-email/ http://www.developerfusion.com/code/2177/formatting-text-received-in-email/ Wed, 09 Feb 2011 18:11:42 GMT Carlos Ivan Conde Martin Ever wanted to have an instance of Excel appear inside yout MDI app? Here you go http://www.developerfusion.com/code/2185/excel-inside-mdi/ http://www.developerfusion.com/code/2185/excel-inside-mdi/ Wed, 09 Feb 2011 18:11:42 GMT nzjonboy Create a coloured cursor on an Excel Worksheet - enabling you to see where you are in large lists of data. http://www.developerfusion.com/code/2095/excel-coloured-cursor/ http://www.developerfusion.com/code/2095/excel-coloured-cursor/ Wed, 09 Feb 2011 18:11:42 GMT gravitycure Takes a COBOL copybook and calculates Length & Startposition for each field. http://www.developerfusion.com/code/2028/orbit-copybookmanager/ http://www.developerfusion.com/code/2028/orbit-copybookmanager/ Wed, 09 Feb 2011 18:11:42 GMT obetgen Looks through a range of data on an Excel worksheet. Finds a criteria and makes the cells to the right 'Bold' http://www.developerfusion.com/code/1999/make-cells-bold-using-criteria/ http://www.developerfusion.com/code/1999/make-cells-bold-using-criteria/ Wed, 09 Feb 2011 18:11:42 GMT Neil Derek Increments a number on an Excel spreadsheet http://www.developerfusion.com/code/1997/increment-cell-value/ http://www.developerfusion.com/code/1997/increment-cell-value/ Wed, 09 Feb 2011 18:11:41 GMT Neil Derek