Create a macro for an ActiveX control

Create a macro for an ActiveX control

1. On the View menu, point to Toolbars, and then click Control Toolbox.

2. Select the ActiveX control (ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.) you want to create a macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) for, and then in the Control Toolbox, click View Code Button image.

3. In Microsoft Visual Basic Editor (Microsoft Visual Basic Editor: An environment in which you can edit macros that you've recorded and write new macros and Visual Basic for Applications programs.), write a new macro or change the existing macro.

4. When you finish writing the macro, on the File menu, click Close and Return to Microsoft PowerPoint.

For more info: http://office.microsoft.com/en-us/powerpoint-help/create-a-macro-for-an-activex-control-HP003089064.aspx

How to Open ODT With MS Office 2003

The ODT document format is one of the formats used by the free, open-source word processor OpenOffice Writer. While OpenOffice is by default compatible with Microsoft Office formats like DOC, a standard install of Microsoft Word cannot open ODT files. Fortunately, a free download exists to add experimental OpenOffice format support to MS Office--although for full, guaranteed support of the ODT format, you can always download and install OpenOffice itself.

Instructions

Download and install the prerequisites for the OpenOffice compatibility add-in. These are the Microsoft Office Compatibility Pack and the .NET Compact Framework 2.0 Service Pack 1, both linked from "Resources."


Download and install the OpenOffice compatibility add-in from the final link in "Resources." Click the download link corresponding with the language your installation of Office uses.

Open MS Word normally and use the "Open" dialog to select and open an ODT file.


Read more: http://goo.gl/EU9pd

Convert Excel to Access Keep Formulas

If you want to use Access while keeping the formulas of Excel, then linking to data in Excel is a good option. Linking to data in Excel from Access allows you to use the database tools of Access while keeping the data and formulas entered in Excel. While you can't edit the source files in Access, the data automatically changes when edited in Excel. You also don't need to maintain a copy of Excel in the Access database, which can be a hassle.

Instructions

Find the Excel file and worksheet that you want to link to Access.

Open the Excel file and prepare the data. Data has to be specifically formatted to link to Access and the procedures vary according to what types of data you are linking. Review the Microsoft Office Support guidelines if you're unsure how to format the data (see Reference).

Open the Access database where you want to create the link to Access. Make sure it is not a read-only database by checking that you can make changes. Read-only databases will say "Read-Only" at the top of the database.

Click on the "External Data" tab located at the top of the Access database. Under "Import," click on "Excel" and navigate to "Get External Data--Excel Spreadsheet."


Locate the Excel spreadsheet by browsing for the file on your computer. Select the file and then select "Link to the data source by creating a linked table." After you click "OK," the Link Spreadsheet Wizard will automatically start.


Select the worksheet that you want to link to in the wizard. Choose "First Row Contains Column Headings" to name the fields in the table in Access. Click "OK" to complete the action.

Type in a name for the linked table when prompted in the wizard. Then click on "Finish."


Read more: http://goo.gl/J43KN

How to Find a Temporary File in MS Office ?

Recovering temporary files after you have closed, lost or accidentally deleted files in Microsoft Office programs such as Word, Excel or PowerPoint is a pretty easy feat. It can be aggravating to have to go back and find the files, but luckily Microsoft does save temporary copies of every file you create on a Temporary File Folder on the hard drive of the computer. You should try to save your files as frequently as possible so files can more easily be recovered.

Instructions

Finding the File

To recover files using Windows Vista or Windows 7 click, "Start". In the "Search Box" type ".tmp". Press, "Enter". There should be a show-only toolbar that pops up. Click, "Other". Scroll down the files for the file name that matches the one you are searching for. Look at the dates and times you edited the document and choose the last one or the one before and you should find the document you need, according to Microsoft Support.

If you are working with Windows XP, click "Start" then select "Search." "Click For "Files" and type, ".tmp" into the box. "Click on My Computer" when it asks which part of your computer it should look for the files in. Click under "Search Options," and select the date of the file you are looking for. Select "Search." Under the "View menu," select "Details." View the files by date and pull up the last copy of the document you are searching for.

In any Windows Microsoft Word Program, it will store recent temporary files. If you go to "Open" and then click "recent files" the file name you are looking for may be right there. If you click on it, it should bring back the file with the last save that you did.

If you have a Mac you can find the files from the link that is created under recent link. Or you can go under "Finder" and do a search for the file under the name created or scroll down until you see the file you were looking for. A temporary file will be stored in the Temp folder.

Read more: http://goo.gl/DoXQa

How to Add a Password to Microsoft Office Products

There are many reasons to secure your Microsoft Office files. For instance, if you intend on sharing your documents, you may want to prevent them from being changed. Protecting your documents from accidental modification can prevent issues of damaged work, especially with memos and important presentations. If you have confidential Office documents, you may want to prevent people from accessing them. Protecting the confidentiality of certain documents ensures that important client information or personal data cannot be accessed by other people.

Instructions

Adding a Password to Office 2003 Files

Click "Start" from the task bar and then select "All Programs."

Select "Microsoft Office" from the list and then choose the program you desire.

Open the document(s) in which you want to add a password from the "File" menu.

Click "File," Save As," "Tools" and then "General Options."

Select the level of protection you desire. For example, if you want to prevent file opening, type a password into the "Password to open" option. If you want to prevent changes to the document, type a password into the "Password to modify" area.

Re-enter the password into the appropriate box for the option that you chose and then click "OK."

Read more: http://goo.gl/yZHvR

Problems With Microsoft Office Professional

Microsoft Office Professional is a widely used application suite that provides users with word processing, spreadsheets, desktop publishing and more, all within one set of programs. It is used by millions of people worldwide, and although it is extremely powerful, users can encounter problems. Fortunately, some of the most common problems can be solved quickly and easily, provided you have some basic information about how to do

Identification

Problems with Microsoft Office Professional can come in varying forms. Some errors may show up in pop-ups, and some may manifest as unexpected behavior as the application is used in normal situations.

Turn On Automatic Spelling and Grammar Checking

If your copy of Microsoft Office Professional is not automatically performing spelling and grammar checking, you can turn this feature on with just a few simple steps. Open the Options menu (found under the Edit drop-down on the toolbar), and under the Proofing section, check the boxes for "Check spelling as you type" and "Check grammar as you type."

Activation Problems

If you are having trouble activating your copy of Microsoft Office Professional, the first thing to check is your product key. Ensure that you are entering your product key correctly, and that you have not missed or transposed any characters. If you still have trouble, try using the telephone activation option that is available from within the activation manager. Finally, check the version of the software you are installing. If you are trying to install an OEM version of Microsoft Office Professional on more than one computer, you will receive an error, since the OEM version can only be registered to one computer.

Unable to Find Product Key

Before contacting Microsoft to get a replacement product key, you should first verify that you are actually missing the product key, and that you are not overlooking it, nor that it may have fallen off of the box or CD case. The product key consists of 25 characters (letters and numbers), and it is generally divided into five groups of characters, separated by dashes. Depending on the version of Microsoft Office Professional that you purchased, it may be located on a yellow sticker on the inside of the box that you purchased, or on a white sticker on the back of the CD case.


Read more: http://goo.gl/KCRrv

How to recover lost MS Office password safely

Microsoft Office, a suite of office software developed by Microsoft, is not strange for us. As long as you are a computer user, you'll involve in Office documents, such as Word processor, Excel spreadsheet, PowerPoint presentation or Publisher. The MS Office is widely used in various industries all over the world.

Just because of the popularity of MS Office and even a computer novice can control the whole process well, which marks we should attach much security and privacy awareness to them. So in order to protect our MS Office document, we should set a password on it, which will prevent Illegal users from opening or editing the individual privacy data.

With so flexible and complex the password, you really can protect your Office document, but sometimes the problem probably comes that if you forgot MS Office password you have set. Especially when it's time for you presentation work or for an important school project. Unfortunately Microsoft Office itself can't help you recover your password. This can be a stressful situation, so it must be a very difficult situation.

To solve such tragic situation, a plenty of technicians have been devoting their energy to MS Office Password Recovery solution since Version of MS Office 97 released by Microsoft. However, it is extremely hard to settle such a tough situation, because the computer users are more and more incline to set the complicated passwords mixed with numbers, characters and specific symbols. So, it will cost must much time to recover a lost MS Office password.

Fortunately, the third party software can give you a hand, these kinds of software supply three kinds of attack solutions, there are brute-force attack, brute-force with mask attack and dictionary attack. Here just a few steps to recover your MS Office password and use your important documents. Simply deep breathe and try a few of the following ways to recover your password.

* Choose three methods of recovering your lost password. Use Brute Force Attack, brute-force with mask attack or Dictionary Attack to crack passwords in Microsoft Office. Dictionary Attack is a commonly used program, while Brute Force Attack tracks complicated passwords with numbers and connotations. We recommend you to choose brute-force with mask attack which can restrict the search scopes.

* Decide on a password-recovery tool. Examples of programs include Elcomsoft, Rixler and Office password recovery 5.0. Some of these programs are available to you for little to no cost. They recover passwords not only from Microsoft Office but from other types of programs. But I recommend you use Office password recovery 5.0, because of its all-in-one password recovery solution for recovering all types of lost or forgotten passwords for Microsoft Word documents, Microsoft Excel spreadsheets, Microsoft Access databases, Microsoft PowerPoint presentations and Personal Storage Files (*.pst file).

* Download the password-recovery program of your choice. Follow the prompts for installing the software onto your computer. The program should start up automatically once you open the software.

* Follow the directions for recovering your password. Inform the program of which program you want to recover your password from.

* Write down your password. Even though you recovered your password, you may want to keep it in a safe place so you can easily retrieve it. This way you do not need to use the password-recovery software if you forget it again.

Article Source: http://goarticles.com/article/How-to-recover-lost-MS-Office-password-safely/3314423/