Recent content by Spooky

The template itself is a method of creating many different documents, so its a complicated arrangement of user forms. Im frequently upgrading and adding more functionality, hence the need to edit or replace the single live running copy. So, the end users do kind of open the document based on...

Can anyone point me in the right direction to use a .dot file to open another .dot file and close the first one? The background is Im trying to work around an existing problem. In a network situation, I have many users of a single template file (eg TemplateA.dot) and due to the multiple users...

Sorry, Im not that flash with the terminology. So, I would need to rebuild the listbox from the source and cant change individual items (as they are read only?) within that record with .removeitem(x) and then .additem(x)? UF1.Listbox.RemoveItem (27) UF1.Listbox.AddItem...

[brief] Userform / vba / word I have a listbox in a userform that I wish to modify one item. Basically the list contains data relating to an individual. There are 30 items per record. There can be one to many individuals listed in a multicolumn list box. How can I change one item - eg...

Thanks, Ill try recording a macro like suggested to see if it gives some more hints. The unfortunate problem is the project may be used in any one of many remote locations where I have no input into the user or office setup - hence the hope for generic settings

Thats why I find it weird - it is reselected in Userform1. The only difference is whether button 1 (left) or 2 (right) is pressed to get there

Is there a was to send a left click selection of a listbox to a form? Using the code below, a user right clicks on listbox1 and is presented with a form to add/remove (and further options) the list box item. Making the selection in userform1 returns them to the main userform and the item is...

I have a Word VBA project that outputs multiple word documents and I wish to print (x) number of docs to the default printer of which I have no control Im using this basic code to do so: ActiveDocument.PrintOut _ Background:=True, _...

Ahhh, sorry - clicked the wrong forum :)

Thanks for the link, not available under Word VBA though?

I have a Word VBA project that outputs multiple word documents and I wish to print (x) number of docs to the default printer (which could be any number of printers) Im using this basic code to do so (with limited success) ActiveDocument.PrintOut _ Background:=True, _...

I think I have found my own solution. Using Application.ScreenUpdating = true whilst in the function fixes the problem

Im trying to get a spell check into a word Userform application.It works just fine apart from one thing - there is no preview of the text being spell checked as below. This is the code used: Public Function FCN_Speel_Check() Dim oScratchPad As Word.Document Dim oRng As Word.Range...

To cut a long story short, is there a way to join a template from a VBA loop? eg - for a simple doc, I do: for a = 0 to x Documents.Add Template:=sName + "file.dot" With ActiveDocument ' add bookmark stuff etc End with Next x Now, depending in the selection in the userform, they may create...

Ahh. That makes sense. Thanks!