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

  • Users: harky
  • Order by date
  1. harky

    Progress message box

    Hi SkipVought I tried that and it works, but it's not always clear - some of the users really need something displayed in the centre of the screen Harky
  2. harky

    Progress message box

    Hi Can anyone tell me how to display a message box for the duration of a macro running to display that it's working. I have a routine which is run over an incredibly large file and sometimes it appears to the user that the macro has crashed - I'd like to include some code to display "Macro in...
  3. harky

    'CHAR' appearing in stylenames

    Cheers Tony
  4. harky

    'CHAR' appearing in stylenames

    OK, so you're saying that in a paragraph styled n-Para such as : sfsdf skhkshdf shfksjhf s shfsdhf s kshfd skhf because I've styled shfksjhf bold that the para name should change to 'n-Para CHAR' - so no manual formatting is recommended? doesn't make sense I'm afraid
  5. harky

    'CHAR' appearing in stylenames

    Perhaps you should stick to painting! and even then, don't give up your day job. Anyone have anything more constructive?
  6. harky

    'CHAR' appearing in stylenames

    HI I have a problem where styles when manually formatted, have their names changed to include 'CHAR' or 'CHAR CHAR'. eg, a style 'n-Para' when maually formatted becomes 'n-Para CHAR' which is causing us a number of problems. Does anyone know if there's a fix for this? Thanks in advance Harky
  7. harky

    Unwanted lines in Print Preview - Word

    I've tried removing borders, it's almost as if the text has a hidden paragraph or something in the background. It's a bit odd and I'm guessing the file is corrupt in some way
  8. harky

    Unwanted lines in Print Preview - Word

    Hi mate, Nope, that didn't work. I've PDFed it and can remove the lines with PitStop, but they are uneditable in the Word document
  9. harky

    Unwanted lines in Print Preview - Word

    Hi I have a document that looks fine in editing mode, but as soon as I print it, or even look at it in Print Preview, strange unwanted horizontal lines appear in certain paragraphs. Does anyone know how I can get rid of these? Thanks Harky
  10. harky

    Applying formula to active cell

    Cheers Loomah That worked a treat
  11. harky

    Applying formula to active cell

    Hi I have a spreadsheet where I want user values to be multiplied by 9 automatically when they are typed in. Eg, when a user types 5 into cel E6 i want it to automatically change to 45. How can you have a formula run in the background for a cell and still be able to type in values without...
  12. harky

    manually changed character styles

    Hi Gerry I want character styled text which has had its attributes manually changed to be highlighted and then find the next instances of manually changed characters style stc throughout the entire document. Then the macro should say to the user "manually formatted character styles have been...
  13. harky

    manually changed character styles

    Hi Gerry Basically, I need the code to run through all character styles in the file and establish if they have been manually changed. So for xref for example, I would like to know if characters styled xref have been changed to red, or black or 18pt by the editor. So i need to compare the...
  14. harky

    manually changed character styles

    Hi Does any one know how I grab the charater style attributes from the template attached to the open Word document and compare them to the character styles withing the document to determine whether or not they have been manually formatted? eg, I have a character style *xref which is 10pt blue...
  15. harky

    Unprotect then protect doc looses form information

    Hi I need to run a macro on protected documents which firstly unprotects them (they are not password protected) then runs a number of search and replaces, then protects the forms again, saves , then exits. The problem is the forms are filled in and when I choose to protect again all the form...
  16. harky

    locating spaces in filenames

    Hi I need to run a macro across a batch of files to determine if there are illegal characters in there - at the moment it works fine, except for picking up spaces in filenames. The code so far is: Dim NameCheck As New RegExp Dim i As Integer Dim ch As String Dim illegalCharacters As New...
  17. harky

    'Label 1' appears briefly at beginning of file

    Sorry, it's a Word document. Sarcasm much appreciated. Cheers
  18. harky

    'Label 1' appears briefly at beginning of file

    Hi I have a file which, when opened, the text 'Label 1' appears for a brief second at the beginning. Does anyone know why this is and how to get rid of it? Thanks Harky
  19. harky

    Returning page and line numbers

    Hi, I just need to know the exact location of the first instance of any style used in a document, and list it in another document: eg. Styles file Heading1 - file23, page 6, line2 Heading2 - file23, page 12, line 8 etc etc I can get the filename easily enough, but the code I use doesn't...
  20. harky

    Returning page and line numbers

    Hi, I want to create a file which displays all the styles being used in another file - I've managed to get this ok, but I'd like to also insert what page and line number the styles appear on - how do I retrieve these? Thanks Harky

Part and Inventory Search

Back
Top