Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. donna6197

    from all-caps to normal

    I don't use excel much so there might be a better way of doing this. Assuming the uppercase name is in A1, the following should work: =UPPER(LEFT(A1,1)) & LOWER(MID(A1,2,LEN(A1)-1)) Donna
  2. donna6197

    Cannot remove line across foot of page in Word

    Is it a border? Open the footer. Click in the para with the line. Choose Format - Borders. Click on the None button and choose OK.
  3. donna6197

    Autotext

    Make it a document template (.dot) and you will be able to store your autotext entries in it.
  4. donna6197

    Problems with right indent marker

    If the paragraphs that are changing all carry the same paragraph style, then maybe Automatically Update (for the Style) has been checked. The following are for Word97 - Word2000 may be different 1. click in a paragraph that has gone awry 2. from the format menu choose style 3. click on the...
  5. donna6197

    Add a menu item for a macro - In a file

    When you first add the menu, is there a 'Save in' option that let's you choose where the customisation should be saved? For example, in Word97 I would choose Tools - Customise - Commands tab and at the bottom of the dialog box is a SAVE IN dropdown list that let's me choose either Normal or the...
  6. donna6197

    Autotext in Normal.dot

    I'm assuming that you want to look in New.dot to get an AT entry to insert into your document??? Replace 'enter path here' and 'Autotext name' with appropriate information. Sub test() Dim myTP As String myTP = "c:\ enter path here \New.dot&quot...
  7. donna6197

    Word 97

    It's a border. Select the paragraphs around the line. Choose Borders and shading from the Format menu. Click on the None icon (top left hand corner). Click on OK. If the line keeps moving to other paragraphs then do the same for that paragraph (or even select the entire document and do it)...
  8. donna6197

    Open Word 2000 and get last document saved

    Check that you haven't overwritten normal.dot. 1. Do a search for Normal.dot. 2. Open it (not by double clicking) 3. Delete the contents.
  9. donna6197

    Offic 97 Toolbar not working - file association ?

    The following instructions are for NT4 and Office97 Right click on the Office Bar and choose Customize. Click on the buttons tab. Remove the buttons that do not work. Choose Add File and navigate to the .exe file for the application to add a button. Note - If you are going to rename the...
  10. donna6197

    Word 2000--compile error in hidden module--autoexec

    Go to the Word startup directory (possibly c:\Program Files\Microsoft Office\Office\Startup). The template(s) you are after are probably here. Drag the template out of this folder. If you then open the template (not by double clicking on it - do a right-click, open or File-Open) you should be...
  11. donna6197

    Detect available printers using VBA

    See www.mvps.org/word/FAQs/MacrosVBA/AvailablePrinters.htm
  12. donna6197

    crack a word doc password

    I vaguely remember reading about a free one called Wordcrk (or something similar). I've never used it though.
  13. donna6197

    wd00: How can I stop form fields losing text when protecting for forms

    Locking the fields (ctrl F11) may also work.
  14. donna6197

    Data not formated-need to make it a table help

    Have you tried 1. copy the data 2. Paste Special (edit menu) 3. Click in the Transpose checkbox.
  15. donna6197

    Automatic monthly email

    Couldn't you just go to the message options (View menu) and set a date for Do not deliver before?
  16. donna6197

    Word 97 Form Field Update

    I'll have a go because no one's answered this (but there may be a better way) Try an on exit macro for the checkbox. Make sure you have text field on page two (where the X is to go) that has a bookmark name of Page2X. Create the following macro. Sub XonPage2() If...
  17. donna6197

    Word hangs when opening files

    Has Word/Excel always behaved this way, since installation, or did it begin to occur when something was changed/updated/installed ...
  18. donna6197

    Recovery from Word Form

    The following is using Word97 1. If by salvage you mean retain the info in the form then Select the document and press Ctrl F11 (this should lock the fields). You should then be able to reprotect the file without losing the field contents. Or Create a macro with the following...
  19. donna6197

    Sorting Autonumber In A Table

    Yes - as soon as you convert them they are no longer automatic. Are you able to duplicate the document each time you need to sort and only convert the numbers in the duplicate document? Another suggestion would be to use SEQ fields - these will only update if you update the field. You could...
  20. donna6197

    Sorting Autonumber In A Table

    If you're talking Word, you can convert the autonumbers to text (eg as though they had been typed) by creating a macro that contains the following: ActiveDocument.ConvertNumbersToText

Part and Inventory Search

Back
Top