I am writing a macro that generates several chart from info that is placed in
a worksheet. The code I am writing has to be very dynamci so I cannot record
a macro etc. I want to create several chart types first e.g. one type of
chart that has some settings and borders etc. I then ...

I have a macro that I want to change the color of the tabs ( I think it is
tab in english, I am referring to the small part of the worksheet that
displays the name etc..). When writing the code I want to select a number of
tabs and then change their color instead of writing code ...

Sorry but this is a question about XP, couldnt find a discussion group so
thought some here may know.
I am currently running a laptop on a docking station linked up to a 20" flat
screen.

I am working file that will generate invoices and then delete its
information and the macro to make it smaller and simpler for email.
There are a few tricks I cannot seem to accomplish and I was hoping to
get some help.

I'm having trouble figuring out the following formula
If F6 = b and If G6= b then put N otherwise put P BUT if F6= n and G6 =
n put N otherwise put P.
Does that make sense - having trouble with the double if then statement

I need to select a range of information, for example
Sheet1.Range("A17:K17")
but due to variable incoming information i need to cupple the range to

I am writing a macro the generates charts onto a new worksheet. I want to be
able to decide in the code where I want to place the charts. How do you do
this? When recording amcro I cannot make the placement exact so how do you
write the proper code? Please help me!

I have a macro that I want to change the color of the tabs ( I think it is
tab in english, I am referring to the small part of the worksheet that
displays the name etc..). When writing the code I want to select a number of
tabs and then change their color instead of writing code ...

I am writing a macro that creates charts. In order to control these charts
better I want to add them as chart objects. Therefore I write the code as
follwing:
Set chtChart = Charts.Add

I am writing a macro that creates several charts. Now I want to be able to
assign the size of the charts (as well as the size of e.g. the plot area) in
the code so that the charts will be exactly the same size. How do you write
the code for this? When recording a macro for this I ...

I'm using a Word object to write information to the registry from within
an Excel Macro (this is in order to generate a PDF file using CutePDF).
Everything works fine but the Winword object is still resident in
memory.

I would like Excel to execute some kind of initializing macro automatically
when it starts. Does anyone of You know whether it is possible and if so, how
to do that? Thank You in advance,
                                                 Radim

Good morning all!
I want to be able to let the user select multiple files from a
GetOpenFileName dialog box, but also filter the file list to Excel files only
and trap for the user pressing Escapel.

I need to select a range of information, for example
Sheet1.Range("A17:K17")
but due to variable incoming information i need to cupple the range to

What code is needed to tell excel to update a file when opened and not to
update a file when opened?