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   Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 20.03.2006 12:28:08 Code executing too fast -- causes errors Hej, Guys!! Back in December, I had a similar problem with an autoMacro, but now I'm running into this problem with regular macros. Is this a known "bug", or am I doing something drastically wrong in my coding? (or haven't I explained it well enough to know!!) The problem is that my code "runs too fast" to accomodate the changes it is causing to the document. I deduce that from the fa... 36 19.03.2006 10:30:41 VB making a CSV from a filename Can anyone give me a clue to build a VB.NET program to take a file name that looks like this: $_1234_99999999_7777777777_00000000_$_A.tif And make it into a CSV file to look like this: 1234,99999999,7777777777,00000000,A,c:\tif I'd like to read through a directory with a number of these .tif files and create a CSV that can I can use in another process. I just don't really know where... 2 17.03.2006 22:37:41 Fill-ins Hi, I am currently using fill-in fields to gather some information when a script runs. I do not need the information if the script is not run, only when it runs. For some reason, when a new document is created, the user is prompted to fill in the various fields (which aren't actually used, because the script isn't running). Is there some way I can turn this off, so users not using the sc... 2 17.03.2006 20:15:36 Project created in Word 2003 will not load macro under 2002 Hello. I have created a fairly simple project (XP Prof/Office 2003). After making a letter template using styles and bookmarks, I created a UserForm to have the users fill in appropriate info, and code for validation. I also used the mpr.dll to retrieve UserID from logon, as key to get some user info from an Access database (name, title). It works beautifully on my machine and also on my... 1 17.03.2006 16:26:27 Compile errors: What's wrong with this code? After several years of working with VBA in Excel, I'm now starting to visit the world of Word. It's driving me nuts. ;) The following two macros are stored in the same module in Normal.dot: Sub FileFolderLabels() Application.MailingLabel.DefaultPrintBarCode = False Application.MailingLabel.CreateNewDocument Name:="5066", Address:="", _ AutoText:="ToolsCreateLabels1", La... 6 17.03.2006 13:58:43 Macro for "Printing (with balloons), Paper orientation= Auto" X-No-Archive I am trying to incorporate into a Word macro the setting "Printing (with balloons), Paper orientation= Auto", the option that you can check in the Reviewing Toolbar, Show, Options, but it is an action that does not get registered with the macro recorder. How can I do that with a Word macro? Thanks in advance, ... 3 16.03.2006 23:07:21 test test ... 4 16.03.2006 17:43:16 Template with clauses check list ..I am creating a template in Word XP that can contain several different clauses in different orders. The template has the following criteria: a.. Document that can created by buyers and clerical staff using a check list for clauses and macros to create the document b.. Web based input by requisitioner with technical information so that technical and purchasing information are merged tog... 2 16.03.2006 16:27:15 PAGE CHANGE I need to make a new event which runs when the document (for example a new document, originally with only one page) adds a new page? Help me please....!!!! Thanks Gù ... 3 16.03.2006 02:05:30 Autocorrect in an interactive template Is it possible to run autocorrect in a word template after its formfields are populated from a userform? I have been experimenting with the autocorrect object in word vba and I haven't been able to get it to do what I would like. What I am specifically trying to do is when a user types a word into a text box on a userform that word will be "autocorrected" when that word is applied to the f... 3 15.03.2006 23:55:57 problem with event handling What I am trying to do is to get a section of code to run whenever a specific document (not a template) is opened (using Word 2003 with WinXP SP2). I have put the following test event handling code in the 'ThisDocument' object of the word document's project: Private Sub Document_Open() MsgBox "Opening document" End Sub However, when I close the document and open it up again, the ... 2 15.03.2006 11:34:57 From website (button) transfer data to a new Word document Hi there, I need some assistence. I have a Web application and there data can be filtered and with a final push on the button I want the data to generate a Word document on the clients computer. I have searched around but onty found how to do that from a Windows Forms Application. I know there is commercial software (i.e. Aspose) but it's rather expensive and too much for what I need. Ca... 1 15.03.2006 08:23:27 Getting information from Access into Word Hi all, I'm very new to VBA, so my question here may look stupid or has been answered here a dozen times. Anyway I was not able to find the answers to my question. I have made a small Access database in which I have 4 tables. Table one contains (in every table there is of course a ID field) the names of products that we do analyses on, like wheat, flour, soyabeanmeal Table two contain... 4 14.03.2006 20:32:23 Multiple items in a COMPARE statement? Hi: Can "Compare" be used with multiple words or just one? eg: {Compare "Acids, Bases, Solvents" = "Bases"} It seems like it should work but I haven't had any luck. Are there "wildcards" I can insert or what? Thanks for your help. Koe -- jaglogow Posted from - http://www.officehelp.in ... 2 14.03.2006 18:10:16 Changing font of a selection. How can I change the font of the selection? I want to find a selection of text and change its font automatically I tried recording it with the macro recorder, but it didn't record anything when I changed the font. Thank you for any help with this question. ... 3 14.03.2006 17:35:05 Error Message I need help getting rid of an error message which appears when opening existing word documents. This error does not appear when opening a new document. The message is: "The command cannot be performed because a dialog box is open. Click ok and then close open diafog boxes to continue". I click OK, but no dialog box. Where is this dialog box? Thanks... 3 13.03.2006 21:41:44 save document to another file when target file is unavailable Hello, I have written a macro to save documents to several destinations over a network. When the network connection fails or I'm not linked to it the macro crashed with out saving. Is there some script that would detect the fact that the destination file is not available and save into another available file thanks very much... 2 13.03.2006 21:09:50 find and replace styles Greetings I have a lot documents that have an old set of styles. recently, we change all the stylrs to different names. I now have to apply these new styles to the existing docs. I would like to open a doc and run a macro to search the text for the old style and replace with the new style. I have been writing macros for a very short time, but have been developing software for many years... 9 13.03.2006 16:35:43 Intercept ProtectForm event I am having difficulty using the great direction found at ("http://word.mvps.org/faqs/macrosvba/InterceptsavePrinContent.htm) to intercept the ProtectForm command/event. Using Word 2000, I am unable to get into the sub when I save it in my Normal.dot. What's the trick? Also, must the sub be kept in the NewMacros module, or can I move it? TIA ... 3 12.03.2006 05:10:51 ThisDocument object is a virus? Hello, After some trial and error, I found that whenever I make use of the thisdocument object, I could not save the vba project, but received a 'notification' from my virus scanning software (Symantec) warning that the virus 'Bloodhound.WordMacro' is found, and 'quarantine suceeded,' and I have been 'access denied' to the my project. I have to remark out the lines involving the thisdocume... 2 11.03.2006 06:31:36 Trouble to remove background color I want to remove the background color of a range. This must be easy, but I can't get it working... <code> Sub DeleteCorrectionMarks() Dim TodoElTexto As Range Set TodoElTexto = ActiveDocument.Range With TodoElTexto.Find .ClearFormatting .MatchWildcards = True .Format = True .Font.Underline = wdUnderlineWavy .Font.UnderlineColor = wdColorRed ... 2 10.03.2006 12:23:48 How to switch to English input in Visual Basic I am using a Japanese version of Windows XP, which means I can switch the input between Japanese and English by pressing a key on the keyboard. How can I do this switch in Visual Basic? I have tried recording the keystrokes with a macro to see what Visual Basic would record, but it didn't register what I had done, and the recorded macro was just an empty subroutine. I understand this is... 4 10.03.2006 00:15:59 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:46:07 Linking macro to keyboard I am sure this is really obvious. How do I go about associating a macro with a keyboard action. I know how it works when recording a macro (simply use the options to associate the macro you are recording with the macro) but I cannot seem to see how it works if the macro was created elsewhere or elsewhen and I now want to associate it with a keyboard. For instance suppose I import Sub... 4 09.03.2006 19:21:52 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