Macros for Microsoft Excel Worksheet in Microsoft Word Document
Fri, 18 Jul 2008 00:24:21 -0700
Hello,
Using macros in Microsoft Word, how is it possible to:
1) Set the number of rows and columns for Microsoft Excel WorkSheet?
2) Put the values into the cells of Microsoft Excel WorkSheet?
Recording macros in Microsoft Word gives the following code:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded ...
|
Removing Specific Styles
Thu, 17 Jul 2008 06:38:03 -0700
Anyone have code to remove specific stlyes from a document?
I created a Macro to modify the name of the Style, but need to remove the
old from the list, but only specific styles.
Thanks! ...
|
Track Changes Issues
Mon, 14 Jul 2008 08:43:01 -0700
I created a Macro that allows me to extract all the track changes into
another document and lest them all out.
However, I noticed that there is a Track Change Ballon called Formatted
Table, when the format of a table is changed and it lists it as a Track
Change.
However, this causes my macro to blow up a ...
|
Styles Macro
Fri, 11 Jul 2008 09:37:01 -0700
I need the ability to take an exsisting Style within a Doc. and have a macro
to change the name of a specific style.
So for instance, I need Bold Header1 to be renamed Bold Header2
I have been looking at the replace feature in VB, but it does not seem to be
working. Here is the code I created to do that.
...
|
Wherein have I wrong?
Thu, 10 Jul 2008 04:03:22 -0700 (PDT)
Hello.
I create one macro that should to show info about paper size. Then I
tryed make it in function but I get error. That code.Wherein have I
wrong?
Sub psize()
MsgBox IdentifyPaperSize(ps)
End Sub
Function IdentifyPaperSize(ps As String) As String
'Identify Paper Size
Dim iPaperSize As Integer
Dim p ...
|
Word Macro to Format Research Data
Thu, 10 Jul 2008 02:29:57 -0700 (PDT)
Hello all, I seem to have gotten to the point on a project that I must
ask for a little help from my peers! I've only recently realized the
benefit to be had from using macros, so please no pointing AND
laughing; either point OR laugh.
I need to get
OS Schizosaccharomyces pombe (Fission yeast).
OC Euka ...
|
Can we disable macro security using Visual Basic for Applications scripting in Word 2003?
Thu, 3 Jul 2008 22:18:24 +0500
Hi,
I have win xp sp3. I use Office 2003. I want to have certain things done
automatically
using Visual Basic for Applications in my Word documents for which I
require that Macro security be
set to lowest level or disabled for that period so that my required things
could be done in that
particular ...
|
|
|
Macro to work on picture
Wed, 2 Jul 2008 03:55:01 -0700
Hi i need to record macro which inserts an image(From file) in to the image
control. How do i go about doing this ...
|
Macros
Wed, 2 Jul 2008 03:21:02 -0700
Hi i am using Word 2003 i am very new to this. I need to create a Macro and
add it the toolbar, where in this macro inserts an image to the template when
clicked. Please can anybody help me ...
|
Conditional Format- Refresh
Tue, 1 Jul 2008 19:52:01 -0700
I have added a VB script to a sheet to change color of the cell based on input
Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer
If Not Intersect(Target, Range("F1:F510")) Is Nothing Then
Select Case Target
Case "Red"
icolor = 3
Cas ...
|
