| Thread | Last Post | Replies |
|
| IF field to check a range of Excel cells works with blanks not fal | 31 Mar 2009 21:39 GMT | 3 |
If I want for word to check a range of cells to see if they're empty or not, this works: { IF {LINK Excel.Sheet.8 "\\\\Server\\data\\Info.xlsb" "Client!R2C2:R10C2" \f4 \r } = "" "No data" "There is data available" }
|
| Choose margins at startup | 31 Mar 2009 19:17 GMT | 13 |
Is it possible to write a macro that does this: Run at word 2007 startup, Check font of first word, Change margins if font is Courier New
|
| How to get non-overlapped page numbers? | 31 Mar 2009 17:26 GMT | 6 |
Please tell me how to get non-overlapped page numbers indicating the pages, in wihch the found text exists in a document. For example, when "steel" is shown twice in page 3 and three times in page 5,
|
| macro to unprotect and protect | 31 Mar 2009 16:02 GMT | 1 |
I have a form template, when the user opens, they can tab from field to field to fill-in information and save it as a doc., then will another detective has a form to fill out that goes with the saved doc, they can open the saved doc, unprotect the doc run a macro that will insert ...
|
| WordApplication.Visible is not setting to True | 31 Mar 2009 15:47 GMT | 4 |
I am trying to programaticaly set word application visible=true and it does not let me. Dim WordApp As Word.Application = Nothing WordApp = New Word.Application
|
| Change text in a table in a header | 31 Mar 2009 15:39 GMT | 2 |
I have a header that contains a table to which I want to put text into each cell in the table. I am having a problem writing to that table. When I run the code snipit below I put in a table(1).select to be able to visually see
|
| I need a macro that changes the level in some text | 31 Mar 2009 12:42 GMT | 1 |
Hi all, I have a very long document (a techical specification) formatted in a very bad manner. There are a lot of paragraphs outlined as "level 1" (typically the tables description or the figures description). I want to change this text to level
|
| How do I populate a DropDown menu in real-time in Office 2007 | 31 Mar 2009 11:08 GMT | 2 |
Background: I want to create a DropDown menu with the recent company templates used. If a user opens a template, that template is added to the DropDown menu. We have this system already today in a form. But it would be nicer to have it
|
| Using imagecontrol where impossible to use file as imagsource | 31 Mar 2009 10:54 GMT | 2 |
I need to find a way to generate an image (based on a choice in a listbox, but that is not the problem) in a userform in an environment where it is not feasible to store the image-files in a known and referable location. I manage a large organization with Office 2000, Office 2003 ...
|
| Insert pictutes | 31 Mar 2009 09:56 GMT | 1 |
I'm using VBA to insert photos in specific cell in a table Set myrange = ActiveDocument.Tables(1).Cell(1, 1).Range myrange.InlineShapes.AddPicture photoPath, False, True myrange.InlineShapes(1).ScaleHeight = 0.25
|
| Search and Replace Multiple html documents | 31 Mar 2009 09:34 GMT | 2 |
I have a word document which contains of two columns. First column consists of texts that I want to find in multiple html documents. Second column would be the Replacement Text. Hope this makes sense. Is there a simple macro that I can use for this purpose?
|
| Macro stuck in infinite Dir loop | 31 Mar 2009 09:27 GMT | 1 |
I've tried to cobble together some code based on snippets given by the experts here to run one or more macros on all the files in a folder. Unfortunately, it keeps opening and and closing each file in an infinite Dir loop. Can anyone see what's going wrong? I've tried all sorts ...
|
| Looping and omit certain interations using an InputBox | 31 Mar 2009 08:11 GMT | 2 |
Dear Experts: I wonder whether it is possible to iterate through a collection of objects and omit a couple of iterations by entering the iteration numbers to be omitted into an input box and then let the macro run.
|
| Macro to embed documents | 31 Mar 2009 07:10 GMT | 1 |
I'm about to pull my hair out. I've been working on this template for 3 weeks now. I can be my documents to open using custom toolbars with macros using a program that embed documents.
|
| Table Column Widths/Skipped Lines | 30 Mar 2009 22:59 GMT | 4 |
I have a macro creating a table and formating the column widths in Word 2000, where it works perfectly. In Word 2003 or 2007, it skips the width formating. Code: ActiveDocument.Tables(1).Cell(1, 1).Select
|