Library code snippets tagged with vba

• Storing Documents with MS Access - SharePoint lists or Access BLOB fields

  by Sean Brady

  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). vba, sharepoint

• Working with Excel Files Using VB6

  by Adil Hussain Raza

  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! visual basic, vba

• Converting an Excel file to Tab Delimited Format

  by Vipin Mohandas

  Demonstrates how to use the Excel object model to load an excel file and convert it to tab delimited format. vba

• A better rounding function

  by Luke Lesurf

  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. visual basic, vba

• Form filter example

  by tlosekoot

  An example of filtering the data displayed in Microsoft Access Forms using VBA. vba, db

• Excel worksheet search/find function

  by Per A. Bergersen

  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. vba

• Formatting text received in E-Mail

  by Carlos Ivan Conde Martin

  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. vba

• Excel inside MDI

  by nzjonboy

  Ever wanted to have an instance of Excel appear inside yout MDI app? Here you go visual basic, vba

• Excel Coloured Cursor

  by Gravitycure

  Create a coloured cursor on an Excel Worksheet - enabling you to see where you are in large lists of data. vba

• Browse For Folder VBA

  by Mike J

  Demonstrates how to display a Browser For Folder dialog. Please note that this source sample is for VBA only. Not VB. vba

• ORBIT CopyBook-manager

  by obetgen

  Takes a COBOL copybook and calculates Length & Startposition for each field. vba

• ORBIT FileManager

  by obetgen

  MSAccess application which lets you move, copy, delete and rename files. vba

• Make cells bold using criteria

  by Neil Derek

  Looks through a range of data on an Excel worksheet. Finds a criteria and makes the cells to the right 'Bold' vba

• Increment Cell Value

  by Neil Derek

  Increments a number on an Excel spreadsheet vba

• Delete Selected Files

  by Neil Derek

  Deletes selected Excel files from a batch. vba

• Adding a Find Button to an Excel Worksheet

  by Gravitycure

  Place a 'Find' button on an Excel Worksheet, which finds the text in a given text box. vba

• Reading Text File and Export To Excel

  by gigsvoo

  How to read a text file, and then export it to Microsoft Excel vba

• Clearing tables in Access

  by tlosekoot

  How to erase the contents of a table in Access vba

• Turn off warning messages in MS Office applications

  by ElementK Journals

  How to programmatically turn off warning messages in MS Office applications when using Office Automation vba