|
Folder Tree in Word Document - directory.docx (1/1)
begin 644 directory.docx
M4$L#!!0`!@`(````(0!O&FN0?@$``"@&```3``@"6T-O;G1E;G1?5'EP97-=
M+GAM;""B!`(HH``"````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````...
|
1 |
6/6/2007 1:03:06 AM |
|
|
Linking worksheets
I am using winxp pro and excel 2003
I have a master workbook that contains a worksheet for each vendor.
The worksheet has the various 'levels' of pricing on them.
I want to create workbooks for each customer that contain a copy/paste
of the worksheet containing the vendor info in the master workbook for
each vendor the customer uses (and containing only the column that has
the customer's '...
|
2 |
6/5/2007 5:37:57 PM |
|
|
userform question
I am new to userforms and was wondering if someone could help point
me
in the right direction (I already tried to create my first userform
using http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm ). The
userform would not be too complicated if I could just get started. I
have done this in Word with form fields but I want to save a little
time by using combo-boxes with AutoWordSelect s...
|
2 |
6/2/2007 8:26:52 AM |
|
|
DocumentBeforeSave
I'm trying to use the above function in a macro for Words, but can't get it
to work. I've used this before in Excel, but Word is different. ...
|
8 |
6/2/2007 2:56:44 AM |
|
|
List Box VBA within a document
Hello,
I would like to use a combo box in my document to allow the user to
make one selection. For example, they can choose their favorite
activity from the list. However, I don't know where to begin.
Some major questions I have are:
* how can I add items to the selection?
* what's the limit on adding items to the list? Is it 25 like the
forms list box?
Any direction is appreciated...
|
2 |
6/1/2007 3:37:51 AM |
|
|
text big, text small
How would I put a BIG text item and a small text item together in a
cell of a table ?
I tried this:
With .Range
.Font.Size = 16
.Text = "tues"
End With
With .Range
.Font.Size = 8
.InsertAfter = "day"
End With
but that just makes "tuesday" 8 points text....
|
3 |
5/31/2007 9:58:35 PM |
|
|
Repeating for each table in a document
I have written a short macro (pasted in below) that works on the
current table that the cursor is in, but I want it to run on all the
tables (except the very first one) in the document in one go. I tried
using For Each but the macro keeps bringing up errors, presumably
because there needs to be some alterations of the
"Selection.Tables(1)" bit where it occurs. Or is there something else
wr...
|
3 |
5/31/2007 12:25:49 PM |
|
|
Deleting text - how to do, and prompting user before deleting?
I recorded keystrokes and I got this as a result. Is there a way to do the
same as below but with the 2 changes listed at the bottom?
**************************************************************************
Sub DeleteText()
' Deletes all the text on the page.
Selection.HomeKey Unit:=wdStory
Selection.EndKey Unit:=wdStory, Extend:=wdExtend
Selection.Delete Unit:=wdCharacter, ...
|
14 |
5/29/2007 6:19:08 AM |
|
|
Remove all indenting? (Modifying recorded keystrokes so this actually works.)
Recording keystrokes is great for those of us who can never seem to
wrap our brains around vb <g>. I recorded this yesterday because I
ran into a RTF doct. that happened to be formatted with first-line
indenting. Didn't realize it until after running a text clean-up
macro and saw the indenting so added this in below to the cleanup
macro and it didn't work for the entire doct. Some of...
|
2 |
5/29/2007 2:25:48 AM |
|
|
Directing/Specifying a Print Request/Location
I'm pretty sure this is possible, but I'm lost in trying to figure it out
....
I have (2) pieces of code which work individually -- I need to
modify/incorporate the two so that they print data into the same WORD
template
Here's my code:
================
(This sub prints the data on an ACCESS form)
Private Sub Command83_Click()
On Error GoTo Err_Command83_Click
Dim stDocName ...
|
10 |
5/27/2007 1:43:28 AM |
|
|
Printing invoice in Word 2003 from link on web page
Hi
I am planning to create a dynamic website using ASP/Access.
I thought of an idea to include a hyperlink from the website to open a Word
2003 document complete with VBA code, which (hopefully) would pick up values
from the Access database and generate all the invoices that currently need to
be paid. The invoices can then be printed straight off.
I guess I would need some sort...
|
2 |
5/26/2007 7:29:15 PM |
|
|
word combobox and alert message box
I have two issues with a template file that has three comboboxes, two command
buttons a a date field. Everything works OK and I can concatenate the date
and combobox selections into a file name and save it to the network drive. My
issues are more aesthetic than non-functional but never the less here they
are:
1. I cannot figure out how to use the scroll wheel of mouse to scroll within
...
|
6 |
5/25/2007 5:29:57 PM |
|
|
Multiple Search And Replace
Group,
Please assist me in my first use of VBA using MS Word. I have a very
large text file that Word can open. We use an application that allows us to
test multiple automotive radios. It creates a file made up of text. These
radios change part numbers constantly. When a change occurs we have to make
changes throughout this text file. For instance, Software ID "0x78AB",
where v...
|
15 |
5/25/2007 11:29:52 AM |
|
|
Free reference
Where i download a free reference to learn about VBA??
i want to make spellcheck with Indonesian language.
anybody can help me for the reference??
i'am a very new beginner in VBA....
|
6 |
5/25/2007 6:48:58 AM |
|
|
Inserting data from an ACCESS form into a bookmark in WORD
I have the following code (which opens a NEW Word document and prints the
data from my ACCESS form) -- I need code that will open a specified WORD
template and insert the ACCESS data into a specific bookmark. I'm sure this
is a simple process, but I'm somewhat frazzled (at this point) and have
settled on this option over several previous suggestions. Here's the code I
need to modify:
...
|
5 |
5/24/2007 12:26:18 PM |
|
|
Accessing ContentControls via its Title?
Hello
Exists there a VBA code possiblity to access a specific content
control via its title rather than its index?
i.e.
Application.ActiveDocument.ContentControls(1) --> works !
Application.ActiveDocument.ContentControls("MyDropdown") --> ERROR
Application.ActiveDocument.ContentControls.Item("MyDropdown") -->
ERROR
Any other suggestions?
thanks in advance
regards
dat...
|
4 |
5/24/2007 9:05:01 AM |
|
|
Accessing a "normal" Combox with VBA
Hello
I am currently struggeling while I try to acces a combo box with vba.
I am currently confused because we have 3 different kind of combo box
types in Word.
- "nortmal" combo box
- legacyforms combo box
- activex combo box
I would like to use the first type. Unfortunately I did not find an
example how to access such a combo box via VBA. i.e.
ActiveDocument.FormFields("MyDropd...
|
5 |
5/23/2007 7:50:21 PM |
|
|
recommended reference book to learn VBA
Can anybody suggest which book is the best to practice and learn VBA(i want
something with many examples). I am currently programming in MS Word VBA. I
live in canada so, i something i can find easily here.
thanks...
|
4 |
5/23/2007 5:07:12 PM |
|
|
Remove blank lines
In another templete, there will sometimes be a "nil" result i.e
nothing in the database.
Is there a command in word which will ignore a line if all the results
of a mail merge on a line is nil, so I do not get balnk lines?
...
|
2 |
5/22/2007 11:44:08 AM |
|
|
Multiple if conditions
I am trying to get a mail merge document to work as follows:-
The database has an office field.
If the field is "bus" I want the merger result to be the text word
"business" in my document
If the field is "ltd" I want the merger result to be the text word
"limited" in my document
If the field is any thing else I would like the text work "office" to
be printed.
How do you do a multipl...
|
3 |
5/22/2007 11:41:18 AM |
|
|
Predefined Bookmarks
Hi,
I want to do something with code from beginning to end of the document. When
code reaches at the end of document, it will stop. I tried with following
code which seems incorrect because it never shows me the message box saying
"Reached at End of Document", rather the loop continues without stopping.
Sub doSomething()
Selection.HomeKey Unit:=wdStory
Do Until Ac...
|
7 |
5/19/2007 3:50:53 PM |
|
|
Comb box. how to store the selections??
I'm only mildly familiar with VBA so forgive me, I've scoured the
internet trying to figure this out and have figured out how to build
what I need, but I cannot figure out the code to save the information
selected . . . so store the selections. Can anyone help?
Here's my code as it stands now:
Sub AutoNew()
FillCombo
FillCombo2
FillCombo3
FillCombo4
FillCombo5
E...
|
10 |
5/19/2007 2:01:07 AM |
|
|
Manipulate IP address
Hi -
I want to manipulate an IP address such that whatever is entered into
textbox1 is examined and then the last octet is increased by one.
for example: user inputs 1.2.3.4
code will output 1.2.3.5
I tried to do it, but I'm not sure how to examine the contents of the
textbox1 to know where to make the mathematical addition.
Can anyone provide the code for something like that?
...
|
9 |
5/19/2007 1:50:25 AM |
|
|
Saving my Doc after filling out the form
Hi there.
After almost finally finished with my form a new problem arised :)
The users that has to use this templeate will have problems with
saving the documents in the right manner so I want to try to make it a
lot easier for them:
1. I have 2 formfields "name0" and "class" that I would like to
include automatic as the documents name when saved - so the users only
need to press 1 butt...
|
7 |
5/18/2007 2:17:55 PM |
|
|
Word 97 VBA in Word 2003
I'm not a programmer at all but I do have a template I created in Word 97
with several combobox selections and a few filed codes like createdate, etc.
When I start a new document in Office 2003 Word, none of my comboboxes
populate and the code for my reference template file does not show up in VBE.
I can open a new document in Word 97 and all works correctly.
I thought I read somewhere ...
|
3 |
5/18/2007 12:02:00 AM |