|
Programmatically setting the Save As filename in a Word doc via VB6
Hi All
First of all I know the SaveAs command would enable me to pre-set the
filename of a word doc, but unfortunately it will auto save it somewhere and
this won't do in my case.
A perfect solution for me is that the Word doc appears (from a word template
I have created so it's a fresh copy with a bit of dynamic data every time)
and when the user goes to File / Save or File / Save A...
|
1 |
12/31/2008 7:06:08 PM |
|
|
How To: Update all headers & footers when fields are changed?
I am trying to create a Word'03 template that includes a few form text fields
that I want to populate the header and footer of the document, and change
when the user changes the text in those fields.
I have done this for one section, the first section is the first page and
never displays the header/footer, but users can create new sections
throughout the document.
Code is called on exit ...
|
4 |
12/29/2008 9:02:01 PM |
|
|
Simple search and replace
I would like to see an vba example for a simple search and replace in a word
document. The search string ( "##co_name" ) may exist in more than one page
in the document body, but it won't be found in the header or the footer.
TIA
--
CBenac...
|
2 |
12/27/2008 1:28:41 AM |
|
|
inserting multiple pictures and description
am trying to create a word document by inserting (using vb) a series
of
pictures and descriptions on my document. I want to place them like
so:
----------
| |
| |
----------
Description
----------
| |
| |
----------
Description
----------
| |
| |
----------
Description
and so on down the page.....
Please help...
|
4 |
12/17/2008 7:42:21 PM |
|
|
Problem while processing word file with word instance from vb.net
Hi,
I have job to verify data available in doc/rtf files. For verification
I am opening file in the instance of WinWord(MS Word) application. I
do the process page by page for detailed comparison.
The actual problem starts when I shift cursor to any pages using
following code :
MsWord.Selection.GoTo(Word.WdGoToItem.wdGoToPage, _
Word.WdGoToDirection.wdGoToAbsolute, IntCounter)
Her...
|
9 |
12/17/2008 6:33:27 AM |
|
|
VBA Template Form
I need to create a letter template for work that pulls information
from the Outlook address book. I don't know much about VBA, but I was
able to get enough information to pull this together:
' *** Code Begin
Option Explicit
Private Sub Document_New()
InsertAddressFromOutlook
End Sub
Private Sub InsertAddressFromOutlook()
Dim strCode As String
Dim strAddress As String
Di...
|
15 |
12/14/2008 12:00:21 PM |
|
|
file too big
I was trying to open a file in word 2002 and it said the file was too big to
open. So how and what do i use to open a very large file in word 2002?
...
|
7 |
12/12/2008 11:09:16 PM |
|
|
Using VBA to read/write to ports
I am new to VBA, but my purpose in using it is that I would like to use it
through Excel to data log information from external sensors and to be able to
manipulate those sensors. I would like to be able to read and write to the
various ports, such as the USB, LAN, Parallel and serial ports. However, I
haven't been able to find a good way to do that through VBA. I was wondering
if some...
|
3 |
12/10/2008 9:44:13 AM |
|
|
Open a form and Word Doc in the same time
Hi,
I've designed a form to fillout certain part of documeent. But I need to
open this form and keep open another word document in the same time. Is it
possible to do that with Word 2007? Thanks.
...
|
2 |
12/9/2008 4:48:04 AM |
|
|
Very experienced Excel and Access but Word newby
I need to understand the VBA module and navigation in Word and programming
differences between Word and (say) Excel . For example
go to start of document
While not end of document
find a table
find a cell in the table
find a line
delete a line
insert a line
insert a row of cells in a table
insert a column of cells in a table
make the table column widths adjust for a new column of ce...
|
7 |
12/8/2008 3:56:33 AM |
|
|
Label printing with Word 2000
Equipment: Windows XP SP3, Word 2000 SR1a, Epson Stylus Photo 870 and R300
printers plus Kyrocea Mita FS-1010 printer.
I would like to be able to print Avery-Zweckforn N0.3321 labels (label size
32x23
mm, sheet size 134x120 mm). However, this label size is not available in
the "Word 2000 Tools/Envelopes and Labels" facility.
Can I download updated software to enable me to print this la...
|
4 |
12/6/2008 10:49:07 AM |
|
|
Combo Boxes
I have a table which has an Employees Rating and a Managers Rating in
separate cells, in each row. The rating is selected by a combo box. There
are 15 rows (therefore 30 combo boxes).
I am wanting to add the same items to each combo box. I know how to add the
items to individual combo boxes, e.g.
With ActiveDocument.ComboBox1
.AddItems "1"
.AddItems "2"
.AddItems "3"
En...
|
3 |
12/1/2008 6:15:01 PM |
|
|
Pre-populating the filename box when the user goes to save
Hi All
I know you can do a SaveAs command to save your generated doc, but I need
the user to perform the save bit because the location can vary greatly from
user to user.
However, I would like to pre-populate what the filename is when they go to
select File/Save As to save them from changing this all the time. They
often don't follow a set format and as there might be 12 users savin...
|
5 |
12/1/2008 5:43:56 PM |
|
|
Word form to inport address info from an Access database file.
Hi All, I used to do this but it was too long ago to remember and things
have changed drstically since then.
Would someone please tell me the following,
I have a form template in Word for which we have to fill out the address of
up to 7 thousand properties a year. I would like to have the address and
other associated info placed into this form by accessing the Access
database. I ...
|
6 |
12/1/2008 12:47:36 AM |
|
|
Word Macros to Manipulate Excel - TexttoColumns
Hi,
I've got two separate macros.
The first one is in Word:
Sub FindH()
Set d = ActiveDocument
Set r = d.Range
Set x = GetObject(, "Excel.Application")
r.Find.Highlight = True
r.Find.Forward = True
Do While r.Find.Execute
If r.HighlightColorIndex = wdYellow Then
With x.ActiveCell.Range("A2")
.Value = r
...
|
2 |
11/23/2008 10:58:01 PM |
|
|
Watermark
When a user presses a "Reprint" button, I want some code that:
- inserts a "Copy" watermark
- shows the print dialogue box so the user can select a printer
- then delete the watermark once the document has been printed.
Can anybody help me with some code for this? I'm not even sure where to
start. I did try recording the macro but I'm now stuck.
Thanks
...
|
7 |
11/23/2008 7:38:03 PM |
|
|
Is there a text selection event to use to capitalize selected word
Is there a "text selection" event? I want to enable a user to scroll through
a document and simply select those words that need to be initial-capped
(i.e., the first letter capitalized).
Below, I inserted code that would change the cursor to an Ibeam
I need code that would allow me to repeatedly apply two lines of code:
Selection.MoveLeft Unit:=wdWord, Count:=1, Extend:=wdExtend
...
|
13 |
11/19/2008 5:08:01 PM |
|
|
open table command
We promot code for our client once a month, and most times database tables
change. I'd like to set up a macro to open the linked table manager (found
that command), and be prompted for table names (or portions of table names)
that need to be relinked.
Is that possible, without having to write code?...
|
2 |
11/17/2008 10:16:10 PM |
|
|
Change Title property in Word 2007
In Word 2007, I am trying to change the Title property. Here's my fledging
attempt:
ActiveDocument.BuiltInDocumentProperties(Title) = "Junk"
Of course, this fails every time. I suspect that I am doing a lame job of
referencing the member of the collection because the following code works:
ActiveDocument.BuiltInDocumentProperties(1) = "Junk"
Is it possible to access the title by the...
|
9 |
11/17/2008 8:56:16 PM |
|
|
Replace remove Links from Excel in world fields
Hello,
I am not sure, maybe there is another solution without VBA, but I
didn't find it.
Steps to reproduce the issue:
1) Create a new Excel file, create a merged cell with 5 columns, enter
some Text in this cell, mark this cell and press CTRL+C
2) Open a word document enter some text, add a text field, move the
cursor anywhere in this text field, choose "Edit"->"Insert
content"->"un...
|
4 |
11/17/2008 4:17:54 PM |
|
|
Word Templates
Hey guys
This is my site http://www.wordtemplates.org/ Give me Some suggestions
and feedback about my site please that how can i improve my site ??
Thank you so much in advance
here is a short intro about my site please check this out
A huge collection of [URL="http://www.wordtemplates.org/"]Word
Templates[/URL] are presented here to help our visitors in their daily
tasks. Our collection in...
|
1 |
11/10/2008 7:12:20 AM |
|
|
How to retrieve the paragraph number of an auto-numbered paragraph?
Hello,
I need a function that returns the paragraph number of an auto-numbered
paragraph.
Any help would be appreciated. (I use Word 2002.) Thank you in advance.
...
|
3 |
11/5/2008 8:25:00 AM |
|
|
Font formatting in a userform text box
I want to create a splash screen with user instructions. To be most readable,
the titles for the different paragraphs should be bold, but the paragraph
should not be.
Can this be done in a text box? If not, what approach should I be using?
Private Sub UserForm_initialize()
Dim Text As Variant
Text = "Controls for editing are on the custom Add-in toolbar" & vbCrLf
& vbCrLf
...
|
2 |
11/3/2008 7:07:26 PM |
|
|
Mail merge in office 2007
My requirement is to create the mailmerge documents in office 2007 formats
i.e. using .docx and .docm. I am using a template for the same. I have
changed my template name from .dot to .dotm. I am saving the header document
as .docx and main document as .docm
when I try to reopen the mail merged main document, i am getting the
following error "The Office Open XML File cannot be opened be...
|
6 |
11/2/2008 6:14:53 AM |
|
|
VB Help
I have a excel spreadsheet in VB. I want to create a similar report which i
have a query and a PROC in sql.
Can anyone help me create this report ??
Thank you
FM...
|
2 |
11/2/2008 6:12:11 AM |