|
Replace first character of name in formfield (Instr function)
Hi,
I'm looking for code for the following:
I have a formfield (textbox) for Firstnames.
I'd like to automaticly replace the first character of each name in UpperCase.
So, if 3 firstnames are entered in this Textbox, all the first characters of
these three firstnames has to be replaced in Uppercase.
I've tried different ways with the Instr function, but not found a solution
yet.
Anyo...
|
5 |
10/26/2008 9:34:00 PM |
|
|
Converting tables
I’m in way over my head on this one. We have student handout documents that
were set up in table formats. Our training department would like to get them
out of the table format. Part of the problem is that there was no consistent
way they were created. Some are one long table while others were divided into
multiple tables. Then with in a table it is different. Some have 3 columns
and o...
|
7 |
10/26/2008 8:22:21 PM |
|
|
Filename by user input
In, e.g., AddPicture, Filename:= arg is being fed by user input from Excel
cell. Spaces cause error. User surrounding the name in quotes also errors.
Recourse is Docume~1 game that I think I have under control. Is there an
easier way? I'm not ready to try PATH....
|
2 |
10/26/2008 2:11:00 PM |
|
|
Menu Automation Troubles
I don't have a lot of experience customizing menus and toolbars
programatically and I am having fits with the following code. I call this
procedure with and AutoNew, AutoOpen macros and from several other
procedures in a larger project. The calls and code are doing what I want
them to do but for some reason everytime I run through the process and then
close Word I get a prompt that ch...
|
2 |
10/26/2008 1:08:11 PM |
|
|
Help with Word 2007 Macros
Hello,
I am a newbie to Word 2007 macros.
My main goal is to have standard settings for all users on the domain.
Main settings required at the moment is Font = Arial, Font size = 11 and
line spacing = 1.
I first read about AutoExec, AutoOpen & AutoNew.
I have got this working OK except for one problem (This is in another Post).
I then read about Document Change Macros which can be se...
|
2 |
10/26/2008 5:58:30 AM |
|
|
Help with Word 2007 Macros
Hello,
I am a newbie to Word 2007 macros.
My main goal is have standard settings for all users on the domain.
Main settings required at the moment is Font = Arial, Font size = 11 and
line spacing = 1.
I first read about AutoExec, AutoOpen & AutoNew.
I recorded the Macro to do the settings I wanted then copied the VBA code
into AutoOpen & AutoNew.
Sub AutoNew()
'
' AutoNew Macro
...
|
1 |
10/26/2008 2:10:06 AM |
|
|
What does auto run on opening/loading .dot file when Word already runs?
Still not solved the problem of setting references on opening/loading a .dot
file and I think I have to rephrase
my question.
What do I have to do to make code run automatically on opening/loading a
..dot file (not Normal.dot) when
Word already is running? AutoExec and AutoOpen don't seem to do it, so are
there any other options?
Thanks for any advice.
RBS
...
|
5 |
10/25/2008 8:36:39 PM |
|
|
inserting section break without header/footer
Programmically I have used insert section break to insert a document.
First page of template has footer/header
What I would like to do for a project is to insert a document that
has 2 colums with no footer/header.
How can I turn off the footer and header of the document being pulled in
but, leave the footer and header on the 1st page?
Here is what I am using for inserting:
If ActiveDocu...
|
6 |
10/25/2008 6:21:01 PM |
|
|
NEED VBA Guidance
I'm working with a teacher to create a booklet. She has two pages one for
the teacher with answers in a table and another for the student with blank
spaces in tables and an upside down word art with the answers.
I want to combine these into one document and be able to press CTRL + M to
turn a macro on and off that would clear the contents of the tables so that
she can print it out for ...
|
6 |
10/25/2008 7:17:35 AM |
|
|
How do I set references on open in a .dot file?
Still haven't figured this, that is how to set references
in a global .dot file (not normal.dot) on startup.
I would like to save the .dot file without the references and
set them when the .dot loads as that is the only way I can see
dealing with the situation where the referenced file has altered.
I have no problem doing this in Excel, but no succes yet in Word.
RBS...
|
6 |
10/24/2008 9:43:42 PM |
|
|
Draw Table
I tried to record a macro that would draw a table at a set location in a
document. But when I click on the record macro button the draw table option
goes away. I have the following macro that lets me draw a shape at a set
location in my document. How would I do the same for a table?
Sub Signoff1()
Dim idx As Integer
Dim oFFline As Shape
Dim i
On Error GoTo endthis
i = Selection.Infor...
|
5 |
10/24/2008 9:31:00 PM |
|
|
Automation with Word 2007 under XP
Hello NewsGroup,
I start Word2007 out of a C++-Code with automation (by calling
CoGetClassObject and .CreateInstance).
This works well with all versions of Word except for Word2007. With Word2007
I get an error message,
if Word is already running and a word-file is already open.
A message (similar to this in German) comes right after the function
CoGetClassObject has been called:
...
|
1 |
10/24/2008 9:17:01 PM |
|
|
How to detect EnvelopeVisible event
Dear Group,
I need help with the following issue:
I'd like to detect when the user clicks on the e-mail icon in Word
(EnvelopeVisible = true) with a VBA macro.
Just like there are macros for FileSave and FileSaveAs, I thought there
would be something for EnvelopeVisible, but as it seems, there is nothing.
What I'd like to achieve is to do some background processing with the
current...
|
2 |
10/24/2008 8:02:03 PM |
|
|
print cancel
Have the following want to have code reteurn to a userform if print is
canceled by user on print dialog screen. Presently it returns to vba code
this is what I want to correct
Thanks
With ActiveDocument.MailMerge
'.Destination = wdSendToNewDocument
.Destination = wdSendToPrinter
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject =...
|
2 |
10/24/2008 8:00:20 PM |
|
|
need meaning of regex phrase
What does this RegEx phrase do?
^32^t^s
I have it in a wildcard search in a macro and the search "works," but I want
to know why it works and how.
The complete statement, which I use to find a "City, ST Zip" text pattern in
a wildcard search, is:
[A-Z][a-z/A-Z/.\,]{2,}[^32^t^s]{1,}[A-Z]{2}[^32^t^s]{1,}[1-9]{1}[0-9]{4}
--
Bryan...
|
3 |
10/24/2008 7:27:00 PM |
|
|
YesNo problem
I missed something trying to have vbyes go to data sheet vbno to continue
with remainder of procedure. Got something out of order. Can someone
unscramble my error
Thanks
With Worksheets("Data")
LastRow = .Cells(Rows.Count, "A").End(xlUp).row
On Error GoTo NoBlanks
Set myR = .range("D5:M5").Resize(LastRow -
4).specialcells(xlCellTypeBlanks)
Blanks = msgbox("Data You Need Com...
|
2 |
10/24/2008 6:17:02 PM |
|
|
Link caption in fig number and table number in text
Hello word comm up there
I'm writing a paper in Microsoft Word 2003. I have figures and tables that
I'm inserting in the text. I also inserted a caption for each figure or
table.
I would like to link the caption (figure or table) with the figure o table
I'm pointing out in the text. Thus, if I have to add another figure or table
in the text, MS Word will reorder the caption number in ...
|
5 |
10/24/2008 11:38:01 AM |
|
|
Accessing Structured Document Tags (SDT)
Hello,
Is there a way to access the content (and properties) of structured
document tags in VBA?
TIA,
Yves...
|
6 |
10/24/2008 10:58:52 AM |
|
|
Word 2007 : how to backup Templates and the QAT ?
Hi everybody,
What is the best way to backup the templates I created and the Quick Access
Toolbar, in which I put a number of buttons/macros ? Just in case something
happens and I have to reinstall Word or replace my brand_new PC...
I just don't know in which folder the Templates are stored.
thank you very much in advance for your kind help,
Best rgds,
Daniel
(Office 2007 newbie)...
|
4 |
10/24/2008 7:00:54 AM |
|
|
VBA to extract data from 2 excels
Hello,
I am completely new to excel vba and still learning.
I have 2 excels and I want to extract data using VBA based on match
criteria on 2 columns. That is:
Excel1 has these 4 columns JoinDate, FirstName, LastName, Address.
Excel2 has these 9 columns: Transaction Type, Transaction Date,
Transaction Number, FirstName, LastName, ProductCode, ProductName,
Product Date, Payment Amount....
|
2 |
10/24/2008 6:50:25 AM |
|
|
I would like my date fields to appear like MM/DD/YYYY
Hello,
I am getting the system date and printing it into a column by adding one to
the current day and I do this for a whole month... Well I prefer my print out
of my dates comes all the time in 10 characters of MM/DD/YYYY for all the
dates. Currently my date is being printed either 8-9-10 digits if my months
are January thru September or days are 1-9... like this..... 1/1/2008 I
pre...
|
2 |
10/23/2008 11:41:46 PM |
|
|
WINWORD.EXE process deos not end after closing the user form?
Hello,
I have a Template named X.dot. When I double click on this template to
create a new document, I have noticed when I close the USERFORM PForms thru
using red X on top right corner of the USERFORM, I have noticed that
WINWORD.EXE statys live on the Processes tab in the Task Manager and a
resudue file of ~X.dot stays in the directory of X.dot. I am including my
AutNew and AutoCl...
|
13 |
10/23/2008 10:56:05 PM |
|
|
Can a range cover non-adjacent paragraphs?
I have a report document with several Excel files in an appendix.
Each of these files has a bookmark to allow a hyperlink to the file to
be placed in the report.
A co-worker who also works with this report needs to see the bookmark
names so she knows exactly which file is attached where. So I was
going to iterate through the report with a macro that would extract
the bookmark name and pla...
|
3 |
10/23/2008 5:50:53 PM |
|
|
Bookmark VSTO error "requested member of collection does not exist
hello
Using VSTO with C# I have created a table in Word. I also created a
template with a bookmark for the document that gets opened to use in it in
order to position the table at a certain point in the document. However when
I run the application there is an error message that says "requested member
of collection does not exist". I don't know why the error appears because
the...
|
4 |
10/23/2008 4:16:04 PM |
|
|
date format
I am trying to insert a date with format "2008-10-21" into an Access database
but the first line shown in the code below inserts "1997" (obviously using
the dashes as minus signs). What would be the correct format to do what I
want?
strDate = Format(Date, "yyyy-MM-dd")
Set csConn = CreateObject("adodb.connection")
csConn.ConnectionString = "data source=C:\Data\0\jbDB.m...
|
9 |
10/23/2008 2:47:13 PM |