https://www.developerfusion.com/t/vba/code/ VBA Sample code from Developer Fusion http://www.rssboard.org/rss-specification en-GB Wed, 03 May 2006 20:01:00 GMT 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, 03 May 2006 20:01:00 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, 01 Feb 2006 00:49:00 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/ Sat, 07 Feb 2004 18:13:00 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/ Fri, 02 Jan 2004 06:05:00 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, 11 Sep 2002 04:51:00 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/ Fri, 28 Jun 2002 10:48:00 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/ Mon, 01 Apr 2002 01:43:00 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/ Fri, 29 Mar 2002 19:34:00 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, 13 Mar 2002 08:40:00 GMT gravitycure Demonstrates how to display a Browser For Folder dialog. Please note that this source sample is for VBA only. Not VB. http://www.developerfusion.com/code/2127/browse-for-folder-vba/ http://www.developerfusion.com/code/2127/browse-for-folder-vba/ Wed, 13 Mar 2002 08:38:00 GMT Mike J 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/ Sat, 09 Mar 2002 10:40:00 GMT obetgen MSAccess application which lets you move, copy, delete and rename files. http://www.developerfusion.com/code/2027/orbit-filemanager/ http://www.developerfusion.com/code/2027/orbit-filemanager/ Sat, 09 Mar 2002 10:39:00 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/ Tue, 26 Feb 2002 15:55:00 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/ Sat, 23 Feb 2002 12:27:00 GMT Neil Derek Deletes selected Excel files from a batch. http://www.developerfusion.com/code/1996/delete-selected-files/ http://www.developerfusion.com/code/1996/delete-selected-files/ Fri, 22 Feb 2002 09:08:00 GMT Neil Derek Place a 'Find' button on an Excel Worksheet, which finds the text in a given text box. http://www.developerfusion.com/code/1998/adding-a-find-button-to-an-excel-worksheet/ http://www.developerfusion.com/code/1998/adding-a-find-button-to-an-excel-worksheet/ Tue, 08 Jan 2002 15:18:00 GMT gravitycure Last submission I showed you how to connect to your EU's ISP or DUN, now this bit of code will show you how to detect an active connection using the WinInet API. http://www.developerfusion.com/code/1925/check-for-activeconnection-via-wininet/ http://www.developerfusion.com/code/1925/check-for-activeconnection-via-wininet/ Fri, 30 Nov 2001 01:01:00 GMT Thushan Fernando How to read a text file, and then export it to Microsoft Excel http://www.developerfusion.com/code/1897/reading-text-file-and-export-to-excel/ http://www.developerfusion.com/code/1897/reading-text-file-and-export-to-excel/ Fri, 16 Nov 2001 11:17:00 GMT gigsv00 How to erase the contents of a table in Access http://www.developerfusion.com/code/1669/clearing-tables-in-access/ http://www.developerfusion.com/code/1669/clearing-tables-in-access/ Sat, 29 Sep 2001 13:45:00 GMT Thamar Entering parameters into a DAO parameter query http://www.developerfusion.com/code/111/parameters-in-a-dao-parameter-query/ http://www.developerfusion.com/code/111/parameters-in-a-dao-parameter-query/ Sat, 14 Jul 2001 14:48:00 GMT ElementK Journals