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   Copy and paste a column of data accross another sheet Hi VB Excel 97 I want to copy a column of data from one sheet to another. The pasted data to run from left to right accross the sheet with no spaces. ... 2 23.04.2006 08:31:50 FAQ - Frequently Asked Questions - vba - please read before posting - unofficial April 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-... 3 23.04.2006 23:32:25 table to text macro - formakler.doc (1/1) begin 644 formakler.doc MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````.@``````````$```/`````$```#^____`````#D```#_____________ M____________________________________________________________ M____________________________________________________________ M____________________________________________________________ M_________________________________________________________... 1 23.04.2006 04:23:58 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 ... 1 23.04.2006 04:21:24 Insert Rows (using Range object) So, here's my latest problem in my quest for Range.objects ("Give me range, lots of range...") What code works for inserting rows in a range object, if the following code works with a Selection object, Selection.InsertRowsBelow (8) TIA (Please forgive my singing -- it's Friday.) ... 10 21.04.2006 23:30:10 Need to know Office version in VB.NET 2005 Hello I am new to Office development. I am working on "Document Generation System". Problem is that the system works only with "Microsoft Office 2002 SP2". Now I want to know how to get version related information to restrict users having diferent version of MS Word. Looking for a quick and good response Thanx Asif Hameed... 2 21.04.2006 08:38:21 global macro to add text My poor brain.... I have not found answer to this after searching for some time. I have this macro: Sub foo() Dim rng Set rng = Range(Start:=0, End:=0) rng.Text = "Foobar" End Sub And when in a global (startup) DOT it does not work. I have failed to find the way to tell it to refer to the active document. What am I missing? ... 2 20.04.2006 17:41:01 Word Locked Form Field Focus In a locked Word document with several form fields, is there a simple way to make whichever form field the user tabs into center on the screen? Sometimes after tabbing in my form the cursor goes to the correct field, but the only way to see it on the screen is to scroll the pages up or down. Thanks, Chris ... 3 20.04.2006 15:38:28 Jumping/Skipping Form... Howdy again, I have a locked Word document with several form fields that have macros that calculate on Exit. The macros are fine (thanks to help from many of you!); however, each time I tab out of a field to go to the next field, the entire screen 'jumps' first (obviously as the macro calculates); then, although the next subsequent field to be filled is selected, it is all the way down at... 5 19.04.2006 22:54:26 Word Macro won't record Word 97, Windows XP Home I use the macro recorder to automate various tasks. I don't hand edit the macros, except to remove a line here and there. I made a macro to insert a Word file that has many links from an Excel sheet. The Word file is a report, displaying noise data in a client-friendly format. We prepare a report, then lock the linked data and save it for that client so the report ... 13 19.04.2006 14:53:24 Tricky: Word Table Conditional Formatting Hi there, I've got a stumper..... First, I have a Word document with several form fields. Some of these fields calculate into subsequent bookmarks. The problem: At the end of the Word document, I have a simple "Overall Score" table that is 2x4, laid out as such: Ranking Rating Fair 0-.99 Good 1-1.99 Great 2-2.99 Excellent 3-4.00 The rati... 9 18.04.2006 22:35:51 ms word cursor location Hi Can anyone please let me know what code should be written to find out the current cursor location in a word document. Thanks NG ... 3 17.04.2006 15:18:30 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:45:33 Saving backups Hi. I am new to VBA for Word but I already know a couple of things in VBA for Excel. I'd like to program an autosave sub that would save a .doc file automatically to a specified location (on my home network) each time the 'save' button is pressed. I have seen in the VBA help that it can be done through a Class module and an event handler. I am afraid this is far from what I can take. Ca... 5 15.04.2006 23:03:58 finding a macro to delete it i recently created a macro for fun and out of ignorance that mimics a virus it is an autoexec in word it ends the program when you end the macro how do i find the file to delete the macro or do i have to delete and reinstall word ... 3 15.04.2006 06:57:17 Interpretation, please... (Declare Sub) I don't know exactly why/how this sub works, but it does. (Thanks for giving it to me, guys.) Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) To further my understanding, could someone please explain exactly what the terminology means (i.e., "Declare Sub" versus "Sub" and "Lib "kernel32""), and why it has to be declared first-off in the module? TIA ... 3 14.04.2006 21:47:49 Macro is needed for table rows and lines Dear All! Please help! I have a bilingual text in several two column tables. Some rows contain titles, which should not be at a page bottom (line 61 or 62). So, I need to define all the titles as table number and row number. If the row number is on line 61 or 62, insert page break. Thanks in advance! Best regards, oprydoro ... 2 12.04.2006 22:13:55 Add Check box field in Word I have design the form in word doc. This form for user fill in after via e-mail send back to me. So I want to add 6 check box for user fill in. Please advice how can add the check box in this doc. The word in office xp ver, also this vba is note sure run on Mac word.. Thanks ITIT ... 2 12.04.2006 20:05:51 New to VBA - Help Hi, I'm new to VBA and this task is beyond my knowledge of VBA so any advice would be great. I have a list of data set out like so in worksheet 3: 1 A N 1 B N 1 C N 1 D N 1 E Y 1 F Y 1 G N 2 A N 2 B N 2 C Y 2 D Y 2 E N 2 F N 2 G N 3 A Y 3 B Y 3 C N 3 D N 3 E N 3 F N 3 G N I want to create a macro that will look down colunm A and if value below matches take the value... 3 11.04.2006 16:19:51 Goto Option_Button; Calculations; Auto-update; Even Colors! I've got what is probably not a terribly hard bit here, but I'm still very new to VBA in Word and I'm stumped. Here's what I would like to be able to do: I have a Word 2000 form that has several rows of rating criteria; the ratings are from 1-4. Managers have eight (8) criteria to be rated, while non-managers have five (5). I have put in a userform with two option buttons and the questi... 2 11.04.2006 08:26:01 How do I insert a custom control (OCX) into MS Word? Hi Ive created a custom control using Visual Basic and would like to incorporate it into one of my Microsoft Word 2002 forms. In Word, if I try to open it through the Insert.. Object... file menu, it does not show up in the object type list. If I try to insert it through the "create from file" tab, I get a box with the name of my OCX on it. I can insert the control with no problems... 2 11.04.2006 08:26:00 Save As Automation Hi there I am converting a large amount of pdf documents into Word format. The program I am using will perform multiple conversions at once when opening the PDFs into word (PDF Convertor 3) Unfortunately it wont bulk save them. At the end of opening all thedocuments, I am left with multiple documents open in word. If I click on "SAVE AS" it opens a dialog box with the suggested file na... 7 11.04.2006 04:07:51 Macro for LineCount Hi i have to made a macro for word file but its taking the blank line too i have to remone the counting of blank line, im new to this pls help. I have to make it as line count for every line but if the paragraph start it should count per 65 char as a line count and no blank line the code is :- Sub LC() Dim LCOUNT As Integer Dim CTST As String Dim CSRT As String ... 2 08.04.2006 11:27:44 Save each section to a separte file My brother regularly receives a large word document which is organised as a series of sections - one section per page. Is it possible to write some VBA to open myfile.doc and write out each section to it's own file e.g. myfile.001.doc, myfile.002.doc, etc? I've fished around in Word 97's object model here at home but I can't spot the solution. I'd really appreciate any help, Mart... 3 07.04.2006 05:21:58 Newbie Macro Question: Deleting all words on a line except a special string Hello. First off I want to apologize because I already posted in microsoft.public.word.word97vba but upon further research, I think this is the better newsgroup for this issue. I'm really learning macros to work with this current project. I have tons of logs with lines looking like: unknown (serv-2-4-73.lycos-vds.com ): 15 Time(s) All I want from lines like these are (serv-2-4-73.... 2 06.04.2006 17:27:15 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