Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - Generate all possible sets of strings
Zathras, Thank you for your wonderful help. [medal] I was working off an old file someone else had created - and was trying to fix what I had rather than start over - which I should have done. Your shorter code will work much better than the old. Have a nice Vacation! AngO- AngO
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Generate all possible sets of strings
Hello All, I would like some help to generate ALL the possible combinations of 22 strings in combinations of 3 items per set. This is NOT a Permutation or a Combination. (PS - any help on the proper name of what I am trying to do would probably help also!!) For example: 22 items in sets of 3...- AngO
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Mail Merge (Excel -> Word) and Sheet issues
Sorry - missed the notation about office 2000. For some reason I was thinking about XP!- AngO
- Post #10
- Forum: Microsoft: Office
-
Mail Merge (Excel -> Word) and Sheet issues
The issue we were dealing with was different, but solution was still the same, needed to get to DDE. Without taking that first step, changing the data exchange was not an option on xp. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320473- AngO
- Post #7
- Forum: Microsoft: Office
-
Cntl F and replace / Word / paragraph
datadan, In the replace window, click on the More option. Then select special. Paragraph symbol is an option. Then just type in your , space in the replace spot. Good luck, AngO- AngO
- Post #2
- Forum: Microsoft: Office
-
Mail Merge (Excel -> Word) and Sheet issues
Kalechibki, Dreamboat's first suggestion will work, You need one extra step for that option to show in the datasource window. In word, go to Tools, Options. On the General tab, select the Confirm Conversion at Open check box. After you complete this step the rest of Dreamboats instructions...- AngO
- Post #5
- Forum: Microsoft: Office
-
How to stop splitting talbe rows in Word
jnix, Is the button greyed out when you try an individual row? When it is grayed out, can you still click it to turn it black? Sometimes the marker is gray because the settings for the individual rows don't match. If the button is available in individual rows, try several at a time, but not...- AngO
- Post #4
- Forum: Microsoft: Office
-
How to stop splitting talbe rows in Word
Sure, Try selecting the entire table, go to table properties, row tab - remove the checkmark from "allow row to break across page". Hope this helps. AngO- AngO
- Post #2
- Forum: Microsoft: Office
-
Track Changes in Word 2002
Well, it appears we can't seperate the deletions from insertions on the choices. I also tried to do a find and replace (I was going to find all of the strikethrough and replace it with "hidden" format); however the program doesn't mark the deletions in a way I have found to search...- AngO
- Post #6
- Forum: Microsoft: Office
-
Track Changes in Word 2002
How would you like the deleted text to appear? Some things can be changed, but not as many. We may not be able to get what you had before, but we can change the red, and the balloons versus strikethrough. Changing the color for insertions also changes the color for deletions. What do you have...- AngO
- Post #4
- Forum: Microsoft: Office
-
Making a calendar in Excel
iGrant, Thank you for the wonderful file. I will put it to good use!! AngO- AngO
- Post #7
- Forum: Microsoft: Office
-
prevent table resize word?
branko, You are correct. No pictures in the form fields. HMMM You can do all of the above without the forms part of it. But the user could still manually change the table the same way you did, or by draging the column widths. Maybe if you set it all up, then save it as a template. The...- AngO
- Post #4
- Forum: Microsoft: Office
-
prevent table resize word?
Branko, I do the following: Change the table properties to set measurements. When you do this on each tab (Column, Row, & Cell). Make sure the measurement on the Row tab is "Exactly". Then insert Form Fields into each cell of the table. Lock the form and send it out to the...- AngO
- Post #2
- Forum: Microsoft: Office
-
Creating templates in word 2000 - locking objects
midKnight, In addition to Dawn's comments: If you wish to protect an object - you need to section it off with section breaks. Then go to tools, protection choose forms, then select the sections which contain the objects. Hope this helps. AngO- AngO
- Post #3
- Forum: Microsoft: Office
-
redline, compare changes WORD
Shelron, I don't know if this will help or not. I have found that files that have "Track Changes" turned on in a previous version (not accepted/rejected yet); and converted to a newer version; do not allow you to complete the track changes process. I have learned that to avoid the...- AngO
- Post #2
- Forum: Microsoft: Office
-
Mail Merge Help
zoeythecat, Dreamboat has a wonderful site full of this type of information. The link to her mailmerge section is: http://www.thewordexpert.com/word.htm#MailMerge If you don't find what you need there, would you please post back? AngO- AngO
- Post #2
- Forum: Microsoft: Office
-
Outlook Question - Any version!
Sugada, According to the help file: Depending on your e-mail system, there may be size limits to distribution lists. If your e-mail server tells you that your distribution list is too large to save, you can create smaller distribution lists and then include them in the large distribution list...- AngO
- Post #2
- Forum: Microsoft: Office
-
Removing Macro from toolbar in Word 2000
As a side note to Acron's method - which works great. You can also delete any button from a toolbar by holding down the Alt key while you drag it off the toolbar.- AngO
- Post #3
- Forum: Microsoft: Office
-
Automatic Capitialization In MS Word
Tools, Autocorrect - remove the checkmark from "capitalize first letter of sentences". Also, if you are creating a list - you may also need to turn off on the next tab (AutoFormat as you type), the one for "format beginning of list item like the one before it" As a side...- AngO
- Post #2
- Forum: Microsoft: Office
-
Can you split a window in Excel like in Lotus 123?
As a side note to Dale's suggestion - You can also have them both on the screen at the same time. After you get the New Window open, go to Window/Arrange - Make your choice, but make sure you put the checkmark in the box for "windows of active workbook". AngO- AngO
- Post #8
- Forum: Microsoft: Office
