Search results

  1. S

    Using vba to open existing template, close previous

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

    Using vba to open existing template, close previous

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

    Modifying listbox values

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

    Modifying listbox values

    [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...
  5. S

    Printing from VBA with Word

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

    Capture left / Right click of listbox

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

    Capture left / Right click of listbox

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

    Printing from VBA with Word

    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, _...
  9. S

    Printing from VBA with Word

    Ahhh, sorry - clicked the wrong forum :)
  10. S

    Printing from VBA with Word

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

    Printing from VBA with Word

    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, _...
  12. S

    Spell checking VBA text box.

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

    Spell checking VBA text box.

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

    Programatically joining templates?

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

    Populating list boxes from Excel

    Ahh. That makes sense. Thanks!
  16. S

    Populating list boxes from Excel

    Currently I pull all my listbox data from a word document. I would like to pull it directly from a (source) excel spreadsheet as Im assuming its more efficient and would save me a couple of steps. Im trying to modify some code that I dont know a lot about :) The example below works, but Im...
  17. S

    Troubleshooting VBA between word versions

    Thanks for that - Ill do some more work on it. One thing I have discovered, is that one of the document templates (created in W2000) when run in 2007 seems to crash - but actually just looses focus on the save dialogue eg - you attempt to close the document and the save dialogue box is not...
  18. S

    Troubleshooting VBA between word versions

    Greetings, I have a word document / application that uses a UserForm to create multiple pre-populated word documents based on user input. It all works fine in Word 2000 however, randomly crashes in word 2007. The crash occurs on the final submission of the user form - when creating the...
Top Bottom