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   Create an activeX control on the fly with VBA Can someone explain to me or give me a code snippet in VBA which can create an activeX control on the fly? I would like to be able to create a progressbar control on the fly. Thanks for any help! ... 3 03.01.2006 14:34:39 Need Name of Bullet Font I my zeal to remove an excessive amount of fonts (I had over 300),I must have removed one of the fonts that Word 2002 uses for Bullets. Could someone please tell me which one(s) it might be. Right now, no matter which bullet style I select, I get a small rectangular box where the bullet would appear. TIA... 2 03.01.2006 06:22:00 Find-question I have recorded this little macro, and it works find. It is just that every time I run the macro I get a question: "do you want to search the reminer of the document?" I don't want see this question! I want the the answer to be always "no" How do I do this? Thanks! Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Tex... 2 02.01.2006 12:33:27 Create signature lines based off list box selections I have a user form for a policy template that asks for information that it places into the header. One of the list boxes on this form is a "To be approved by:" box that identifies who needs to sign the official policy. Is there a way that some VBA can create a signature line for each of the items seelcted in the list box? I would need the selected list box text to appear by the signature line... 11 31.12.2005 15:55:30 Using a template without destroying the template About 2 months ago I started writing a database application in VBA and Access. This was my first ever attempt at using Access and my first ever attempt to program in VBA. The Access app is coming along nicely, it does most of the basic data input stuff. The next step is to get it to fulfill its true purpose, passing data to Excel and Word (and from Excel to Word) in order to create some ... 4 31.12.2005 15:51:45 Adding controls to a "designer form" Hi All, A while ago I added a from, originally created in the Word VBA environment, to a VB project. I need to modify it and don't know how to add new controls to it from within VB 6. The forms toolbox is disabled when the imported "designer form" is active. I cannot even cut and paste from a new form created in Word VBA and then imported into VB. Any help would be most welcome, Elli... 4 30.12.2005 22:26:40 UserForm VBA - pulldown menu - Word2003 Hello. I've created a template for proposals with a user form on the cover page. In one corner, we'll always be putting in the logo for the agency to which we are submitting the proposal. Is there a way to build in a pulldown menu in the user form where the user can select which agency and the logo for that agency appears? I have the logos we need - just have to figure out how to use ... 7 30.12.2005 17:14:41 Run-Time error '3061': executing SQL query using DAO I am picking up VBA after 6 years and need help with running a SQL query from Word to get data from Access MDB file. Error: Run-Time error '3061': Too few parameters. Expected 1 ' Debug Window at the time of the error debug.Print strsql SELECT [Oral_Communication] FROM MidYearComments WHERE ([Grade]=1) AND ([GradingCode]='E'); VBA Code in Word Docment <snip> Public Function ... 2 30.12.2005 09:42:17 suppressing requestor in Mail Merge G'Day, I am fairly new to using word/excel within a VB project. Currently I have a project which uses 3 Excel sheets to write an order form and save the data in a fourth excel sheet. The program then opens a word document and mail-merges this final excel sheet. Everything is working fine, but there is one thing I would like to modify. Currently when I Mailmerge to the word document the ... 6 30.12.2005 08:55:35 Word 2003 Stamping I am looking for help on creating a personalized stamp. This used to be easy in earlier versions of Word. Basically, this is what I am trying to do... A. Create a text box B. Show the Following Information (in specific font and format) - My Name, My Title - My Company Name - My Phone Number - My Email Address and/or Web Site C. Fit the contents of B into ... 8 29.12.2005 07:40:11 insert images from a form i'am now using the code below to insert images one by one in my word document change width, height and add a border But i want to make a form where i can select al pictures in one folder and select which one of them should be used and formatted by the code below. First problem is how to use "With Dialogs(wdDialogInsertPicture).Show" and store the path to the selected file in a variable? Sec... 2 28.12.2005 15:01:57 How to copy pictures in Excel and paste them under a word bookmark Hello all I have to implement a Word VBA which can copy pictures from MS Excel 2000 and then paste them under a Word bookmark. I know how to copy a picture in MS Excel Worksheet to the clipboard and then paste it under a Word bookmark. My code is as below: Set xlWorkbook = xlApp.Workbooks.Open(FileName:=WorkbookToWorkOn) Set xlWorksheet = xlWorkbook.Worksheets("Report1") xlWor... 3 28.12.2005 04:09:53 Document Indexes I am trying to create a macro that will find every occurance of a word and index it. Is there a simple way of doing this (e.g., something equivalent to "wdReplaceAll" in the find) or do I have to set up a loop to find next occurance and then mark it? If the latter, how do I test to see if the find was successful. Thanks for any help. Jerry... 3 25.12.2005 17:43:45 Scan selected cells in tables in Word, export to Excel? I am trying to get a word doc with the same table repeated several times to extract selected cell data for export to an Excel spreadsheet. I've stitched together some code based on scenarios I have read on this mb, but there is so much I don't know...like the looping and the auto open of Excel! This is a great site, thanks in advance for any help. ... 5 25.12.2005 09:46:10 Earn money Online - without risk! Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Work for yourself ? Then you should take yourself a couple minutes time. You happil... 1 25.12.2005 03:37:09 Earn money Online - without risk! Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Work for yourself ? Then you should take yourself a couple minutes time. You happil... 1 25.12.2005 03:36:54 Help making macro repeat Hi, I've put together the following code, but how do I make it repeat until it reaches the end of the document Regards Splowe. Sub ParFindandFormat() Selection.HomeKey Unit:=wdStory Selection.Find.ClearFormatting With Selection.Find .Text = "Paragraph" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .Matc... 6 24.12.2005 16:26:46 Make specified text uneditable in word (.dot) All, I have a requirement such that the specified portion of the text in a word document (.dot) should not be editable by the user. Please suggest. Thanks Srini ... 3 23.12.2005 21:37:37 .Text="*\**" If I had a string *this*is what*it looks*like when*I*shout* would "*\**" pick it up? (I do a lot of writing in plain text form and need to import it into MS Word recently. The footnote VBA script was a lifesaver. This is not as essential, but I'm looking ahead. There are about three or four more such scripts [<Heading>, _Italic_, *Bold*, maybe {Com... 2 23.12.2005 21:33:02 Macro Id text by code in middle Suppose I wanted to italicise "This_is a_book_title" or bold "*THis*is when*I*am *shouting*". How would you identify text with the code inside it and not separated off by spaces? .Text = "*\_*" .Text = "*\**" ?? ... 3 23.12.2005 07:45:37 THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < Would store / would copy this text or side before the administrator could remove this letter. This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro ... 1 23.12.2005 01:21:13 FAQ - frequently asked questions - vba - please read before posting - unofficial December posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less 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-... 4 21.12.2005 19:30:32 Getting a check (tick) into a label Anyone got any ideas on how I get the caption on a label to represent a check mark (tick)? The Chr($) dont show one in the character set. Many thanks gem_man... 4 21.12.2005 00:14:18 Select Word Range Depending on Color I have a document that has blocks of black text alternating with blocks of red text (black -> red -> black -> red, etc.). I need to programatically select the first block of contiguous black text (and then use the selected text for something), then the next block of contiguous red text, then the next block of contiguous black text, etc. until there is no more text in the document. ... 6 17.12.2005 21:27:38 macro recorder does not record When I use the macro recorder to make a macro I get the through the naming window ok and the recording indicator comes on. But when I do all the things i want done and stop the reording and go back to the macro all that is showing is my name and the macro title. This is happening in Word 2002, but the recorder works in Excel. ... 7 17.12.2005 21:17:19 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