Enter your search terms Submit search form   web www.msofficegurus.com www.excelguru.ca robermartim.spaces.live.com

ÄThis is a list of all tips published on our site

Below is a list of all tips published on our website. If you think the list is too long and you do not have the time to page through them, please use the search on our site to look for more specific tip. a

Total number of tips:  45                                                Total pages served: 15166

	Saturday, May 31, 2008 Paste Excel range into a Word document using VBA  In this tip you learn how to copy a range from Excel and paste into a Word document. This is a very simple process which does not require much technical knowledge.
	(0 of 0 votes)	Views: 161
	Tuesday, May 06, 2008 Attaching files to Outlook email item using VBA  Ever wondered how to attach a file to an Outlook mail item using VBA? This is a nice little piece of code that will do just that without too much complication.
	(2 of 2 votes)	Views: 123
	Wednesday, April 02, 2008 Close an Excel workbook using a timer  This is a cool example if you need to close an Excel workbook after a given period of time. The workbook will be saved and closed when the time set is reached...
	(2 of 2 votes)	Views: 242
	Thursday, February 07, 2008 Uncheck various checkboxes using VBA  You have an invoice or a form in Excel. After various checkboxes have been checked, you need a quick way to uncheck them all... here's how.
	(0 of 0 votes)	Views: 181
	Wednesday, December 26, 2007 Copy and Access Query into an Excel Worksheet using DAO  There are many ways to copy an Access query into an Excel Worksheet. Here we show you how to do that using Data Access Objects (DAO).
	(0 of 0 votes)	Views: 189
	Wednesday, December 19, 2007 Extract only bold text in an Excel cell  As you probably know, you can make part of a text bold in an Excel cell. But what if you wanted to extract only the bold portion of it? You can use a UDF (User Defined Function) to do just that. Here's how...
	(2 of 2 votes)	Views: 193
	Tuesday, December 18, 2007 Delete Windows Folder using VBA  Have you ever needed to delete a folder and its contents using VBA? This tip shows you how this can be done. The first thing you will need to do is...
	(1 of 1 votes)	Views: 142
	Monday, January 16, 2006 Using overtype mode in Excel  This tip shows you how to use the overtype mode in Excel. A simple tip that may go a long way...
	(37 of 52 votes)	Views: 1423
	Wednesday, January 11, 2006 Copying and Moving files using VBA  This tip shows how to use VBA to copy of move files in Windows directories. You can apply this tip to any of the office suite (Word, Excel, Outlook, Access, etc).
	(18 of 23 votes)	Views: 1199
	Monday, November 21, 2005 Getting the hard drive's serial number without API  This tip shows how to retrieve the hard drive's serial number without using API. This tip uses the FileSystem Object to get the job done. You can use this tip with any software of the Office Suite (Excel, Word, Access, PowerPoint, etc.)
	(17 of 17 votes)	Views: 714

The tips are provided "as they are". We take no responsibility for any damage they may cause after improper use.