Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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, _...
  5. 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, _...
  6. 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...
  7. 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...
  8. 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...
  9. 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