Threads Replies Last Post 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23   Tabstrip over Mutlipage Can anyone explain what the purpose of the tabstrip tool is in userforms and why you would ever use it over the multipage tool? thanks ... 2 09.06.2006 09:17:35 How to open an embeded Excel file in a protected Word document ? Hello, I have a protected Word document where I only allow the user to fill some fields. But in this document, I have an embeded Excel file shown like an icon. When the user double-click on it, nothing happend because the document is protected (an I need this protection). My idea was to put a button who will open the Excel file, but I don't know how to open this embeded Excel file in VBA c... 2 08.06.2006 22:08:17 Limiting the Print Button I work in a centre for people with disabilities and we have a problem with students pressing the print button many multiples of times when they go to do a print. I did post a message a while back asking for any VBA that might be able to limit printing, the only suggestion I got was to replace the print button with the print dialog. This didn't really work and only slowed it down a bit :) ... 6 06.06.2006 10:50:01 Beginners question: how to stop / abort execution of vba program Hi, how can I abort / cancel a vba program immediately, without returning to the calling procedure? I already have a rather complex vba application with many sub's and functions. The only thing I found by now is the "stop" command, but it enters debugging mode, so this is not what I want. i want to have something like this: Sub Main CheckValues MsgBox "Completed successful... 16 06.06.2006 07:59:35 Including field value from Word form in email subject/body I have a macro on a Word form (a document that's created from a template, not a UserForm) that opens Outlook and addresses an email to a particular person when you click a "notify" button. I'd like to specify the value of a text field on the form as the subject of the email. For example, if the text field says "JOE SMITH" I want the email subject to be "JOE SMITH". How do I specify that ... 2 02.06.2006 19:58:26 Word sendmail command - reference? Office 2003 Pro I am trying to write a macro that sends a protected form as an attachment and creates parts of the email from the formfields. (It is a phone message.) The email program is Outlook. I know how to get the info from the formfields, I just don't know how to put it into the email message as subject or message body. Also, can I specify the recipient in the macro? Can I iss... 2 02.06.2006 18:00:33 beep in VBA The VBA beep command doesn't result in my PC beeping. Where does the beep normally come from - the speaker in the PC itself (ie the one that beeps after the BIOS has successfully loaded) or from the speakers that plug into the sound card? I don't have any speakers plugged into my sound card, so if that's where the beep comes from, then that explains it. ... 8 02.06.2006 10:30:01 FAQ - Frequently Asked Questions - vba - please read before posting - unofficial May posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted every ten days or so. Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 3 30.05.2006 19:40:36 position and size of the cell in irregular tables Hello, is it somehow possible to find out the position of the cell relative to a page using vba? And also the size of the merged cell? I tried everything, but I did not found any posibillity. michal ... 2 29.05.2006 23:40:21 Find all paragraphs with listtype bullet and underbullet level 2 Hi everybody, I´m trying to find a code that in a quick way can find, and locate, all paragraphs with listtype bullet and specially underbullets, intended bullets. A can get a code with loop through all paragraphs to work but in a big document it will take quite a long time to run. So I´m trying to find out another way to solve this. I´ve tried to use the Find method but I did not succ... 4 29.05.2006 08:24:02 Find and Replace Paragraphs Hello everyone, I am trying to use, or maybe abuse, word macro to replace repeated paragraph in my work. I gave each paragraph a code then wanted to replace the paragraphs with Find & Replace macro. I keep getting teh message: "String parameter too long" The paragraph I am trying to use include mostly around 300-400 words. Is this something that can be done with Find & Replace macor? The me... 3 29.05.2006 03:25:45 wdActiveEndPageNumber Maybe the code is not executing too fast, but for some reason the following code gives me a false numPages: Set oRng = ActiveDocument.Characters.Last numPages = ActiveDocument.Range.Information(wdActiveEndPageNumber) For x = 1 To numPages If I put a stop at the For Loop line, then back up to re-set the oRng and re-get numPages, I get the correct numPage... 3 24.05.2006 22:44:35 Toolbar Hell Help, I'm in Toolbar Hell. I've been working on creating a Toolbar that floats on top or docks per the user's choice. My experimental Toolbar is named MacroXToolbar and contains the code that I showed in my previous post, "CoolBar or MacroX Code for Floating Toolbar?" This code was in my Normal.dot file, which shows up in the IDE as New Macros. I dutifully saved via cut'n'paste all the co... 2 24.05.2006 21:44:00 Paste VBA help If this sounds like a beginner question please forgive me, but alas, I am a beginner. What I need to do is copy a bit of text in one document, open another document, then search for that text there. Everything works find except the actual pasting of the text into the find dialog box. after creating a macro this is what I get. Sub Macro1() Selection.Find.ClearFormatting Wi... 3 24.05.2006 21:11:01 Header/footer VBA code Hello all! I'm a VBA newbie so please forgive any stupidity on my part. ;) I have developed a template (it's a .dot but most folks use it as a .doc) and it will usually be applied to older documents - meaning attaching the template to the doc and clicking on "automatically update styles." However - one problem is is that the template contains totally cool headers/footers and when on... 2 23.05.2006 21:23:32 New process of Word How can I open a new process of word for a document, instead of including that document in an already-running process? rs ... 3 23.05.2006 16:47:24 Using Regular expressions in Replace Hi, Is it possible to use regular expressions to do a find/replace in Word document. I copied some data from an application in to word like this:- asd qwe zxc vbn ghj yui I wanted to transpose it to a single row with a space (by doing a replace on \n ) asd qwe zxc vbn ghj yui (I could usually do such stuff with Textpad and want to know how to do in Winword) Regards, H... 3 23.05.2006 11:49:15 Hierarchy of Objects in Word Running Word 2000, I have a document with perhaps a half dozen paragraphs, with two tables interspersed among the paragraphs. If I have a loop: For Each p in ActiveDocument.Paragraphs I cycle through all paragraphs, both inside and outside the tables. I can also: For Each t in ActiveDocument.Tables and cycle through the tables. Is there some property which tells me where the tables ... 5 23.05.2006 11:38:37 Waiting for Document to load am creating a word document that basically analyzes other word documents that contain UAT test resuts (versus putting a button and code on hundereds of documents). This should be done in VB.NET or something along those lines, but licensing is an issue. My problem lies when a document is opened up that takes a bit to load but the code does not wait and executes before it is finished loadi... 2 22.05.2006 21:52:03 Help with MarkEntry method? I'm using an index as an automatic glossary (a tip picked up from another discussion group), and wanted a macro to simpify adding new entries. I've got this far Sub MarkGlossaryEntry() If Selection.Type = wdSelectionNormal Then ActiveDocument.Indexes.MarkEntry Range:=Selection.Range, _ Entry:=Selection.Range.Text, CrossReference:= ????? , Italic:=False End If End Sub Ho... 2 22.05.2006 12:54:15 Transfer Database not working The transfer database command does not work in macro. It doesn't work in code. Will someone help me please, before I get too old. ... 7 19.05.2006 11:43:38 Use same bookmark more then once Dear All, Is it possible to use for example bookmark Monthname more then once in a document? I tried but it wont allow me to do so. What I want to achieve is the following: I have a document where, for example, the month of May is used several times in various paragraphs. I dont want to find and replace May by June but I want to create a form where you can select a month and then aut... 13 18.05.2006 19:32:34 CountPages Hi, Anybody know how to count Total number of pages using WORDBASIC commands.... 5 18.05.2006 17:42:01 From ListBox to Excel to TextBox Dear great people, Could someone please be kind to help me with my concerns. I have a big database in Excel with 20 columns filled and 60000 rows filled. I am using VBA to organize my database, but I came up with a big problem. I got the listbox to extract the data from the first two columns and display it as a listbox. Now, the problem is that I want to be able to click on a listbox value, I... 2 18.05.2006 16:10:08 OpenTextFile - then overwrite it I am having difficulties trying to replace the text of a file using the "opentextfile" method. Whether I try opening the file with the write property, or use the alternative "openastextstream" method, I get an error. Once I've "captured" theText2 (which I want to insert as the text for x6005.dat file), how do I do that? Here's my code -- everything works just fine 'til I try to replace my ... 5 17.05.2006 22:30:18 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23