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 ...
|
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 ...
|
