| Thread | Last Post | Replies |
|
| Another Mac VBA bug | 09 Nov 2004 07:44 GMT | 7 |
If you've ever tried the RmDir command in Mac VBA, you've noticed it doesn't work. This is because each Mac folder contains a hidden file called "Icon". RmDir doesn't work on folders that contain files, so your next step might be to use Kill to delete the hidden file. Of course, ...
|
| Using Find/Replace text as a variable? | 09 Nov 2004 05:01 GMT | 12 |
I found this code from MVP site, and would like to use it in a larger macro, but I need it to work for all "List Number" styles in a document, not just the selected area. Is it possible to use Find/Replace text as the main variable in this code? For example, prevace the code ...
|
| User Form Close Event | 09 Nov 2004 02:46 GMT | 6 |
Word 2000 I have a user form that needs to run a couple of lines of code each time it gets closed. I have the following in the click-event of my Close button:
|
| Wildcard search help | 09 Nov 2004 02:44 GMT | 4 |
Hey, I have a few (but lengthy) wildcard search for vba related questions. First question, what is missing from this macro that is causing an error that says something like the following, "...contains a group number which is out of range"?
|
| How to return UNC pathnames | 08 Nov 2004 23:47 GMT | 1 |
We use the Filename \p (with path) field to return the filename and path in footers. However, using the logical drive letter makes it very unmeaningful to other 4000 users in the corporation! We'd like to have the path refer to the UNC sharenames instead. Does anyone know of a ...
|
| Inserting Unicode Characters | 08 Nov 2004 23:08 GMT | 3 |
In one of the inherited macros I've got here at work, there is a list of commonly-used but hard-to-locate mathematical and scientific characters displayed in a menu for authors to get at easily rather than hunting for. One of the macros, which simply inserts the desired character, ...
|
| I am using ADO to retrieve data but it overwrites with ADO data | 08 Nov 2004 23:00 GMT | 1 |
I am using ADO to retrieve data but it overwrites with ADO data This is a sample of the code am using it is located at http://support.microsoft.com/kb/q261999/ It works fine but it overwrites any previous text or formating in the
|
| Hyperlink Appearance | 08 Nov 2004 22:28 GMT | 1 |
Is it possible to change the appearance of hyperlinks in a normal Word document (Word 2000)? I would like to have links to various bookmarks in the document, but don't want them all to be the typical blue, underlined text (changes to purple when clicked). In fact, no special ...
|
| List of VBA Error Codes | 08 Nov 2004 21:22 GMT | 2 |
Does anyone know where to find the Error Number list for VBA? I found it once, can't find it now... Thanks,
|
| parsing a text file line by line | 08 Nov 2004 21:14 GMT | 5 |
what approach would i take to creating a macro that parses a text file line by line? and then each of those lines word by word? i need to determine for each line and store to variables for later use: - the number of tabs present
|
| Problems with ActiveDocument.AttachedTemplate when using protected (forms) template | 08 Nov 2004 19:37 GMT | 3 |
Problem 1: ActiveDocument.AttachedTemplate = sMyNewFullyQualifiedTemplatePath results in the following error: Run-time error '5598'
|
| Using AUTOEXIT | 08 Nov 2004 18:29 GMT | 7 |
We're having some problems with our network at the moment. One of the new "features" is that sometimes, when you close a document in Word, Word also exits completely as well. I wanted to put an AutoExit macro on everyone's machines to ask "You are about to quit Word - is this
|
| insert object (file)- how to separate it, and use it later? | 08 Nov 2004 18:07 GMT | 1 |
I have a word project where one of the limitations is that I can only deploy a single (word) file. While I have much of my functionality working, I think it would be so much easier if I could keep some of my code and other information in a separate file- but, I can't deploy it that ...
|
| Setting defaults through VBA | 08 Nov 2004 16:44 GMT | 3 |
Hi, I am doing something I thought would be quite simple, but it isn't working. Basically, I am trying to set the default of the left and right margins in the Normal template through VBA. From what I understand it should be the following code...
|
| Hyperlink in User Form? | 08 Nov 2004 16:29 GMT | 3 |
Word 2000 I have a user form, and I would like to add a hyperlink on the form that will open another Word document. Is there a way to insert a hyperlink into a user form?
|