MS Office Gurus: Where Office Developers Meet
 
Home
Artigos
Fóruns
Links
Dicas
Desafios
Notícias
Access
Excel
FrontPage
Outlook
Word
Office books
 
 
 

 
 
 
 
 
 
 
 
 

Google
 
Middle
Ä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: 13539

  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: 19
 

 
  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: 35
 

 
  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...
  (1 of 1 votes)            Views: 105
 

 
  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: 140
 

 
  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: 147
 

 
  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: 156
 

 
  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: 106
 

 
  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: 1377
 

 
  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: 1146
 

 
  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: 665
 

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



 

 

  Right
Artigos: 2
Links Notícias: 73
Links de Dicas: 11
Dicas dos Gurus: 45
Casos: 0
Visitantes ativos : 7

Robert Martim
 
 

 

 
 
       
         
    footer

www.msofficegurus.com © 2005-2008 Todos os direitos reservados.
Este site é mantido por Robert Friedrick Martim
Este site não está de FORMA ALGUMA relacionado a Microsoft Corporation ou qualquer outra empresa cujas tecnologias são discutidas neste site our fóruns.

Termos & Condições | Privacidade |Sobre o Autor |Assuntos Diversos