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 ...
|
move mails to folder in a local pst depending on date
Tue, 1 Jul 2008 03:16:00 -0700
Hello
For support reasons we backup mails that are send from the mail server.
Whenever a user complains he didn't receive a mail we can check an prove
otherwise or not :-). These mails are saved per month, ie. for each month
another pst. Now I have created rules that look when the mail is sent (eg
between ...
|
how to copy cells from excel files and paste it to
another?
Mon, 30 Jun 2008 10:17:09 -0700
Hi!
I have 160 excel files and i'm writing a macro to help me copy some cells from each file and paste them to file called Sample.xls.
I have a loop that enables me to run the macro for all the 160 files in one folder but i want the information from each file to be in one row and then the information from anot ...
|
Using VBA to create a formula
Tue, 24 Jun 2008 07:09:02 -0700
I am trying to create a formula (in VBA code) that will enter a formula in a
spreadsheet to count the number of cell entries. The count formula will be
for a random number of rows and may appear anywhere on the sheet.
Eg i want to take the active cell and enter a formula to do the following =
counta(start a ...
|
|
|
Pass ListBox Values into TextBox1 Field
Thu, 19 Jun 2008 22:55:00 -0700
Ok...I have a MS Words form. I created a textbox in this form.
The other thing that I have is a "UserForm" with a listbox.
When an user select any one value from this listbox, I want that value to
populate the "textbox".
Here are my codes(in UserForm):
Private Sub CommandButton1_Click()
ActiveDocume ...
|
Autotext - set the 'Look In' drop down to a specific template
Wed, 18 Jun 2008 15:09:09 +1000
Hi all
Is it possible to programmatically set Autotext 'Look in:' drop down field
to display autotext from a specific template using VBA?
I am using the code below to show the Autotext menu where a user then
selects the desired entry, but I am hoping to only show entries from the
attached template:
...
|
Track Changes VBA Granular information needed
Tue, 17 Jun 2008 06:43:03 -0700
I have a VBA code that allows me to extract and create a new document and
formatted report of the track changes that happened to the document.
However, I need it to be more specific in what changes.
Sorry for the clarification issue.
1. I need to know what fields ( wdrevisionproperty etc etc. ) I can us ...
|
