| Thread | Last Post | Replies |
|
| Adding the Page number | 27 May 2004 13:24 GMT | 2 |
Firstly thanks to all that have helped me with my problems. Im generating a word doc ' on the fly ' from a VB6 application, inserting a combo of text and Database Fields. After loads of help i've now managed to complete that task, however there is one thing id like to add as a ...
|
| insertdatetime? | 27 May 2004 12:17 GMT | 3 |
Why I cannot run the following code: tb1.cell(1,4).range.insertdatetime datetimeformat:="MM/dd/yy" I want to print current date in one cell of table. Thanks.
|
| Problem with OR operator | 27 May 2004 08:04 GMT | 1 |
I have a macro that is to open only Word or Excel documents. Anything else bypasses the code. If I test for Word documents with : If strExtension <> ".doc" Then GoTo NextLink
|
| Distributing Access w/out Licenses | 27 May 2004 07:25 GMT | 2 |
So... I'm developing a fairly simple Microsoft Access database for a small workgroup that does not have Access licenses. I've read that if I purchase the Visual Studio Tools for Microsoft Office System (around $400) I can do this. My questions, if anyone out there has some ...
|
| InsertFile - XL - Fails with wd2k, OK in '97 | 27 May 2004 06:12 GMT | 1 |
Wd97/NT4 & 2k/Win2kPro Selection.InsertFile FileName:=PSDir & PSName, Range:="", _ ConfirmConversions:=True, Link:=False, Attachment:=False Wd97 - Works fine
|
| Document Versions Aren't Removed by VBA | 27 May 2004 03:36 GMT | 3 |
I've sent this to Microsoft Support but they suggested I ask here. I want to programmatically remove Document Versions in code. I have the following macro defined: Public Sub RemoveVersions()
|
| How does the "For Each ... Next" statement work so quickly? | 27 May 2004 02:52 GMT | 6 |
Here's a macro I use to get rid of any extra formatting that's been applied on top of text in the document in addition to the styles, in order to return the document to its proper style formatting. I use this macro by itself and also run it from some other macros, and it works
|
| Table of Authorities -- Where is TabLeader info stored? | 27 May 2004 02:22 GMT | 3 |
According to the documentation for the TableOfAuthorities Object, the TOA object has a TabLeader property. For example, you can say: activedocument.TablesOfAuthorities(1).TabLeader=wdTabLeaderHeavy However, although this works, it does not seem to modify the flags in the
|
| Changing "index" value of controls | 27 May 2004 02:19 GMT | 4 |
I have a userform with 40 option buttons. I am using a loop to find all controls beginning with "opt": For x = 0 To ufmPrintToCtrm.Controls.Count - 1 If Left(Controls.Item(x).name, 3) = "opt" Then
|
| Autotext Trouble (Continuing) | 27 May 2004 01:56 GMT | 4 |
I want to insert a simple table (2 row, 1 col) using AutoTextEntries.Insert, move the cursor to the first cell and paste in a picture. The Autotext.insert takes a long time to complete (maybe 1 second), but the macro continues running before AutoTextEntries.Insert is completed. The
|
| Assigning keys | 26 May 2004 22:40 GMT | 1 |
I want to hit Alt L and have it go automatically to the next back slash \ in the report. How do I do that?
|
| HTML table to Word Table | 26 May 2004 22:31 GMT | 1 |
Does anybody have any experience of providing a web page with a submit button which transfers the contents of an HTML table to a client side VBscript which creates a Word document & populates a Word table? I can do this for Excel, but doing it for Word is proving more problematic.
|
| Question on having a form field appear based on content of another field | 26 May 2004 20:15 GMT | 1 |
I'm new to forms, so if this is easy, please just direct me to the appropriate article... :- I'm trying to creat a form that has the follow automations 1) a drop down box who's last option is "other 2) a selection for "married
|
| Networking Office Macros Help needed | 26 May 2004 19:22 GMT | 1 |
I am trying to configure office to share macros in a large environment but have run into several stumbling blocks. Here is what I want to do - Have a central area on a network drive where macros are
|
| Formatting a Line | 26 May 2004 18:01 GMT | 2 |
Im creating a word doc on the fly from a VB6 application. Ive managed to create a blank word Doc and insert a Header and footer without a problem. Ive also managed to insert a lines of text. The problem is that a single line has two aprts to it, a Discripter ( on ht eleft) and a ...
|