Difference between revisions of "Office 2007"
From Richard's Wiki
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | * Excel C# Interop, Suppress "The number in this cell is formatted as text or preceded by an apostrophe" error: | ||
| + | |||
| + | public static void SetCellText(Range cell, string text) | ||
| + | { | ||
| + | cell.NumberFormat = "@"; | ||
| + | cell.Value = text; | ||
| + | // Suppress "The number in this cell is formatted as text or preceded by an apostrophe" | ||
| + | for (int i = 1; i <= 7; i++) | ||
| + | { | ||
| + | cell.Errors.Item[i].Ignore = true; | ||
| + | } | ||
| + | } | ||
| + | |||
* [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system] | * [http://office.microsoft.com/training/Training.aspx?AssetID=RP101482341033&CTT=6&Origin=RC101482291033 Quick Reference Card - Up to speed with the 2007 Microsoft® Office system] | ||
* If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line: | * If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line: | ||
| Line 4: | Line 17: | ||
outlook.exe /resetnavpane | outlook.exe /resetnavpane | ||
</code> | </code> | ||
| + | * To delete blank rows in Excel: | ||
| + | ** First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data . | ||
| + | ** Now, select the cells in one column from the top of your list to the bottom. | ||
| + | ** Make sure that all the blank cells in this selected range are the rows you want to delete. | ||
| + | ** Press the F5 key on your keyboard (or select Edit, Goto). | ||
| + | ** Click the Special button. | ||
| + | ** Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected. | ||
| + | ** Now choose Edit, Delete, select the Entire Row option and click OK. | ||
| + | |||
| + | ===== Microsoft Word ===== | ||
| + | * [http://support.microsoft.com/kb/290953 How to number chapters, appendixes, and pages in documents that contain both chapter and appendix headings in Word] | ||
| + | |||
| + | ==== Removing an Excel Workbook VBA Password ==== | ||
| + | |||
| + | A VBA project password can be removed with a hex editor. Close the workbook and open the workbook file in the hex editor. Find the string "DPB" and change it to "DPx". Save the file. Open the workbook and click OK until the workbook is open (one or more dialogs are displayed describing various problems with the VBA project). Press ALT+F11, choose the menu command Tools->VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Save, close, and re-open the workbook. Press ALT+F11 and enter the new password. Choose Tools->VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook. | ||
Latest revision as of 21:58, 11 July 2011
- Excel C# Interop, Suppress "The number in this cell is formatted as text or preceded by an apostrophe" error:
public static void SetCellText(Range cell, string text)
{
cell.NumberFormat = "@";
cell.Value = text;
// Suppress "The number in this cell is formatted as text or preceded by an apostrophe"
for (int i = 1; i <= 7; i++)
{
cell.Errors.Item[i].Ignore = true;
}
}
- Quick Reference Card - Up to speed with the 2007 Microsoft® Office system
- If Outlook 2007 comes up with a message saying "Cannot create Outlook window", a possible fix is to run the following from the command line:
outlook.exe /resetnavpane
- To delete blank rows in Excel:
- First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
- Now, select the cells in one column from the top of your list to the bottom.
- Make sure that all the blank cells in this selected range are the rows you want to delete.
- Press the F5 key on your keyboard (or select Edit, Goto).
- Click the Special button.
- Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
- Now choose Edit, Delete, select the Entire Row option and click OK.
Microsoft Word
Removing an Excel Workbook VBA Password
A VBA project password can be removed with a hex editor. Close the workbook and open the workbook file in the hex editor. Find the string "DPB" and change it to "DPx". Save the file. Open the workbook and click OK until the workbook is open (one or more dialogs are displayed describing various problems with the VBA project). Press ALT+F11, choose the menu command Tools->VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Save, close, and re-open the workbook. Press ALT+F11 and enter the new password. Choose Tools->VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook.
