When I execute "Commands.Bat" (see below for content) in the CMD window,
the file "Commands.Out" is created in
               "E:\Data - Mac\Mac's Documents\Application Data\".
But when I execute it from the Shell Command in Excel with

I have a VBA script to send an mail and I'd like to send it automatically  
after I upadate all info in the worksheet. The email was sent ok, it always
pop up a dialog asking me to confirm before sending message. How do I
eliminate this pop up?  Below is the message on the pop up:

used auto filter to build a macro works fine then copied it over and edited
for next sheet 8 times works all except 2 sheets. can see no diff except edit
I did. Here is one that works and one that doesn't  five works six doesn't
six produces header no data. modules 1-5 work fine ...

I am using Excel 2003 for my project and I have to set color of an autoshape
in column C based on the value in column B. For example:
*If the value in column B < 80%, a little square in column C must be Red
*If the value in column B is from 80% to 89%, a little square in column C

How do i write  "Get row W from worksheet X and copy row W  to row Y
(inserting row W in the position where row Y is) on worksheet Z" in VBA?
WXYZ would be variables in my script.
Thanks!

I have have wrote the following code to get a value from a cell in one
spreadsheet and put it into another sheet.
The problem is the value is in money ie £25.68 but when the macro puts
the value in the other sheet the value is rounded up or dowm ie £26.00

I need to insert a row on multiple adjacent sheets.  I need to do it as a
group because I have a 3-D summary sheet whose reference must remain aligned.
The active cell on each sheet may be different.  I want to insert the row at
the location of the active cell on the active ...

I need help for the following situation:
If A1:J1=0, Average A2:J2(true), 5(false)
I typed in the fomula:  IF(A1:J1=0,AVERAGE(A2:J2),5)
But it did not work.  I kept gettng #signs.  Deeply appreciated if  somebody

hello my name is Jeff, i work as a quantity surveyor in auckland, new
zealand.  i need a function creates a Quote Number everytime i click
at a command button. as sometimes we double the quote number.  and if
there are anyway to check if there are some Quote Number that was

I have several lsit boxes that move from one to another.The original
contained data that was hyperlinked (to external sources). When they are in
the list box the hyperlinks diappear. I want to keep this feature. Any ideas?

hi Bob
i have a following code
dim t_string
t_string= target.value

Hello everybody,
It's been a while since I posted last, but yet again I'm here to ask for
your wisdom and advice.
The task: I have a worksheet, each column contains specific information.

We want to sign a bunch of files with excel macros
programmatically.
Anyone knows of C#.Net or VB.Net solution?
Fileformat is excel 2007 (Open XML).

k, I don't remmeber who it was, but I saw VB code that was used incase your
were run a older vision of Excell other than 2003 or 2002. Any ideas? I
belive it alow the VB code to work in older Excel spread sheet.
thanks

When I click on a tabsheet to open a sheet I would like that automaticly
u=one macro start to update this sheet.
It is possible?
Thank you in advance