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   Working with Tables Any help on the following would be appreciated: Each week I download a table with three columns and numerous rows (generally about 300). The first column contains the name of a public company each of which is unique (i.e., there are about 300 companies each week and there are no duplicates). The second column contains the one of five weekdays on which they report their earnings: (M, T,... 3 16.05.2006 21:16:50 suping up Word's divisions They say a picture is worth a k'zillion words (or something to that effect), so here's my picture: http://www.renamestar.com/wordproshots/wordprodivisions.htm It's a screen shot of Lotus Word Pro's division feature. Every time I use Word, I miss this feature like crazy. It feels like having one hand tied behind my back. I've already plugged in via VBA four Word Pro features that I wouldn... 10 15.05.2006 04:25:49 Update Word document in background Hello, I have big performance problems with a VBA for Word program. In this program, I copy, add (or delete) and edit rows from one table to an other, many times. The problem is that Word update the screen at every modification and that's takes time ! Does someone know if it is possible to "bufferise" the modifications of the document, then, when all is done, update the screen with the mo... 3 16.05.2006 15:43:11 set Shape as range How do I set ActiveDocument.Shapes(2) as myRange? I tried: Dim myRange as Range set myRange=ActiveDocument.Shapes(2) ....but, of course, got an error, because a shape is a different type than a range. I thought about declaring myRange as a shape, but then it wouldn't be a range, and I couldn't manipulate it the way I want to. Is the ShapeRange object what I should be understan... 9 15.05.2006 20:58:03 Getting information about paragraphnumber when bookmarks, bullets Hi everybody, Any help about this will be appreciated. I'm working with a VBA-routine where a (big) Worddocument is copied to Excel and after that is edited and used in Excel in a special way. In the routin I need to find complementary information from the Worddocument like where bookmarks are located and subbullets are used. i can find bookmarks but I also need to get the paragraph nu... 2 14.05.2006 21:13:56 Best Practice for Word Inserts Hi: I am new to Word and would like a hint for the following situation. I have a long document with many tables and charts. The document will be updated automatically when a macro is run from individual .rtf and .xls files (generated automatically from a DB on a yearly basis). Would it best to put bookmarks in Word around each item, say, the title of the table or chart, then replace th... 3 12.05.2006 15:05:37 Macro to tab indent space indented HTML I've worked for about an hour trying to figure out a way <table> <tr> <td> <table> to be <table> <tr> <td> <table> I'm trying to format lots of source code. Any ideas? ... 6 10.05.2006 20:29:28 Userform radiobutton text length & on-the-fly placement? (Word97) I have an existing userform with a bunch of radiobuttons. The text for each radiobbutton is pulled from a file, and I originally set it up so that each radiobutton is in a fixed location with three lines of text, and that was sufficient to hold all the text _and_ show all the items (the number of items is flexible as well). In my most recent source file, which I don't have any control or in... 3 10.05.2006 00:06:19 Which VBA book should I get? I have about four years experience in VB 6 programming, plus I've branched out and have programmed a bit in REALbasic. I want to get up and running in VBA because I'd like to highly customize Word. I'd like to add features to Word that I miss from two other word processors, WordStar and Lotus Word Pro. The WordStar features that I missed have already been done for me in VBA by Mike Pet... 5 09.05.2006 06:22:10 invoke a VBscript from within a word macro hi, all I'm trying to invoke a vbscipt from within a word macro. I'm using RetVal = Shell("C:\docs\binfile.vbs", 0) however, this gives me an error: " Run-time error '5': Invalid procedure call or argument" Does anyone know how to do this.. if I replace the path of vbscript with an EXE file, it works fine.. and if I call the vbscript frm the command line. it a... 4 09.05.2006 00:21:21 Getting the user profile folder Hi I need to get the signature folder for the current folder such as; "F:\Documents and Settings\Dave\Application Data\Microsoft\Signatures\" except that instead of Dave I need the correct name for the current user, s that my code works generically regardless of who is logged in. Is there a way to do that? Thanks Regards ... 5 08.05.2006 00:44:38 How to pass a Function returning an array as a parameter Hello, If a have a function which returns a multidimensional array. How can I pass it as parameter for a subprocedure? Here's a skeleton of my code: Function CreateAnArray() 'code to fill a resizable array called MyArray() as String CreateAnArray = MyArray() End Function Sub UseOneArray(OneArray() as String) 'do things with OneArray() End Sub Call UseOneA... 2 05.05.2006 23:38:01 Clear All Form Fields? Is it possible to assign vba to a commandbutton_click that would clear form fields in a word document? I have a word doc with many form fields, and I would like to have a button that, when clicked, would clear just the form fields that have numerical values (bookmarked num1, num2, etc.), but not all of the form fields in the doc. Cheers, TMan ... 5 05.05.2006 19:24:29 Reading textfile How can i read with vba the content of multiple textfiles into a word document. The structure is: C:\Test\1.txt C:\Test\2.txt C:\Test\3.txt C:\Test\4.txt Can someone help me with that. Willem ... 2 05.05.2006 13:28:40 Clearing Form Fields on 1st Doc Open only? This seems it should be simple, but I'm spacing on it.... Hwo can I call the same macro from several Command Buttons without having to copy the script to each Click() event? So, I have a macro: Sub ShowHello() UserForm1.Show End Sub And let's just say I have three Command Buttons from which I would like to launch the userform. Right now I would have: CommandButton1_Click() Use... 3 05.05.2006 11:10:34 Modal form not acting Modally... I need to get user input before running code, so in the openDoc event of the addin, the modal userform ufmGenType is shown. As planned, when the addin opens, ufmGenType is shown, but the code continues to execute without waiting for ufmGenType to close. How can I make the ufmGenType act modally (and not allow any execution of code until it is closed)? Here's the code I'm using: Priva... 4 05.05.2006 03:58:56 Adding cells from a protected file to a master file I have 10 different files and 1 master file. I want to add few cells from the individual file to my master file. I have a macro but it brings back the values from the specified ranges, does not add anything. Is ther a way to change this macro to hep add few cells.....-------here is the macro i have Public Sub UPDATE_FORECAST_06() On Error Resume Next Dim objBook As Excel.Workb... 2 04.05.2006 09:37:03 Learning Excel Programming Hello, I have to prepare a report with graphs based on data on an excel sheet. To start with, I want to keep it simple and create few new worksheets for the report. Could some one help me in basic learning of the Excel programming. Thanks in advance. regards, TRN -- trnswamy Posted from - http://www.officehelp.in ... 2 02.05.2006 13:12:57 See my code in IDE????? I guess I'll just have to risk looking foolish. I have a few years experience with VB 6, and so I figured it would be a snap to dive right into VBA to create Word macros. I've recorded them and assigned each one to a hot key with no trouble. However, I'm having difficulty in opening my code. In regular VB 6, I've always clicked on the "view code" icon to see my code, and it's always w... 6 30.04.2006 19:35:35 inserting only first page from several files into a single file hi all, this is what I need to do: say I have a folder with several files, either doc or rtf files, each file many pages; I need to be able to have a single file which will contain only page one from each individual file; from previous threads, I have the code which would insert all docs into single file; Dim xFile As String Documents.Add ' Get files one at a time. xFile = Dir$(... 8 26.04.2006 18:31:37 Updating docvariable after insertfile Hi, I have a docvariable in several documents. In my VB6.0 program, I use insertfile to combine those documents into one document. What I need to do is change the value of the docvariable in the new document I have created with my insertfile. I have tried using the activedocument command, but that gives me an error that no document is open. I would appreciate any suggestions. Thank... 2 26.04.2006 04:04:00 Copy information between style I have an existing word document and I want to lift all the data which does not have the style "Heading 1" and paste it into a new document. This works fine by iterating thru the document and checking for Paragraph.Style the problem right now is that it converts tables into text, each field is converted as a single paragraph. Is there something I can do to work around this? thanks... 4 25.04.2006 03:55:01 table to text macro - formakler.doc (0/1) Hi, I am quite new to vba and am trying to take text in a table and create from it phrases. I enclosed a word doc with one such table. The first non header row contains: Modulator 1 ASI-R Modulator 1 ASI-R/IPE 1 Out 1 IPE 1 OUT 1 IPE 1 Out 1/Modulator 1 ASI-R I need it to create a two phrases as follows: Connect one end of the Modulator 1 ASI-R/IPE 1 Out 1 cable to the Modulator ... 2 24.04.2006 19:10:20 Template with VBA code works differently in Word 2003 I'm new to the list and a novice at vba so I hope this is clear...Thanks in advance. I have some doc. templates with vb code that brings in data from a .csv, names and saves the doc. In word 2003 i am getting a new dialog... 'opening this document will run the following sql command select * from C:\Program Files\Filemaker\etc\TempleteMerge.mer Data from you database will be placed in t... 4 24.04.2006 17:56:11 Cursor on page break line Hello all! Document in simple word page view (text mode): Page 1 text row 1 Page 1 text row 2 Page 1 text row 3 ·········································Page break········································· Page 2 text row 1 Page 2 text row 2 How can I determine if my cursor on page break line or not? ... 3 24.04.2006 05:15:21 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