Search:

Type: Posts; User: Gwynne; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Combine 30 worksheets into 1 workbook (ExcelXP)

    This works wonderfully!!! <img src=/S/mice.gif border=0 alt=mice width=50 height=25> Thank you and have a very Merry Christmas and Happy New Year.
  2. Re: Combine 30 worksheets into 1 workbook (ExcelXP)

    Sorry I didn't answer your questions. There will not be other Excel files in the folder...ALL files in each folder will be combined into the new folder.
  3. Re: Combine 30 worksheets into 1 workbook (ExcelXP)

    I
  4. Re: Combine 30 worksheets into 1 workbook (ExcelXP)

    Yes, Hans, each worksheet is in a separate workbook. This is for grading our employees for pay raises. Each employee has a workbook/file/folder with his/her name. Each of those workbooks have 1...
  5. Combine 30 worksheets into 1 workbook (ExcelXP)

    Help! I need some VBA code to give my managers the ability to combine some of the 30 separate worksheets into one workbook. Can this be done? If so...how? Very new to VBA so be gentle.
  6. Replies
    3
    Views
    404

    Re: Need help with VBA code (WordXP)

    Thanks, Hans. You make it seem so easy. <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15>
  7. Replies
    3
    Views
    404

    Re: Need help with VBA code (WordXP)

    Sorry, I forgot to include the code:

    Private Sub Document_New()

    'declare vars
    Dim strCrimCrt As String
    Dim strCrtNum As String
    Dim strCaseNum As String
    Dim strDefName As String
    Dim...
  8. Replies
    3
    Views
    404

    Need help with VBA code (WordXP)

    <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>
    Can someone please help me with my code? I have a document that requests 4 fields. After they are filled in, I want the document...
  9. Re: Do you want to create another? (VBA/WordXP)

    Thanks, guys. Everyone is so helpful, and I feel so stupid <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22> !!!

    Special thanks to Pieter for being able to read my mind (what little...
  10. Do you want to create another? (VBA/WordXP)

    I have a template where 8 fields are filled in. After the last field is filled in, I ask the question "Do you want to create another document?" If the answer is YES, I only want 2 fields changed...
  11. How can I get rid of a blank field (WordXP)

    I have a template with several fields in it. One field can be blank. How do I remove the FormField through code so there won
  12. Replies
    6
    Views
    493

    Re: VBA newbie needs help (Word XP)

    Thanks very much, Kevin. Your site was one of the first things I downloaded and tried when I got stuck with this project. You've been a great help with my questions. I'm sure I'll have plenty more...
  13. Replies
    6
    Views
    493

    Re: VBA newbie needs help (Word XP)

    Wean them
  14. Replies
    6
    Views
    493

    Re: VBA newbie needs help (Word XP)

    Thanks for your help, Kevin.

    I work with 135 VERY brain-dead users. They want to see the template so they will know what goes in the "little gray box" (shaded form field). The first couple of...
  15. Replies
    6
    Views
    493

    VBA newbie needs help (Word XP)

    I have created a template, and am using InputBoxes to gather information to be plugged into the document. At one point the user will have to make a decision as to whether a document was recorded in...
  16. Re: Calling all WordPerfect to Word Interpretors! (Word 2000)

    Hi Atelby,

    Sorry, I forgot to tell you that this isn't a macro. You need to create a document with the three FormFields in it, and save it as a template. Then go to Tools/Macros/Visual Basic...
  17. Re: Calling all WordPerfect to Word Interpretors! (Word 2000)

    I am also converting alot of forms from WP5.1 to Word! What a headache! If you will take the following code and plug it into a blank document with three formfields in that document, this may be how...
  18. Re: Newbie needs VBA help (Eng/WordXP/Office2000)

    Kim and Jefferson

    It works! It works! It works!

    Thanks to all who made this possible. This is a great site and a bunch of great people!
  19. Re: Newbie needs VBA help (Eng/WordXP/Office2000)

    Used to work in a law office, but now work for the district clerk.

    I'vd created UserForms (InputBoxes) that I want to display when the new document is opened. When you pull up the new document,...
  20. Re: Newbie needs VBA help (Eng/WordXP/Office2000)

    Thanks for the tip, Kim. However, I have been working in Word for about 8 years now, but have not had to do macros as all our macros were in WordPerfect (ugh). I'm lost when it comes to...
  21. Re: Newbie needs VBA help (Eng/WordXP/Office2000)

    Thanks Hans. At least this will get me started on the right path.
  22. Newbie needs VBA help (Eng/WordXP/Office2000)

    I spent a couple years of my life writing WordPerfect (5.1) macros to produce a vast number of fill-in-the-blank forms. Now that our office has moved into the 20th century, (not yet the 21st, that...
Results 1 to 22 of 22