| Thread | Last Post | Replies |
|
| Calling up a WORD document from Excel - How to make the WORD doc always on top | 13 Jun 2007 11:41 GMT | 7 |
I have a WORD document that is called up from code within Excel. My question is can I put code into the code in Excel that when this document is opened (by the code) it will always open on top?? right now it won't go to the top to save my life.
|
| turn off echo/prevent visible activity or screen refresh | 13 Jun 2007 09:01 GMT | 10 |
I'm running a macro in Word 2003 that really chews up memory with the 100 or so DB records I'm processing with it. I'm thinking that if I turn off screen refresh (sometimes called echo, I believe) while it's running then back on again when it's finished, this might speed up the ...
|
| Insert images | 12 Jun 2007 23:28 GMT | 5 |
One of my clients wants to simplify some procedures in Word. They frequently add several images into Word documents, from 50 and up to 150. They create huge reports, and inserts the images at the end of the report.
|
| Displaying Image from database into a Word Document | 12 Jun 2007 22:18 GMT | 3 |
I'm really struggling to find a way to do this, I need to display various images that are stored in a SQL Server 2000 Database inside a Word Document but can't find any real information on the net about this. I have knowledge of using ADO.Stream object to read and write binary, but
|
| Folder Tree in Word Document - directory.docx (0/1) | 12 Jun 2007 21:26 GMT | 1 |
Is there a macro, or someone who can help write a macro to do the following: I have attached a sample docx file to demonstrate what I am trying to do which is this:
|
| Clearing/Resetting document bookmarks via the UserForm | 12 Jun 2007 21:06 GMT | 2 |
Great tutorial, I just finished and my UserForm works (once). The fields from the UserForm are placed into the document at the bookmarks using the .InsertBefore feature. Now I would like to add a 'reset' button to clear the document (after printing) so it can be filled out
|
| Calendar Control | 12 Jun 2007 20:53 GMT | 1 |
Could someone please tell me how to use a calendar control in a worksheet. For example, Cell A1 is a required date field. Is it possible to have a calendar control pop up when you click on cell A1, select a date and have the date selected entered in cell A1.
|
| Code to enable, disable the mute check box and set volume control | 12 Jun 2007 17:53 GMT | 4 |
Does any know how to write code that will change the mute settings and volume for the "Volume Control", "CD Player", "Line In", and "Phone" that are displayed in the Windows "Volume Control" form?
|
| Need Word Macro Help Please | 12 Jun 2007 17:39 GMT | 17 |
I have a macro that I've written with some help from others in this news group. I have one last piece that I need help with. The macro does a find and replace on a range of text. After I do the find & replace, I need to select a range of text to copy to
|
| Searching a string | 12 Jun 2007 17:32 GMT | 3 |
I would like to seach a string (an example of the string is "template1-letter_head_template.doc" ) to see if it contains a "-" symbol and then run some code if it does and run some other code if it doesnt. I was planning on using an if statement, but i cannot find a function to
|
| Can I add icons to the standard set I have available in word? | 12 Jun 2007 17:31 GMT | 1 |
I want to use custom icons when I create macros and assign them to a toolbar.
|
| VBA help | 12 Jun 2007 17:17 GMT | 2 |
Can anyone help please, I have the macro below which selects 1 of 2 forms based on critera in an excel spreadsheet cell. What is not happeneing , is that a normal word doc should open from the word template its based on. But the macro below opens the .dot template....not ...
|
| Capture print events in Word 2007 | 12 Jun 2007 11:23 GMT | 2 |
I am creating an addin and one of the features it needs to do is save a copy of the Word document to an audit trail when the document is printed. Does anybody know how I am able to capture print events within Word 2007? I can't find any information regarding capture events in ...
|
| Word Mailmerge format change mid-field | 11 Jun 2007 22:46 GMT | 4 |
Using Word 2003. I have a series of contracts and other documents that are created using a Word mailmerge from a dBase .dbf file. The dbf is in Version 4 format. (at least, I'm told it's in db4 format - my old copy of dBase 5 for DOS opens it fine, so it isn't in anything newer ...
|
| error handling | 11 Jun 2007 22:31 GMT | 5 |
I'm using the following code to move a file: Name oldpathname As newpathname However my code errors if there is already a file of the same name at the new location.
|