| Thread | Last Post | Replies |
|
| hide page number when Landscape | 02 Sep 2006 11:06 GMT | 3 |
I am trying to hide page number when the page property is Landscape. My word document contains pages in both portrait and landscape view. Or it will be really cool to write something like ...if page property is Landscape ....show page number at x" from to top and y" from right..
|
| UpdateFieldsAtPrint | 02 Sep 2006 10:58 GMT | 5 |
Hi. I'm only new to VBA and use it only to create user forms for templates. I have a template which has a user form that shows with a new document (autonew - show form). The user then enters the information into the form which in turn places the information throughout the ...
|
| How to make a macro repeat itself? | 02 Sep 2006 10:43 GMT | 3 |
I need to process a large table with a repeatable action. I have recorded a macro and it works fine. The problem is, I need to make the macro repeat itself until it reaches the end of the document. How to do it?
|
| Add a hyperlink to dropdown box | 02 Sep 2006 00:43 GMT | 5 |
When designing a web page in Word, how can I put a hyperlink into a dropdown box? I would like it to show the short name and not the URL. I have several pages I would like to list and give others a choice.
|
| How can I reset page number in a Page field in the middle of doc? | 01 Sep 2006 22:31 GMT | 3 |
I am trying to create a template where the page numbers reset in the middle of a document. I need to use a Page field to hold the page number. Is there a way to reset the page number with a switch or something? Thanks
|
| how do i set up random numbers in a cell & row? | 01 Sep 2006 21:49 GMT | 2 |
here is what I am trying to do: I have 6 rows like so 01 01 01 01 01 01 goin down rows 1-5 I want random numbers from 1-55, In row 6 I want random numbers 1-42. How do i do that?
|
| Unable to "Save AS" document...I get a read only message. | 01 Sep 2006 21:04 GMT | 1 |
I am unable to "save as" a document in word. Even though I am the administrator and have not choosen "read only" I am unable to save a document after making changes when I try to save to my E drive. This is not removable media, it is a hard drive. If someone can help me I ...
|
| VBA question for "save as" function | 01 Sep 2006 20:47 GMT | 3 |
I am creating a Macro that will save the currently open .doc file as a .txt file of the same name. In the following line, what do I need to change/add to make the file save as the same name as the currently open file? ActiveDocument.SaveAs FileName:="<current filename>.txt", ...
|
| Selecting just one word in document | 01 Sep 2006 18:39 GMT | 5 |
When I use: Selection.Words.Count with nothing selected I get Selection.Words.Count =1 I get the same result when I actually select just one word (which I
|
| VBA Code | 01 Sep 2006 18:29 GMT | 2 |
I have a seeming simple task that I can't figure out. I have a macro set up to refresh a query and then do some copying and pasting of cells. What code can I use to tell the macro to wait until the query is finished
|
| count-if | 01 Sep 2006 14:06 GMT | 4 |
i'm a novel programmer in vba and i am looking for a funtion or procedure that returns the number of times that a specific character appears in a given paragraph I´ll put an example to explain myself better:
|
| Macro for Mass Find and Replace | 01 Sep 2006 12:59 GMT | 22 |
I am looking for a way to emulate the Find & Replace function in Word. However, I would like to Find multiple selections and uniquely Replace each one (after having pasted them each on a new line at the beginning of the document/template).
|
| Caption of a frame | 01 Sep 2006 12:08 GMT | 4 |
I am desperately trying to find a way how to print the captions of my userform's frames. Right now, these captions do appear on the userform but do not when I print it. Thanks for your hints on this matter.
|
| Transfer Calculator Result | 01 Sep 2006 09:10 GMT | 5 |
I know how to display the Microsoft calculator in Word. MS says that a two step 'Copy/Paste' operation is the only way to capture the result of a calculation. Is there any way via VBA to more directly capture the answer and automatically get the calculator's answer into the
|