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   Read csv text file and write to new file stripping header and end f file char All, Can anyone tell me hoe or provide a sample vb script that will read a csv text file and write it to a new file without the header and the end of file character ? TIA! cmoorhead@mindspring.com ... 8 30.11.2005 13:37:45 QUERY: auto clean VB editor Is there any way to auto clean indent the VB code? If not, anyone know an additional 3rd party program to do so? Such cleaning eg. removing trailing whitespace, formating/correct indentation, etc. ... 2 29.11.2005 19:30:49 Coding ENTER to move to next form field in Word97 I have no practical experience with VBA, or even VB, but I hope I will sound like I know what I'm talking about. I have an Online Form in Word 97. The document is protected, and I have set length limits on the number of characters and format restrictions in each of the fields. When the user presses ENTER in any of the form fields, it adds a paragraph to my document, and screws up the... 5 29.11.2005 05:37:54 Goal: Macro1 calls/triggers Macro2 and passes strVar value to Macr I can't figure out how to get a word vba macro to call a second word vba macro, and pass a string variable's value from the first macro to the second macro. Any help (e.g. [1] example(s) and/or [2] URL references where I can find info about how to do this) would be much appreciated. Thanks, marceepoo... 2 29.11.2005 02:51:01 This works in all templates except Normal Hi Folks, Can anyone please tell me what I need to do to make this work in my normal template? The UserForm is located in the normal template together with the follwing code; but I get: "Run Time Error 5. Invalid Procedure Call or Argument" Public Sub Test1() Dim frmU1 As New UserForm1 Load frmU1 frmU1.Show End Sub TIA Philip ... 4 28.11.2005 21:22:27 Capture text from Word 2k-Err mesg 'object refers to a protected a I need to write a script to fetch text from an opened word document. I am using the below script; --------------------------------------------------------------------------------------------- Dim wrdApp Dim wrdDoc Dim tString, tRange Dim p, startRange, endRange Dim searchString Set wrdApp = GetObject(,"Word.Application") Set wrdDoc=wrdApp.ActiveDocument MsgBox wrdApp.ActiveDocument.Name ... 2 28.11.2005 20:48:44 Word 2003 : show/hide table Hello, I try to build a vba macro where I have 10 checkbox and 10 table. When a checkbox.value is true then the corresponding table is shown. When a checkbox.value is false then the corresponding table is hide. When a checkbox.value was false and bacome true, then the table is shown again at it's old position. To hide a table, that's easy (delete). But to show it again, I can't find how ... 4 28.11.2005 19:50:22 Macro to print multiple copies of 1 document Hi I have a form I have created in Word that I need printed 3 times each time it's filled out. Is that a macro that can do this automatically? Thanks Melanie ... 4 28.11.2005 10:29:19 Macro Help needed. I have never created a macro before and need some help. I have a Word 97 file that is a Directory of individuals, their Lodge, e-mail address and a flag symbol in four columns of a table. Column 1 are the names of individuals Column 2 is their lodge (Names of cities) Column 3 is their e-mail address Column 4 is a flag image I would like to be able to sort by any of the first three co... 4 28.11.2005 01:01:18 FAQ - frequently asked questions - vba - please read before posting - unofficial November 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 25.11.2005 14:57:03 More VBA Help I got the macro working to automatically print multiple pages now what I would like to do is print something only on copy 1. It will be a small text box. Can someone help? Thanks Melanie ... 3 24.11.2005 19:25:18 Search for text in the header? Or in a bookmark? I would like to search and replace text in the header and body of an active document. However, I'm having trouble figuring out how to code a macro to search in the header of the document. I thought that I could perhaps capture the necessary information by going through the search and replace process using the macro recorder. Unfortunately, the code that process generated didn't work proper... 3 23.11.2005 18:43:50 HELP: compile error message This is referring to the Office Excel VB. Excel VB claims it is just like VB. I am wondering where on the internet how I can find out whether a function existed for a particular version of Office Excel VB? For example, I am using Office 2003 but my clients are using Office 95, or 97. Am wondering whether the string function Left() & Right() existed in Office 95/97 Excel VB? If so, then ... 2 23.11.2005 18:03:32 use the shell command to open a word file in My Documents This works: strCommand = "winword.exe C:\test.doc /mDoThis" varMyDoc = Shell(strCommand, vbMaximizedFocus) When I execute this, I get a file not found error: strCommand = "winword.exe C:\Documents and Settings\mbartley\test.doc" varMyDoc = Shell(strCommand, vbMaximizedFocus) Same thing for this: strCommand = "winword.exe 'C:\Documents and Settings\mbartley\test.doc... 3 23.11.2005 06:11:17 Extract data from Tables in Word documents to Access Need help extracting data from Tables in word documents to access database I have thousands of word document invoices that I need to extract about 25 pieces of data anD create an access database. The Docs are the same format as shown below and the flags will be the same as the field name in the DB and each Doc will be a record. The document has 7 lines of standard text as a title, then Th... 5 23.11.2005 05:19:16 An odd problem I know this is more of a technical issue rather than the sort of question that is usually asked here, but maybe someone here has encountered this before. It only happens with Word VBA Just yesterday when I was designing an object I noticed that when I was resizing an object my mouse cursor would not change to the direction arrows. In fact after quickly experimenting I noticed that the curso... 2 23.11.2005 05:05:55 Search for text in the header? I would like to perform a search and replace for text in the header of an active document as well as in the body of the active document. I can perform the search and replace without any problem if the text is body, but I can't figure out how to use VBA to search the header. I tried using the macro recorder hoping that would capture the necessary information, but I couldn't get the macro to... 2 22.11.2005 22:40:22 How to delete a range of text base on keywords? Hello all. I am trying to format a log file from ACL that is inserted into Word. There is certain code when commented that we do not want to show up in the Word document. I cannot seem to write a successful loop to do the following: 1) Search for the phrase "COMMENT - Begin Delete" in the word document 2) Delete that phrase and any subsequent characters until it finds the next phras... 4 22.11.2005 22:20:05 Attaching/creating tool tips to buttons on the Word toolbar? This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C5EDF7.C8A097C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable XPP SP2 Office 2003 SP2 Hello, After creating and placing a button on the Word toolbar - with an = attached macro - the Tool tips displays the name of the macro, including = possible underscores, ie ... 6 22.11.2005 20:11:36 Insert Generic text starting from a bookmark Greetings, I have a document (template) where i need the user to be prompted for how many entries of some information will be appended (inserted) into there document. I need to spell it out for them where the heading is and where to insert the file. So for example if the user needed to insert 5 seperate files into this document the user would type in the number "5" and then the macr... 2 22.11.2005 10:43:32 Dividing sections - Formatting Hello, I have a dot file with content of 2 pages. I have divided these 2 pages into 3 sections from Menubar -> Insert -> Break -> Section break Types -> Continuous Now what i need to do is to BOLD the content in the second section. How can i do this??? Tried this option but not working... ActiveDocument.sections(2).range.bold = true If the document is having two section... 4 22.11.2005 04:27:56 Word VBA: Problem and questions about Options.DefaultFilePath(Path) I need to programmatically, WordVBA, access the path info that I can find in Tools-Options-File Locations: Documents Seems simple enough: myDocPath=Options.DefaultFilePath(wdDocumentsPath) But when using this, the myDocPath variable actually shows the last accessed File-Open path or the File-Save As path, not what I read in Tools-Options-File Locations: Documents Why? Bug? My err... 1 21.11.2005 17:40:06 Coding help please. Could someone please help me with code for a routine which is part of a longer macro. At the point where the routine is needed, my document contains two similar tables. Table 2 is a look-up table from which data is copied into Table 1 before being deleted. Each cell contains just one word - apart from a few blanks. Without using "Find" (for complex reasons) I need to scan Table 1 Column 1 for... 11 19.11.2005 14:43:14 Help with Macro to Change Font Color Hello, I'm looking for a macro that will search a Word document (I have Word 2003) for a given character (in this case an asterisk). Once it finds the character, I would like for that character and all the characters to the left of it, until the first space to be a specific color. There could be zero asterisks to hundreds of asterisks within a single document. As an example, ... 4 18.11.2005 23:03:16 Problem using VBA to create sequentially numbered documents in Word Hi, I am using a certain Autonew VBA program to automatically generate a new invoice number every time a certain word document is opened. Everytime I use it, it works great UNLESS I switch users on my computer, it which case I get the error message "Method 'PrivateProfileString' of object 'System' failed" Any help is greatly appreciated. Here is the code, which was borrowed from Doug Robbin'... 7 17.11.2005 20:44:01 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