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   Modify Field Results Hi, I'm trying unsuccessfully to create/write a macro that will modify a Custom Document Property located in the header of a document. The name of the Custom Document Property is "Effective Date" and the Value is a date. I want to replace whatever the date is with "03/01/06". I'm using Word 2000. Any ideas? Thanks, Mickey... 2 23.02.2006 20:48:12 Need help with word macro I recorded and edited this macro to remove unwanted characters from a word 2003 document. It does what I wanted and allows me to add or change the characters as needed, but it seems the code is very redundent and probably could be shortened to accomplish the same results. Any help on this would be very much appreciated. Thanks in advance. Joe ___________________________________________... 4 23.02.2006 13:16:08 New document disaster preventiion/recovery software Looking for individuals in organizations that rely heavily on electronic documents to "Beta Test" a new Windows software product called DocShield (as in Document Shield). DocShield protects vital documents by maintaining a compressed archive of document "snapshots" throughout their history, making it possible to recover information from any point in time. It also has fault tolerant features... 2 22.02.2006 21:58:25 Deleting blank rows at the end of a table Using Word XP 2003 My Word doc contains a table with 10 rows with a macro inserting info in rows 8-10 after it has done steps below. My macro also inserts 3 rows below row 5 based on whether To: or CC: boxes in a form contain text. If this is the case, I end up with multiples of 3 additional empty rows at the bottom of the table. If there are no rows inserted, everything is okay an... 2 22.02.2006 19:06:51 Sharing MAcros/Templates I have created a VBA program and will now be sending it to a few users. My question is this - Will all of the references to the Jet and DAO db still work on the new users PC or do they need to set them manually? ... 5 21.02.2006 21:47:16 Dialogs(wdDialogTableSort) with Title? I would like to have a Title on the Dialogs(wdDialogTableSort).Show user dialog. Any known or unknown way to replace or extend the 'Sort' in the top blue field? Seen ' .DialogTitle = "My Title" or something like that in other Dialogs, I think. Thomas ... 3 21.02.2006 19:04:29 LDAP and VBA variables I would like to pull some information from LDAP, specifically a user's title however, the information I'm trying to get would be based on choices made in a VBA list box. For instance, in the list box the user may pick John Doe and Jane Smith. I then want to take those two names, pass them to LDAP and get their titles. Is there a way to do this or is it not possible? Thank you very mu... 1 21.02.2006 17:11:29 import a header Good morning I would like to import a header to a word document from the macro of another word document. Thank you. ... 7 20.02.2006 18:08:12 importer un header Bonjour, je souhaiterais importer le header d un document word, a partir de la macro d un autre document word. Merci ... 1 20.02.2006 09:29:30 Arithmetic in Visual Basic I know next to nothing about Visual Basic, but due to the extreme tedium and frequent mistakes in typing in very repetitive sequences of invoices/estimates/delivery notes involving the same numbers in several places, I made the following function to make the documents automatically using fields in a Word template. Basically I grabbed some code off the web somewhere and messed around with... 3 18.02.2006 06:55:51 Position of Cell Is there code which will return the position of a cell within a table relative to the page? I have pictures inserted in a two column table and I am trying to use a macro to insert shapes such as arrows in the center of the picture. Jim ... 3 18.02.2006 00:48:59 Remove footer from first page Does anyone know the vba code to set or remove text from the footer of the first page of a multi-page document. There are no sections, its a dynamic document that may be 1-15 pages and I need to write a footer on all but the first page. Thanks! ... 4 17.02.2006 20:45:20 FAQ - Frequently Asked Questions - vba - please read before posting - unofficial January 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-... 10 17.02.2006 20:15:00 Expand/Collapse a Range of Columns Hi, I can get the sheet to expand/colapse, but want to be able to do it for a specific range. This is what works: Sub ExpandColapse() 'Acts on Active Sheet With ActiveSheet ' collapse all columns .Outline.ShowLevels columnLevels:=1 ' open first nest .Outline.ShowLevels columnLevels:=2 ' open second nest .Outline.ShowLevels columnLevels:=3 End With ... 2 17.02.2006 18:51:45 Checking if the bookmarks are still there in order to get the form to work Hi I have created a userform that bring up the content from certain bookmarks in the document and presents them in the fields of the form. The user changes these settings and the new content of the bookmarks are cascaded throughout the documents headers and footers (and in text) via ref fields. The bookmarks themselves is hidden in the header of the first page of the document in a textb... 13 14.02.2006 19:49:17 Typing versus replacing Hi all, I'm having what is a problem trying to create a macro that uses tabs, which will later be used in converting text to a table. It's fine when I use search and replace to place tabs, using ^t, when I know exactly what the search will find. But when I search for a piece of code, followed by a digit, I can't use S&R 'cos I don't know what the digit will be. So I search, then cancel t... 4 14.02.2006 15:50:03 change password excisting word document Hello, i'm very new to the vb.net framework. This is my problem : i have a word document with a password-protection. And the password is known. I want to sent this document by email with another password. So i have to copy the password-protected-word document and change the pasword of the new document. Please help me out here. Havent got a clue. Thank You in advance. ... 2 14.02.2006 14:06:15 Opening Word File Created a word doc on my desktop,a timesheet containing many rows & columns .. Copied same to CD/ROM so as to be able to use on my laptop,but unfortunately this file will not open upon the laptop useing word but will open useing Word Pad but all jumbled up File created on desktop useing word 2000 .Laptop is running Works Version 7.0.Message that appears on laptop ---There is not enough memor... 2 14.02.2006 13:31:13 VB MS Word header Hi, I have copied some code that previously wrote to a Word doc page to write to the page header. The code below is as far as I have got as there are some problems. 1. The font.bold and font.size do not work 2. The copy and paste of the logo.bmp does not work 3. The tabstops are at different spacings compared to those when set on a 'normal' page 4. The line does not draw. Can anyone ... 4 11.02.2006 11:01:37 Making a macro to edit all .doc files in a folder. I have a macro that edits the format and extention of a .doc file. making it go from portrait to landscape, then change the extention from ..doc to .rft. Now i need a macro that will automatically run the above macro for all the .doc files in a designated folder. Is this possible? ... 2 10.02.2006 08:19:44 Populating Excel Worksheet with data from Word VBA UserForm I am trying to find a method to populate an excell sheet with information that is entered into a Word userform that I have created. I am quite new to VBA and have had great difficulty in finding a solution. Can someone please point me towards the light! ... 3 09.02.2006 16:01:30 Opening word file Created a word doc on my desktop,a timesheet containing many rows & columns .. Copied same to CD/ROM so as to be able to use on my laptop,but unfortunately this file will not open upon the laptop useing word but will open useing Word Pad but all jumbled up File created on desktop useing word 2000 .Laptop is running Works Version 7.0.Message that appears on laptop ---There is not enough ... 6 09.02.2006 00:59:51 Syntax error calling MailMerge.OpenDataSource This is the only statement in a macro I've created. If I use only the first parameter (leave off the format parameter, 0), it works fine. If I add the zero, I get a syntax error. What am I doing wrong? ActiveDocument.MailMerge.OpenDataSource ("C:\OpenDataSource\OpenDataSource.xls",0) ... 5 08.02.2006 18:41:48 macro writing for beginners Hi I would like to learn how to write macros for Word 2000. Could someone recommened a book for beginners? Thank you ... 5 08.02.2006 16:45:32 Mailmerge Value in to a variable Hi I'm having trouble getting the value of a mailmerge field in to a variable. I think I may be approaching this the wrong way but as a test I put the following code into a template and instead of the actual value for CCode I get <<ClientCode>> Private Sub Document_New() For Each mmField In ActiveDocument.Fields If mmField.Code = " MERGEFIELD ClientCode... 7 08.02.2006 12:43:11 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