|
building a web site
I just got back working on my website. Its taken a long time to finish but I am getting there.
I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing.
Paul ...
|
1 |
27.01.2006 01:35:13 |
|
Macro find and delete
Does anyone know how to make a macro that finds a text in a document and
selects from that point tot another point, also seeking.
For example:
In the text below, I want the macro select all the lines from A till (the
first) C and then delete that part, of replace it with.....
Hans
F
B
B
A
C
C
A
B
B
C
B
C
B
D
D
B
D
D
C
C
D
...
|
3 |
26.01.2006 20:24:28 |
|
Find Word version on the fly?
Is there a method that can be accessed from outside word (using OLE) which
returns the version of Word which is running?
...
|
2 |
26.01.2006 15:46:29 |
|
Open Word document, modify and Save
Hi All
Is there any way that I can read from a word document in a word-by-word
manner and do my own checks on each word (like a spelling checker), and
modify some words where necessary then save the document again.
Any help is highly appreciated.
Regards
Dana
...
|
6 |
25.01.2006 11:13:25 |
|
Save selected printer with document
I'd like my document to remember which printer it last used. Is this done
with a macro or is there some other way to do this.
I'd appreciate your thoughts. Thanks.
...
|
2 |
24.01.2006 13:36:03 |
|
Sheet tab color
Hello everyone this is my situation/problem:
I have 1 sheet per tenant with their information and X amount of
tenants. The 4 cells that the macro looks at in each sheet are
different dates. For example Lease End Date is one of them. So 1st part
of the If is if the date of the lease end is today or past today make
the sheet tab Red. If its today +30 make it yellow so i know the lease
is end...
|
3 |
23.01.2006 06:25:56 |
|
Hyperlinks pasted by a macro do not work!
I have a macro that copies text from a *.rtf document and paste the text
(after some editing) into a *.doc document.
The *.rtf document is generated in an application that opens Word and
presents the document there as 'filename.rtf (Read-Only)'.
My macro copies selected parts and paste them, works as planned
____exept____
if the text is or includes an URL, typically like
http://www.m...
|
14 |
22.01.2006 16:43:28 |
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 16:11:27 |
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 16:11:20 |
|
macros in protected docs
Hi,
I have Word 2003 and am trying to get macros to run in a protected document.
I get the error "Can't run macro because document is protected" even though
my Security is at the lowest setting.
I don't know anything about VBA so I'm at a loss (and I don't even know if
VBA has anything to do with the solution). Thanks...
--
Steve...
|
3 |
20.01.2006 17:27:44 |
|
Help With Macro
Hi
I am a real beginner to macros but have created some froms in word and
have adapted a macro from this site provided by Cindy Meister to update
a single form field, I have managed to get this to work several drop
down from fields with an added item OK though my code may be a bit
long!!!????
I have 2 problems though:
1: When the user input box opens "ADD NEW ITEM TO LIST" if you pres...
|
3 |
20.01.2006 10:53:10 |
|
ms word input form example request
Hi I need to set up a form to receive input from a test I am
administering. The responses to this test are multiple choice: either
a 1, 2 or 3. I need the form to receive the responses (1, 2, or 3 for
each question) and automatically move into the next field when the
input for a particular question is received. There are over 100
questions to be responded to - so I'm looking for the most st...
|
2 |
20.01.2006 05:09:33 |
|
how to handle nonexistent class?
I write a class in VB and plan to use it in word.
under word vba:
set obj = new myproject.class1
If the PC does not install my dll, error will occur.
What I do in Word VBA to check the exist of the class?
thanks
...
|
5 |
20.01.2006 01:11:00 |
|
Help with Find and Replace Wildcards
Greetings,
I just recently found out about using Wildcards in words Find and Replace
but not having much luck using them.
I'm trying to do two different things:
1) Any line that starts with 2005 needs to be bold
2) Any line that contains a hyphen needs a font size of 8
I know I will need to do a Find and Replace for each item, but I'm not
having luck with creating the wildcard strin...
|
3 |
19.01.2006 23:06:07 |
|
vbCrLf displays as ? in formfields
I'm trying to populate a series of formfields in a word doc with info
obtained programmatically from outlook.
my problem is that if the outlook field contains a linefeed character or a
carriage return (among others), the formfield in word displays it as ??
instead of inserting a Linefeed.
so an address displays as...
123 anystreet ?? Las Vegas, NV ?? USA
instead of
...
|
4 |
19.01.2006 17:23:33 |
|
Formatting
All,
This question is simple but someone can help me out
i have a checkbox and a label, when user selects the checkbox,
the caption of the checkbox (aaaaaaaaaaaaaaaaaaaaa) and label caption
(abc...etc) should be printed in the document here label caption is
spread accross 4-5 lines, how i want to see in the document is
aaaaaaaaaaaaaaaaaaaaa (checkbox caption)
abcccccccccccccccccc...
|
4 |
19.01.2006 17:23:33 |
|
ProtectedForForms
Have a template which contains some boilerplate text with an AutoNew Macro
which Inserts a file into the top section of this same document. The inserted
file has some forms fields. The very last thing the AutoNew macro does is
insert a continuous break and then attempts to protect the first section
leaving any subsequent sections free for change. Unfortunately this fails
leaving everythi...
|
3 |
19.01.2006 12:39:03 |
|
Free mp3's
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>And much more that that!</P>
<P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P>
<P>This site offers free and legal mp3's, software, movies, games.<BR>They also
have a l...
|
1 |
18.01.2006 07:27:34 |
|
pre-Formatted auto-generated Excel sheet
Hello,
I have a macro that generates table information form Word into an excel
sheet, and I'd like it if the cells columns would text wrap the data in
the cells, as well as display the regular "medium" black Excel
gridlines....not sure where to introduce this code, as .Columns or
..Rows? Anyway, here is what I have that needs to be tweaked...Thanks
again all, I'm learning....
Next
...
|
2 |
18.01.2006 03:39:33 |
|
Can't find project or library, if my userform calls the macro
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
use the identical code, which I copied into my newmacros module, in a macro
(shown below) named: DocPath
I un-commented the line: 'Call DocPath [in the...
|
2 |
17.01.2006 09:05:18 |
|
How to paste a copied range of cells in Excel under Word bookmark
Hello all
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
cells into the Active Word document under the bookmark?
If a module is returned a text string, I can use
..ActiveDocument.Bookmarks("bookmarkname").Range.Text =
ModuleThatReturnText
...
|
2 |
17.01.2006 09:00:47 |
|
Removing Macros from a Word document
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.
I assume that the macros come from something I paste from the web. How
do I remove them? Deleting everything in the document doesn't get rid
of the warning box...
|
10 |
17.01.2006 03:16:51 |
|
Append date to auto-generated Excel sheet
Hi
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.
Example: Word doc titled "VBA Question.doc" generates spreadsheet
called "VBA Question_log_01-13-06.xls
Here is the ...
|
3 |
16.01.2006 17:53:53 |
|
MS-Project VBA Question
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.
With VBA I want to read out the contents of this field and display
it via MsgBox. Ihave entered following code
num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13,
pjValueListValu...
|
2 |
16.01.2006 12:11:16 |
|
inserting tables
Hello List,
I have been trying to work this for a while now, i can;t seem to get it
working...
I am using word automation to insert tables into my document from a bookmark
range. The problem is when I loop to isnert a table each table will insert
into the first row and column of the previous table.
Here is my code below
For I = 1 to 20
InteriorRange = Doc.Bookmarks.Item("Interio...
|
2 |
16.01.2006 05:20:18 |