Recent content by HighPlainsGrifter

Sorry about de.lay answering here - I have been pulled in a different direction for a bit here but will check your suggestions and test as soon as I can! Thanks for the help so far - I let you know how it goes...

I have this in my personal macros folder which I have not used far a really long time, but sounds as though it could be adapted for your use? you would probably only really be changing the locations and the contents of the "Update" and "Overwrite" subs. There is a lot which I'm sure you can just...

It is still kicking up the error about the command failing.. I have made WdApp visible (which is nicer anyway so thanks for that :)) but even with one parameter, the open fails. I removed the "& "\" " but that did not sort it either... The documents are to be used in a program which can only...

That sounds like a great idea, but I'm struggling to get it to work... I get an error on the line "Set wdDoc = wdApp.Documents.Open(FileName:=strStartPath & "\" & strName, ReadOnly:=False, Format:=wdOpenFormatAuto)" saying "Command Failed". Here is some of the code: Most of the variables are...

Thanks for the answer; I have checked my code and unfortunately (in terms of finding a solution) I have already put the screen updating toggles in the right places - at the beginning and the end of the procedure which calls the others. Is there any circumstance where Word will turn screen...

Hi people, I have a Word 2010 macro which allows a user to choose a target folder (via a userform) and which will then apply the same changes to every document in that folder. In order for any user to run the macro, I have pasted it from my personal macro and put it in a document. When the user...

Hi, thanks for your answer. please could you give a brief explanation of what to do with the combobox? Are you saying that I can make a combobox which will list all the files that meet the criterion, and I can open each file in turn by making selections from the combobox?

Hi, people! I have a macro which will open every file in a folder and will call another macro to perform the same action to each file: Option Explicit Dim scrFso As Object 'a FileSystemObject Dim scrFolder As Object 'the folder object Dim scrSubFolders As Object 'the subfolders collection...

Apologies - I sorted it in the end by changing the requirements, rather than a bona fide result such as would be seen as interesting on this forum. I have removed a lot of the bulletted text. While this is not really the solution I was after, it became necessary due to time constraints on the...

I am using legacy form fields to allow variable text in a series of templates. Users will use a third party program to access the letters (they are all .doc files) and the form fields complete with relevant details. If the information for the form field is not entered, they can double click the...

Thanks - works perfectly :) Apologies for late reply

Hello People, I have written a macro to correct some basic syntax errors in form fields used in a large number of documents. Another macro ensures that this one is run on each document in a given folder. This macro will check through the document for specific known errors in the default text of...

Apologies for the delay in answering - I have now managed to sort this, thanks to all your help. Thanks again, everyone!

Hi again people - hope you all had a good weekend. Just to clarify a couple of points discussed: the letters are already written, with formats in Place, so the "don't add space between paragraphs box" is not so useful, but thanks for the idea. Also there are no empty lines on any of the...

Yes, they have styles, and all the letters use the same custom style for the bullet text (Letter Bullet) and likewise for the other text (Normal). Something like this then, you think? ( I'm not on my pc so the syntax is probably wrong, but hopefully you get the sense) With...