| Thread | Last Post | Replies |
|
| Can't find project or library, if my userform calls the macro | 17 Jan 2006 08:48 GMT | 1 |
I have a command button on a userform, and the button triggers the code shown below [in the macro Private Sub btnPath_Click()], which works just fine. But I would like to remove most of the code from the form and instead
|
| How to paste a copied range of cells in Excel under Word bookmark | 17 Jan 2006 08:48 GMT | 1 |
I created a module which copy an area of excel cells (e.g. A45:D51) in MS Word 2000. How can I call this module and use .ActiveDocument.Bookmarks("bookmarkname") to paste the copied area of
|
| Fields in header and update using VBA | 17 Jan 2006 06:39 GMT | 2 |
Hello all, I'm trying to automate some fields in the header and footer by making a VBA userform and having it plug into document. While I can use document vars to plug in values in the regular bodytext and use activedocument.fields.update to show the new values, this won't work ...
|
| Removing Macros from a Word document | 17 Jan 2006 03:16 GMT | 9 |
Occasionally when I paste something into a Word document (Word 97 SR-2 used) from the internet, after saving and closing it, when I re-open it, I get a macros warning box, with the choice to enable or disable macros in the document.
|
| template keeps locked very strange? | 16 Jan 2006 23:15 GMT | 1 |
I have a macro in a dot file that runs when I open a document with that network template (g:\wmv\r6.dot) attached. The dot file is on a network and I want to copy it local so the network template isn't locked when a user has a doc open with that template attached, so it can be ...
|
| border | 16 Jan 2006 22:23 GMT | 3 |
Hey list, I am trying to set a border for a couple of rows in my table My table has 4 columns and x rows.... the code below will only yield a a border on the bottom row of the table....
|
| call to a DOS command from VBA | 16 Jan 2006 20:07 GMT | 8 |
I am new to VBA I need help with calling a DOS command from within a VBA 6 code. Here is an example: Suppose I need a list of files in a folder. One can do it using DOS dir command like Prompt:> dir drive:\path\foldername > drive:\path\list.txt
|
| Mail Merge/Labels and Internet Explorer | 16 Jan 2006 18:08 GMT | 1 |
I am not actually sure which forum to post this on, as it is an issue that crosses applications. Essentially, we have had a database developed for our organization that is web-based, and includes the grand feature of generating mailing
|
| Append date to auto-generated Excel sheet | 16 Jan 2006 17:53 GMT | 2 |
I have a macro that translates table data into a newly created Excel worksheet, and saves the name of the xls in the format of the name of the word doc that spawned it, save for losing the .doc extension and appending the the designation "_log_" and the current date.
|
| Protecting and unprotecting form fields | 16 Jan 2006 16:59 GMT | 2 |
I have a form that I saved as a template, so that I can insert it into various documents. I have written code that inserts this form using a macro that does that and also opens a userform. The form has bookmarks and form fields with options and drop downs that only work when the ...
|
| Copying data from one table to another | 16 Jan 2006 16:19 GMT | 3 |
I have been tasked with setting up an Access database to track 4 similar (but different) entities. Under certain circumstances entities B & C could metamorphose into entity A. Is it possible in Access 2002 to have a button on an input form that will replicate most (but not all) ...
|
| MS-Project VBA Question | 16 Jan 2006 12:33 GMT | 1 |
Hi NG , I am new in the field of VBA and have a question / problem. In one project file I defined a field ( customized field Number 13 ) and renamed it as "StatDur" and entered a formula there in.
|
| MS-Project VBA Question | 16 Jan 2006 12:11 GMT | 1 |
Hi NG , I am new in the field of VBA and have a question / problem. In one project file I defined a field ( customized field Number 13 ) and renamed it as "StatDur" and entered a formula there in.
|
| MS-Project VBA Question | 16 Jan 2006 12:10 GMT | 1 |
Hi NG , I am new in the field of VBA and have a question / problem. In one project file I defined a field ( customized field Number 13 ) and renamed it as "StatDur" and entered a formula there in.
|
| Finding Out What the Current Section Is | 16 Jan 2006 05:24 GMT | 2 |
For the life of me, I can find a way to determine what section of the document the current selection is in. It seems like a simple task, but somehow, I just can't seem to get the syntax right. I'm using a macro to build a document, and I want it to do one thing if the current ...
|