| Thread | Last Post | Replies |
|
| retrieving email address surrounded by tabs, carriage returns, etc | 09 Mar 2008 14:05 GMT | 5 |
I'm using Word VBA to retrieve email addresses inside a Word document. The problem I encounter is that sometimes there are tabs, carriage returns, ie special characters before and after the email address that also get pulled and appear as small squares in the text that I retrieve ...
|
| creating macros using find/replace | 09 Mar 2008 09:35 GMT | 1 |
I am creating a protected form document and I need to create macros that would allow others users to insert a name that would replace all "XXXX" through the document with the name they type in. The document is created in a form and would be protected from them changing the ...
|
| Exiting a Sub in Word 2003 | 09 Mar 2008 08:40 GMT | 3 |
Here's another VBA question for the Word 2003 macro experts. Suppose I have a macro like this: Sub MyWondrousInvention() Userform_1_FRM.Show
|
| Excel 2003 - Writing a Macro - How Do I...? | 08 Mar 2008 18:42 GMT | 2 |
I'm trying to write a macro that will loop down a column and find identical numbers, then check the values in the offset cells 3 columns away, decide which value should be kept, and then delete the rows containing the unneeded values. In other words, if I have 4 rows with the ...
|
| Store custom color on the palette | 08 Mar 2008 18:12 GMT | 2 |
Using Office 2003 and Windows XP; In Excel I use the following code to store a custom mixed color on the color palette: ActiveWorkbook.Colors(56) = RGB(163, 193, 173)
|
| Save file | 08 Mar 2008 16:19 GMT | 2 |
I have a template which has a sendforreview button attached. I need to save the document before I can use the sendforreview command. Is there any way I can use the saveas command and have it saved as doc1 then doc 2 the next time it is used then doc3 and so on?
|
| pop up message help please | 08 Mar 2008 14:28 GMT | 1 |
Can someone show me a script that would trigger on the last field, dropdown box, or checkbox that would say something simple like "Please review the information submitted and make sure that all relevent fields are completed before saving and closing the form. Thank you.'
|
| Days 360 | 08 Mar 2008 14:21 GMT | 1 |
I recorded a macro which sorts a column of dates selects the first date and the end date and runs the Days360 excel function and divides that by 7 to get the number fo weeks. I am trying to modify this macro because when I recorded the macro it selected the exact cell of that ...
|
| If not Found then Input | 08 Mar 2008 03:05 GMT | 6 |
Hello from Steved The below I would like the macro to ignore but it inputs L 0:0:0 and R 0:0:0 Please how do I tell the macro that Example is right and move onto the next and so on, now if eample 2 is found then input L 0:0:0 above the R 22:10:30
|
| A program to find and replace | 08 Mar 2008 00:43 GMT | 4 |
I am going to write 2 VBA programs to do find-and-replace, though I know that there is a built-in find-and-replace function in Word. The 1st program finds the word which I specify and is also in red. The program replaces them by the word that I enter. For example, the
|
| DocProperties not available on startup | 08 Mar 2008 00:09 GMT | 1 |
I've cobbled together a PoC app that writes out a certain document property. If I manually run the macro, this works. When it runs on startup, the docproperty output is blank (the code does run) It would appear the code is running before the document is fully available.
|
| Infinite Page Length in MS Word | 07 Mar 2008 21:01 GMT | 1 |
I would like to know how to change the length of a page in MS Word. I realize that we are able to do this with the Page Setup function of the application, however, we are limited to 22 inches. I have researched on this, and of the few threads that I found, they were
|
| Export drawing as jpg or tif | 07 Mar 2008 19:46 GMT | 1 |
Using Office 2003 on Windows XP; I have a document that is one page and contains a single drawing that consists of several boxes and lines, etc. Is it possible to save this or export it as a jpg, tif, or other graphic?
|
| Paragraph Formatting and Outline Level | 07 Mar 2008 17:11 GMT | 1 |
I probably should post this in another forum, but you people are all such experts I was hoping to get a quick response. I promise to confine my questions to macros in the future. I'd like to change the outline level associated with a paragraph. I'm
|
| How know ID for some commands that is in the "Clipboard" group on the "Home" tab (Word 2007)? | 07 Mar 2008 16:55 GMT | 4 |
Sorry for repeat of my question, but I am indeed need help. How get ID (identification number) for some commands, e.g. "Paste Special", that is in the "Clipboard" group on the "Home" tab (Word 2007)? Or other commands on the other tabs in the Word 2007?
|