Finally! The new macro is working as intended. Now, you want to email the macro to someone you know. However, the macro is embedded in the document, which you do not wish to send. Macros can be exported and imported independent of the document.
For that, start the command ‘Tools | Macro | Macros’.
Select the desired macro in the list and then click on ‘Create’.
In the Visual Basic-Editor, now open ‘File | Export file’ in the menu.
For sending through email, it is practical, to change the ‘File type’ to ‘All Files’ first and then entering a name in the field ‘File name’ such as ‘My-Macro.txt’.
If required, change the destination folder and then click on ‘Save’.
Apparently, the auto correct function is supposed to work for all Office components.
However, that does not seem to be working for your Office packet. Word has special treatment and behind the curtains, differentiates between two diff erent types of entries. The reason: Word also saves formatting.
So, if you have used the auto correct function in Word till now, the other programs have not benefited from it. You can verify this using ‘Tools | auto correct options’. Activate the ‘Auto Correct’ tab, search the entry in question in the list and select it. Check the setting in the field ‘with’, whether it says ‘Plain Text’ or ‘Formatted Text’. All entries in the format ‘Only text’ are also available in other Officeapplications.
Office saves this data in an ACL-file for every language under the personal application data of the user. The other entries ‘Formatted Text’ are specific for Word. They are stored in the general document template ‘normal.dot’. This auto correction is not available in other applications. If you still wish to use it, you must decide, whether you can give up on the simultaneously saved formatting in Word. In that case it is enough to change the option to ‘Plain Text’.
However, take note that some auto corrections such as the smiley work only with a different font and are therefore assigned to the ‘Formatted Text’. Here, in fact you can cheat a bit, by creating a similar auto correct entry, which is then applicable for all Office programs.
The file you are trying to open has a different format than the specified file extension. Word 2003 refuses to open old documents and pops up an annoying message after the installation of Service Pack 3. Word denies access due to security reasons, since there is a possibility of hidden security loopholes in the old 1.0/2.0 formats. A lot of work is required to open such documents, even with the 2003 for Windows XP SP3 and 2007 program versions.
Open a new text file with Wordpad.
Type the following lines in it: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\SOFTWARE\ MICROSOFT\OFFICE\11.0\WORD\ FileOpenBlock] ‘FilesBeforeVersion’=dword:00000000 [HKEY_CURRENT_USER\Software\ Policies\Microsoft\Office\11.0\Word\ Security\FileOpenBlock] ‘FileBeforeVersion’=dword:00000000
Now save the file with the ‘REG’ extension. As a precautionary measure, close all open Office applications.
Double click the ‘REG’ file to add its contents to the registry. You can also add the entry by right-clicking it and selecting ‘merge’.
You should now be able to re-open older Word files normally.
NOTE: You can also use this file on computers with Word 2007. In this case, change the name of the subkey from ‘11.0’ to ‘12.0’ before using it.
Many tables contain positive and negative values. In addition to the automatically displayed minus sign, you also want the plus sign to be displayed for easier viewing.
You can enforce the display of positive signs using number formats. Since there is no suitable preset, you will have to make one yourself.
Select the relevant cells and click on ‘Format | Cells’.
Click the ‘Custom’ category in the ‘Number’ tab.
Change the contents of the ‘Type’ input field to ‘+0;-0;0’. Now confirm the setting with ‘OK’. This format code uses separate format settings, separated by a semi colon, for positive and negative numbers as well as for blank values. Use the third component without signs as well so that Excel places the correct sign even when rounding up a number. In general, you can use any number format instead of the default ones. You have to then define it twice with the respective sign and replace it with zero. Moreover, with a code such as ‘+0;-0;_ Null_’, it is also possible to replace blank values with text.
Emails sometimes contain sensitive information which you wish to delete safely. Does deleting them from the “Deleted Objects” folder in Outlook wipe them out completely?
No, deleting is not enough. Usually, when Outlook deletes a message, its contents continue to exist in the PST file (Personal Storage). Using a Hex editor or with other tools, it is still possible to access the deleted data. Only compressing the PST container will overwrite the unnecessary fields. To do that, select ‘File | Data File Administration’, select the PST file in the following dialog and open ‘Settings’ with a mouse click. In the next dialog ‘Personal folder’, Select ‘Compact now’. Depending on the size and fragmentation of the file and depending on the efficiency of your system, it can take some time.
Excel tables can be inserted in Word such that any changes made automatically appear in Word as well. This works well at least for small tables, but Word always cuts off bigger ones at the end of the first page.
Since Word actually has problems presenting Excel tables as objects, you cannot insert these through ‘Insert | Object’ in the document. First, select the desired area in Excel that has be copied and copy it with [Ctrl] + [C] in the clipboard. Then open the Word document, place the cursor in the position where the table should appear and select ‘Edit | Paste’. In the following, dialog of the same name, select the option ‘Insert Link’ and in the list ‘As’ enter ‘Rich Text Format (RTF)’. After a mouse click on ‘OK’, Word inserts the table correctly, running through several pages in the document. The table use formatting of a standard paragraph by default, making a few subsequent formatting changes necessary.
Note: If you place the cursor in the table in the Word document and activate the option to view field codes using the key combination [Alt] + [F9], you will see the actual reference (link) to the Excel table in the document.
Word replaces typed fraction numbers such as ‘1/4’, ‘1/2’ and ‘3/4’ automatically with ‘¼’, ‘½’ and ‘¾’. But other ligatures for fractions are not known to the program.
For a lot of fractions there is no suitable predefined character. However, you can make these by yourself or use another solution. One way is to use the formula editor. It however creates real fractions and not the typographic ones with a slash. Some other special characters, like for ‘5/8’, are available in the font ‘Arial Unicode’, but there is no such character for less common fractions like ‘5/6’. Besides, the fraction does not appear in the same font as the rest of the text. Therefore, it is better to reproduce these using individual elements with the suitable formatting. For that, first enter the fraction in the form ‘5/6’. Then select the denominator and halve its font size. If the current text size is 12 pt for instance, click in the combination field ‘Font size’ in the ‘Formatting’ toolbar, enter the value ‘6’ and press [Enter]. Next, select the slash and make it ‘Italic’. Select the denominator and through ‘Format | Font’ in the ‘Font’ tab, assign it the ‘Superscript’ eff ect. Here as well, you must adjust the font size again. Since raised characters become small anyway, use a size of about 85 %, so, instead of 12 pt, use ‘10 pt’ in this case. Confirm with ‘OK’. When you need such formatting for a fraction number frequently, you can leave this task up to the auto correction. For that, select the completely formatted fraction without the adjacent spaces and go to ‘Tools | AutoCorrect Options’. In the ‘Replace’ field, enter the text given in the beginning. You can simply type in a fraction here like ‘5/6’, if the change must be continuous, or use a shortcut like ‘b5/6’, so that you can decide the format while entering it. Then activate the option ‘Format Text’ and click ‘Add’. Confirm the entry with ‘OK’ and repeat the steps for other commonly used fractions.
Note: Henceforth, Word will format the pre-defined fraction numbers automatically in flowing text if you wish. For larger font sizes, however, you have to adjust the formatting manually or make the corresponding additions in the AutoCorrect Options like ‘10 5/6’, ‘12 5/6’ and ‘14 5/6’, wherein the values before the hyphen is still the original font size.
Posts
