| Thread | Last Post | Replies |
|
| Letterhead Macro | 30 Apr 2007 07:13 GMT | 1 |
Below is the macro I made to set the printer to print on letterhead. Here are the settings I want: Page Setup to [Tab] Paper: 1. Paper size: 8.5X11" Letter
|
| Insert procedure into templates | 30 Apr 2007 06:08 GMT | 2 |
I need to insert a procedure into an existing module in numerous document templates. Is there any way to script this? All templates have the module and the procedure must be inserted into a specific location in the module. I would also like to modify an existing procedure (eg add ...
|
| Word 2007 and old document compatibility | 30 Apr 2007 04:20 GMT | 1 |
I have to open Word 2007 document files and Older Word version document files and then to process these files within a macro. Unfortunatily, I have some problems when I open automatically these files due to the "Compatibility Mode". In fact, when I get a file name (by .name or
|
| Weird behavior with Range.Delete | 30 Apr 2007 02:36 GMT | 6 |
This is too weird. Open a new word document. Enter a few characters. Open VB and enter this subroutine: Sub deleteChar()
|
| Drawing lines | 29 Apr 2007 23:34 GMT | 2 |
I have converted documents from WordPerfect to Word and I am trying to drawn a line in selected locations. Where ever I have 10 spaces I want to replace it with no spaces and at that same location draw a line. Below is my macro but it’s not working. What am I doing wrong?
|
| Continuous section break | 29 Apr 2007 23:30 GMT | 6 |
I have documents that I am trying to clean up. They have numerous Section Break(Next page) and Section Break(Continuous) in them. I am trying to write a macro to just replace the Section Break(Continuous) with a hard return. What I have written below replaces all the Section ...
|
| Help | 29 Apr 2007 17:28 GMT | 2 |
I have 3 worksheets in my Workbook. Each sheet is from 3 separate years AA05,AA06,AA07 and named accordingly. I have this code to check each Column B of all the worksheets for matches and I was hoping to return the results of the unmatched to a new Output sheet. Can anyone
|
| Attached template problem | 28 Apr 2007 20:34 GMT | 3 |
We have word documents on our network (Word 2002, Windows 2000) that used to be attached to templates on a server that no longer exists. The attached template has since been reset to normal.dot as all documents have been opened and resaved programically.
|
| Registry changes | 28 Apr 2007 19:56 GMT | 1 |
I have installed a Word template that is causing havoc with my system. I used System Restore to get rid of the offending template but I really need to install the template. Is there a way that I can track what files, programs and/or registry entries
|
| using the if statement to display a picture | 28 Apr 2007 15:52 GMT | 1 |
I would like to use a Word template to display one of two pictures i.e If the field value is 0 display picture A otherwise display picture B in a document
|
| Connecting to access 2003 database | 28 Apr 2007 10:43 GMT | 1 |
I need to create a form that connects to access 2003 tables. This will allow users to either use their access interface or use Word to create a new entry. Suggestions?
|
| Word2007; width of toolbar dropdown list | 27 Apr 2007 23:38 GMT | 6 |
In 2003 and below, I can create a dropdown list in a new tool bar like this CommandBars(listnameis).Controls.Add(Type:=msoControlDropdown) control its width with the ".width = ###" command. In 2007, with all addins shoved into the same window, I no longer seem to be
|
| Calculate text1 * text2 and output into text3 | 27 Apr 2007 22:44 GMT | 10 |
I have collection of form fields, and I want 2 of them to do a calculation in text3 Text 1 and text 2 are (numbered) editable text form fields, which the user can put a number into, and text 3, is a calculation.
|
| Macro which can create multiple files out of one | 27 Apr 2007 19:12 GMT | 2 |
I don't have a code written for this. I need to build it from scratch. I know how to do basic macro recording (changing font size and date etc). Here is the 1st thing that I need the function to do.
|
| Macro to split up Excel files that are larger then 65,000 rows | 27 Apr 2007 19:05 GMT | 1 |
Can someone please help me!! I am looking for a code which can split up Excel files that are larger then 65,000 rows. For now I was using text pad and access, but it's taking too long.
|