|
2 sub
hi i´ve got two subroutines: the first looks like
Sub SME_novaRubrika()
Dim rubrika As String
Dim datum As String
datum = InputBox("Zadaj datum pre clanky", "DATUM", 2004)
rubrika = InputBox("Zadaj nazov rubriky pre clanky", "RUBRIKA")
then i have another subroutine, in which i want to use actually assigned
variable datum from the first subroutine. thanks for help...
|
4 |
6/23/2007 4:49:53 AM |
|
|
Putting 2 lists in a combo Box according to 2 OptionButtons
I am trying to have 2 Option Buttons that would determine which list
would appear in the same ComboBox.
...
|
2 |
6/22/2007 3:40:28 PM |
|
|
Class functionality for multiple templates
Hi,
I develop in Word 2000 (VB6). I have a class that offers functionality
to multiple modules (macros). Now i have multiple templates that also
need that functionality. Instead of copying the class to each template
i search for a more comfortable way, with only one instance. Is the
only solution to create a dll file?
greetings m
...
|
6 |
6/21/2007 12:41:25 PM |
|
|
Word doc in an email
I'm attempting to insert a Word document into the body of an Outlook email
created by the Outlook mail object in an Excel worksheet. Essentially, the
user clicks a name in the workbook and an email pops up with the contents of
a shared Word doc as the body.
Having all sorts of problems with the mail object reading carriage returns
as EOF markers, as well, it can't handle the bulleted l...
|
1 |
6/20/2007 1:45:10 PM |
|
|
run macro on exit of dropdown field
If "yes" is selected from dropdown list, a macro on exit should
unhide the hidden text of the document.
The dropdown list is called "noyes", and the macro is called
"unhide".
The possible values of the dropdown list are only "yes" or "no", "no"
being the default.
The idea is to have a hidden paragraph appear if "yes" is answered.
Word 2003. The document is protected, to have access to...
|
2 |
6/19/2007 9:20:09 PM |
|
|
Help with page numbers
Windows XP Pro SP2
Word 2002 SP3
Really not a VBA question, but I guess it could be.
I am trying to insert page numbers in the footer by means of the Insert /
Page Numbers... method. Unfortunately, the only thing showing up in the
footer is the value
(PAGE )
on every single page. I fully realize that I must have inadvertently made
some setting change, or maybe even changed som...
|
2 |
6/19/2007 1:33:37 AM |
|
|
Document conversion
Is it possible to create a drag and VBA Word application that is drag
and drop. I wish to take a text file and drop it into the desktop
icon where it will be inserted to template and then spit out two
files, one as a *.doc and the other as a *.pdf document. Double
clicking on the icon would launch configuration window which allow me
to change, say, the footer, or cover page. Or is it just ...
|
3 |
6/18/2007 4:08:16 PM |
|
|
save as cancel event
I use the following code to use bookmarks to put the save as filename
in the save as dialog box together. It works perfectly fine until I
cancel the save dialog. So I think I'm missing something to handle
this event. Does someone know where and what to include in the code to
not get error messages in case the cancel button is pressed?
Sub filesaveas()
Dim oStory As Range
Dim pFileName A...
|
6 |
6/18/2007 4:35:25 AM |
|
|
Folder Tree in Word Document - directory.docx (0/1)
Hello,
Is there a macro, or someone who can help write a macro to do the
following:
I have attached a sample docx file to demonstrate what I am trying to
do which is this:
Problem: I want a directory tree inside a Word document so that I can
create PDF files to go on my CD's. At the moment I am starting to do
it all manually and it is driving me crazy. I am not a programmer but
hav...
|
2 |
6/18/2007 4:15:11 AM |
|
|
Find & replace with wildcards not working in macro
I have a macro with a find and replace array. I haven't had any
problems with using wildcards until I tried to replace every instance
of "#-#" , i.e. "3-12" or "5-9" and simply replace the dash with "to",
i.e. change "3-12" to "3 to 12." Anyway, these find and replace terms
work perfectly in Word:
Find: ^32([0-9]{1})^45([0-9]{1,2}[!0-9])
Replace: \1 to \2
But, when I use the same in ...
|
5 |
6/17/2007 7:02:11 AM |
|
|
selecting field codes and copying and pasting them
I have been trying to make a simple macro so that I can copy certain field
codes from a document and paste them by themselves into a new document so I
can look at them. When I record the macro, things work out fine as I do
them: I first search to highlight the term "^d SET" (the SET is part of the
code I want) then copy and paste it into a new document. It works fine when
I do it, but...
|
2 |
6/15/2007 9:43:42 PM |
|
|
Stop user moving a logo
Hi
Is there a way to prevent the moving of a logo in a template by the user?
Thanks...
|
3 |
6/15/2007 10:45:05 AM |
|
|
Fix position of a paragraph
I would like a paragraph to always start exactly 3 cms down from the
top of the page, and the next paragraph to start 10cms from top of the
page.
Is there a way I can fix the postion of a paragrah?
...
|
3 |
6/15/2007 8:15:46 AM |
|
|
How do I populate a combo box in microsoft office word 2003?
I am trying to create a form in word 2003 and I need an application
where I can select more than one answer for a question. I therefore
am trying to create a combo box but I have no idea how to populate
it. I have tried entering the options that I want in the combo box in
the 'value' field but i only succeed in having one line.
Any suggestions???
...
|
7 |
6/14/2007 1:00:38 PM |
|
|
Mail Merge removing macros headache
Hi there,
I have a word mail merge that gets data from a 3rd party software. It
receives data such as contact name and project value.
The project value then populates in word. I have a macro in word that
if you change the project value it will then update the rest of the
fields based on the new project value. This is achieved via a macro.
Problem:
As soon as I mail merge in word to ge...
|
3 |
6/14/2007 10:02:00 AM |
|
|
Working with Outline levels and paragraphs in VBA
Windows XP Pro SP2
Word 2002 SP3
I'm new to working in VBA with Word, but I've done tons of VBA in Excel, so
I understand the environment pretty well, just not the Word objects.
I have a Word document that was created from a text file, presumably
Notepad. Anyway, all of the "paragraphs" have hard returns at end of each
line in the paragraph. If I'm not mistaken, Word will then treat...
|
2 |
6/14/2007 4:13:23 AM |
|
|
Find previous Table and select Table
Hi,
I am looking for a way to find the first table before the pointer and then
to select this Table in order to reformat the table properties.
Any ideas ?
Nde...
|
3 |
6/13/2007 4:41:59 PM |
|
|
Calendar Control
Hi,
Could someone please tell me how to use a calendar control in a worksheet.
For example, Cell A1 is a required date field. Is it possible to have a
calendar control pop up when you click on cell A1, select a date and have
the date selected entered in cell A1.
Is this possible.
Any help please
Regards
John
...
|
2 |
6/12/2007 7:53:49 PM |
|
|
SaveAs Code Maybe? Mail Merge
Hello All,
I am not sure this is the correct form, if not maybe someone can tell me
where I should post.
Here is my goal.
I have an Access database that opens up several or just one Word Document(s)
depending on which document(s) they select. I have my queries in Access as
the Data Source. Depending on which icon the user click the report either
opens in Word or prints directly ...
|
5 |
6/11/2007 7:47:34 PM |
|
|
Use bookmark as filename in save as dialog
I've been reading several usegroups for hours now and couldn't find a
solution that works.
I have a document with bookmark field called "Document_title".
I want this field to be words suggestion for the filename when the
file first gets saved as.
I also have a little more code to update other bookmarks in the
document on save and save as:
The following part updates the fields / bookmark...
|
6 |
6/11/2007 12:53:39 PM |
|
|
Extracting Section Labels and Titles
Hi there,
I'm sure this is a very beginning question but I have been having
trouble figuring out a function or method in Word that will extract
the numbers and headings from labels I have already created. I want
to be able to move from one section to another and look at specific
text keywords within each of the sections but still keep track of each
section I am in.
...
|
2 |
6/9/2007 9:35:40 AM |
|
|
Selecting Specific text while keeping place in a document
Hi,
I am writing a macro for a huge word document that will label certain
conditions (from about 1-2000) and will isolate the sections and
conditions of these conditions and place them into a neatly formatted
CSV file.
The document is in this kind of format:
*********
(bold)1.2.3.4 HEADER(/bold)
Here is a condition and a keyword[number] that is indexed.
Here is another condition and a...
|
2 |
6/9/2007 7:48:24 AM |
|
|
Unbound Merge Field
I am trying to automate a Word document from Access. My vba code works to
open the doc from a template and pass data to populate all of the bookmarks
with the appropriate text (using selection).
I want some of the data I pass to appear in multiple locations (Mystring1 to
the header, paragraph 1, etc.). It appears that each bookmark can only
reference one location. I could say Bookmar...
|
5 |
6/8/2007 2:03:50 PM |
|
|
ComboBox
I've just figured out how to work with VBA for word, but I seem to be
doing something wrong, and i don't know what it is, so: HELP!
This is what my macro looks like:
Sub ComboBox1_Change()
ComboBox1.AddItem "Nederland"
ComboBox1.AddItem "Europa"
ComboBox1.AddItem "Wereld"
End Sub
Somehow this works, until i close the word-document and open it again.
The macro's are still visible in vb...
|
3 |
6/7/2007 11:16:41 AM |
|
|
inserting text before and after italics
Hello,
I'm trying to write a macro that finds all italics in a document and
then inserts text before and after the italics. The problem I have is
that my macro (see below) does not find all the italicized text in a
document.
Sub FindItalics()
Dim myParagraph As paragraph
For Each myParagraph In ActiveDocument.Paragraphs
With myParagraph.Range.Find
.ClearFo...
|
3 |
6/7/2007 10:30:39 AM |