| Thread | Last Post | Replies |
|
| a way that vba knows which host application its has?? | 09 Sep 2004 08:43 GMT | 3 |
If I open a word or excel document with a hyperlink the autoopen macrocode generates an error: method failed because the document is open in internet explorer instead of word (excel). Can I trap the code with a nice message like: "uncheck the checkbox 'open in
|
| Commandbars/toolbars location | 09 Sep 2004 02:30 GMT | 5 |
Does anyone know how to force the toolbars to nicely stack on the top left? For example, the following code does not take toolbars off the same level and place on separate levels (regardless of
|
| pre-fill forms | 09 Sep 2004 02:06 GMT | 3 |
I need to know how to create a macro that will take what has been entered into a form text box and put the same informtion into other text boxes on the form. For example: a person's name has been entered into the Name box and at
|
| Tools, customize | 08 Sep 2004 22:47 GMT | 5 |
Is there a way to programmically set any of the options in the Tools, customize, options dialog box?
|
| link | 08 Sep 2004 22:16 GMT | 4 |
Using a WORD Macro: What would be the best way to open an excel file, then set a range based on what is in the excel file, then copy the information into a word document. I do not want to set the
|
| getting path for folder | 08 Sep 2004 22:13 GMT | 4 |
I was wondering if there is an easy way to get the path to a folder using a dialog? I'm looking for something like .Dialogs(wdDialogFileOpen) but I need to be able to select a floder rather than a file.
|
| iterate through existing checkbox list | 08 Sep 2004 20:40 GMT | 2 |
I have an array of values that I need to assign to the text/label property of 16 pre-existing checkboxes (like having a huge multiple choice question, and changing the possible answers as the user goes through the questions). I tried to create and size the checkboxes dynamically, ...
|
| vba, IE, word, host application | 08 Sep 2004 19:30 GMT | 2 |
If I open a word or excel document with a hyperlink the autoopen macrocode generates an error: method failed because the document is open in internet explorer instead of word (excel). Can I trap the code with a nice message like: "uncheck the checkbox 'open in
|
| Checking the value of the text | 08 Sep 2004 18:20 GMT | 1 |
I would like to write a macro that searches for a semi- colon and then deletes the character to the left of the semi-colon only if that character is a punctuation mark and not an actual letter or number. I assume I will use
|
| Replacing whole paragraph with a single de-limiter | 08 Sep 2004 16:56 GMT | 1 |
Im having problems replacing a paragraph containing known text - basically a page footer containing the text " page " - with a de-limiter such as "$". I can find the paragraph OK & even delete it & I can also
|
| Field references | 08 Sep 2004 16:44 GMT | 6 |
Help! I'm sure this is simple, but I'm just not getting it. I have a document template with various form fields. I want to reference a text field and copy the text into another place on the same document. I thought I could use { REF Text2 } (Text 2 is the bookmark for the
|
| Document History | 08 Sep 2004 15:02 GMT | 4 |
I've been asked to look into the history of a particular document (Word 95 as far as I can tell). Basically when it was created and who by etc... Looking at the document properties, it reports that the date of creation is the same date as the date it was last saved, however, the ...
|
| A Challenge? | 08 Sep 2004 15:02 GMT | 6 |
I think this may be a tough one. I was altering a macro that opens an Access database and works with it. Something caused the computer to freeze. I had to do a power-off. When I restarted the computer and opened word, I could no longer run that
|
| Finding who has a document open | 08 Sep 2004 15:02 GMT | 1 |
If someone else on the network has a document open and I try to open it from Windows Explorer, it tells me who has it open. I am using the MVP routine from http://word.mvps.org/FAQs/MacrosVBA/CheckIfFileOpen.htm to check if it is open. Is there any way it can be expanded to ...
|
| Adress book | 08 Sep 2004 14:16 GMT | 9 |
I want to use the adressbook in Ms Word. All the names and adresses are currently stored in a excel-file. Is there a way to import this file into Ms word ?? Thanks, Rob
|