Search results for query: *

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...

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

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

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...

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...

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...

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...

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

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

Hi, Can anyone tell me how I can automatically sort roman numerals within Excel. It would be straightforward enough if the roman numerals were the only text in the cells but they aren't. The text is structured like this: TEST P-b(stat).doc TEST P-c(stat).doc TEST R-ii (stat).doc TEST R-v...

Hi, I know this is an old problem, but it's slightly different in my case as several different PCs have to access the same files at certain points. The problem is that on a couple of these PCs I'm getting the 'unavailable fonts' message and on the other two I'm not. When someone edits the files...

Hi there, Does anyone know how I can keep a form on screen after pressing it's OK command button. I want to be able to work on a word file and then click into the form and use it whenever needed rather than running the module from scratch and loading it each time, eg, the Go to, Edit/Replace...

Can anyone tell me how I find merged cells in Word tables or how I find a 3 column row in a 4 column table. I basically have a 4 column table but some of the cells in certain rows have become merged creating some 3 column rows which need to be corrected. I need to find the merged cells and...

Hi there, Does anyone know why when I open an RTF file in Frame containing tables, the text in the majority of cells reverts to the para style "body" and not it's original style. In the majority of cases it seems to effect all but the first column. It proves quite time consuming having...

Does anyone know how to determine whether or not a row in a Word table is empty and delete it?

Does anyone know how I select the text between two different para styles. Basically, I have two different styles "[IPSB" which begins a section of inserted text, and "[IPSE" which ends the inserted text. I need to select everything between these two codes and format it. Can...

Does anyone know how to search for a particular style and then insert some text on the following line, only when the following style is not one of two particular syles. eg I need to find all instances of a code "n-para" and then insert some text after it, but only when the following...

How do I go about completely overwriting document styles with styles of a same name from a template. I've tried using the Loadstyles method, but they don't appear as they're described in the Style organiser. I've also tried resetting all manual para and font formatting, but this still doesn't do...

How do I find and remove EN spaces from a Word 97 document? I'm pretty new at this, so any help would be appreciated. Thanks for your time