| Thread | Last Post | Replies |
|
| Deleting redundant lines | 06 Jun 2008 07:33 GMT | 1 |
Have the following kind of automated listings. Need to eliminate the duplicate time entries. Can't figure out how to compare current time to the previous time. See my preliminary macro at the end. There can be weeks of this. The macro gets no errors. Please no laughing out
|
| Using MOSS 2007 Fields in VBA - Word 2007 | 06 Jun 2008 07:15 GMT | 1 |
I have documents in a MOSS 2007 Document Library that has content approval and versioning enabled. I have two issues: 1. I want to display MOSS 2007 Document Version Information and insert it into a content control text box (or some other type of container?)
|
| hyperlinks and locked documents | 06 Jun 2008 06:44 GMT | 4 |
I have several Word Forms that are locked and I want to keep the forms locked but have an emal hyperlink and a website hyperlink. I have a VBA SubProcedure that I was trying to use Option Explicit
|
| Inserting footnote into automated word document from Access | 05 Jun 2008 21:14 GMT | 1 |
Hello, I am fairly new to Access databases and programming with VBA. However, my problem is this: I have a database in which I write information to a word document table using fields. The table size is variable so I have code which copies and
|
| Beginner question | 05 Jun 2008 20:51 GMT | 4 |
I'm using Word 2003 on a Vista Business box. I've tried to duplicate a macro shown in VBA for Dummies 4th Edition to remove highlighting of text. I'm searching for yellow highlighting and want to simply remove it. Where have I gone wrong - I keep getting a 91 error regarding ...
|
| Word 2003 Form Help | 05 Jun 2008 17:23 GMT | 6 |
I have just created my first form-template that incorporates the use of a GUI. The GUI has been sectioned into three tabs that represents the form in thirds. Some of the txt fields are multi-line with EnterKeyBehavior=True.
|
| manipulating multiple bookmarks in a document from an html file | 05 Jun 2008 17:07 GMT | 3 |
I have a Word 2007 document converted from an HTML file. Word has converted certain tags to bookmarks. For arguments sake, say "mikebegin" repeats multiple times throughout the document, represents a specific section in the document, and needs to be manipulated (e.g., changing ...
|
| Error 5941 with Bookmarked Formfield | 05 Jun 2008 16:11 GMT | 8 |
Error 5941 - The requested member of the collection does not exist. I get this error trying to apply a calendar result to a bookmarked formfield. The macro pauses and the following line is highlighted in yellow: With rng.Bookmarks(1)
|
| Deleting a Picture in a header | 05 Jun 2008 16:00 GMT | 5 |
I have inserted a picture in my header and filled it to the full page size. I have also set it to sit behind the text. I am now trying to select and delete the picture through VBA code. I can access the header but when I try to select the picture it won't work. I have
|
| Keep Width while copy | 05 Jun 2008 14:42 GMT | 3 |
I have a need to copy a range from a worksheet to a doc. many cells contain values in the following format: TEXT [99] the TEXT is for display and [99] is for other purposes.Between them are
|
| Appending/Deleting a (full page) table in a Word doc | 05 Jun 2008 12:03 GMT | 2 |
I have a one page form (table) that I want the end user to be able create a duplicate form on the next page (new). In addition I want them to be able to delete it. I have existing code that I found in this site that I have pieced together to enable me to accomplist this. I works ...
|
| Word 2007 Find Problem | 05 Jun 2008 11:27 GMT | 7 |
I have developed a macro which uses the Find.Execute method to locate a string with 2 x paragraph symbols (^p). e.g. "MAN" & "^p^p" This worked fine in pre-2007 days, but now with 2007, hangs the macro in a loop - it is in a Do...While loop, searching the Content range and should
|
| Another complicated Find/Replace via code | 05 Jun 2008 00:20 GMT | 3 |
That last find/replace had a lot easier answer than I thought it would! Hopefully this one does, too. I need to find the bracket sign } ...and if it is followed by a paragraph mark then do nothing. If it is not
|
| retreiving data from access via userforms - Word2003 | 04 Jun 2008 21:54 GMT | 4 |
I am working on a Word 2003 form that I am setting up a VBA userform. One of the things I would like to do is enter a customer number in a text box in he userform then have the userform go to a database on a server, look for the customer number in either an existing table or ...
|
| Renaming bookmarks when inserting file | 04 Jun 2008 20:39 GMT | 19 |
I would like to be able to rename the bookmarks on a document that I am inserting into a template new doc. The template has the abilitiy to add this document many times and I will run sql statements to populate some of the fields on the inserted file.
|