| Thread | Last Post | Replies |
|
| Embedding macros | 08 Feb 2008 06:31 GMT | 1 |
We are converting thousands of WordPerfect documents to Word. I have created templates and macros to help make it easer. The problem is that everybody in the company has accuses to them to make changes and if they don’t have the templates in their computer, the macros don’t work. ...
|
| Application.Visible = true does not focus on the application | 08 Feb 2008 01:57 GMT | 2 |
I have a Outlook macro that will generate a customized Word document for a given meeting request. I found out PrintOut does not give you a print dialog box so I just set Application.Visible = true to let the user print the stuff themselves.
|
| Bookmarks | 07 Feb 2008 23:16 GMT | 6 |
I have created bookmarks in a table. However when a user enters new information in the field the bookmark is erased. I have tried using the following code: Dim BMRange As Range
|
| Change Color | 07 Feb 2008 21:44 GMT | 2 |
I have a table cell with a drop down field with four options (good, caution, problem, fix). Depending on the user's pick, I want the table cell to change: If good then green If caution, then yellow
|
| Hyperlinks in Protected Forms | 07 Feb 2008 18:38 GMT | 2 |
Hyperlinks in Protected Forms do not work except when using Macros or when sectioning off your form around the hyperlinks making the links vulnerable to editing. There should be a simple and straight-forward way to keep links working
|
| Different Effects App/App with IDE visible??? | 07 Feb 2008 13:23 GMT | 1 |
I've been annoyed by this for years, but now to try and do something about it... Word 2002, currently under Vista HP (but it was the same behaviour under XP...)
|
| Testing for existance of Custom Document Properties in VBA | 07 Feb 2008 10:37 GMT | 3 |
How would I test for the existance of a Custom Document Property in a Word Document from another application Like Access or Excel? My document name is "STD Compliance.doc". The Custom Property is "MailStop". It's value is set to "Regular".
|
| Delete WordArt from Header | 07 Feb 2008 10:15 GMT | 3 |
I have set up a macro to insert a file in each section/page of a header. The code is: Dim s As Section For Each s In ActiveDocument.Sections
|
| Setting focus back to userform | 07 Feb 2008 03:21 GMT | 2 |
When my code uses the pickfolder to select an Outlook folder, it takes the focus to Outlook, then leaves it there even after the user has selected a folder. Can I have my code set the system focus back to the userform, immediately after i run teh pickfolder command?
|
| VB Error? | 06 Feb 2008 21:08 GMT | 3 |
Hi Guys, I have a sign in sheet template that I use and have the following code in it. It is supposed to print my template consecutive dates at the top of each sheet as per my instructions in the vb code. Im sure this was working correctly but now when I run it, it brings up ...
|
| if statement not working! | 06 Feb 2008 15:48 GMT | 1 |
I am trying to have a macro loop through the cells in a table (Word 2003), and based on the shading color of the cells, either convert the text in the cell to a nested table, or do nothing and go to the next cell. Code:
|
| how to rename file based on title of document automatically? | 06 Feb 2008 15:32 GMT | 1 |
I have many documents to create. The only difference is the title of the document. I want to manually put in this new title and then do a save as to have it rename the word file to match this title.
|
| Passing criteria for queries in macros | 06 Feb 2008 14:25 GMT | 1 |
I use Excel Macros to search databases using ODBC. I have a macro I wrote that performs queries on 4 different databases with the same search criteria. Currently, the macro runs each query separately and prompts the user 4 times to enter the same start and end date and
|
| Help with sub to change source file name for source links | 06 Feb 2008 14:05 GMT | 2 |
Hello. I am try to write a sub to automate the process of changing all of the Excel links in a Word doc by having the user point and click the new file. There are over 200 links in each doc and they are set to update manually. These links represent both in-line text and pictures ...
|
| Use Macrobuttons to insert text at different places of a document | 06 Feb 2008 12:49 GMT | 1 |
I would like to use macrobutton to insert text at various places inside a document so that updating text at one macrobutton, it updates all the text at other macrobuttons. For example, I use five macrobuttons to represent the same addresses
|