I've tried the below function over a range of 6000 cells.
'======================================
Private Function TrimAll(myTrimArea As Range)
     Dim cell

In several posts I've seen the following to allow automatic updating of links
on workbook open without the excel warning being displayed.
Application.Workbooks.Open Filename:="D:\TEMP\sample.xls", UpdateLinks:=True
I've entered the above code in my workbook open event. However, ...

Would it be possible to time how long it takes for Excel to open a workbook
and dump the result (amount of seconds) in a cell? I can't find anything
about this on the net, but I'd like to know if it's possible at all?

I'm trying to load an add-in when my workbook opens. First I created an
add-in at "C:\data\test_addin.xla" that contains the code found below in
"CODE 2" section. Next, I added code found below in "CODE 1" section to the
file  "C:\data\test.xls". While the add-in was open, in the ...

Can you embed graphics into Excel.
So rather than point to a image file on the hard drive
you could use a picture which would
be included in the .xls file?

Is there an event that is triggered by the act of just clicking on the
dropdown arrow of a validation cell, i.e. BEFORE an item is selected?

I am trying to create a program to first of all open an existing PowerPoint
presentation and then I want to use Excel VBA (not  the PowerPoint VBA)
Hide/Unhide slides and possibly make edits to slides in the presentation.
Does anyone have any advice for me?

Using Office 2003 and Windows Xp;
I have a file with a small cell clearing macro as the only program in the
whole file. The file is a regular XLS and there is no code in any sheet
module nor in the ThisWorkbook module.

 Why the second macro does not work, the first yes , it there t it a
resolution so that it takes into account letters. purpose it is to apply
a matrix to a picture without crire on the disc.
purpose it is to apply a matrix to an array  without writing on the disc.

We currently have an excel order form that we are using and there are two
different printers that it can be printed to.  Here is what I would like to
do:
I would like a macro that would bring up a message box stating "Do you have

I have an excel sheet in an older vesion, probably Excel 2003, I open
this in Vista but where my cells say "=qcom(blah, blah) it's
evaluating as #NAME like it doesn't recognise the function
"qcom" (which is there)

I want to perform calculations at timed intervals.  I wrote the
following macro:
Public Function CalcNow(CurTime As Date) As Boolean
Static bInitialized As Boolean

I did not get any errors when i run the macro to get the product list.
when i try calling the macro by clicking on the button, i get this
error msg
run-time error 1004

Please help!
I am currently working on a workbook that has various part nmbers
(2060207-WPI001) on work sheet 7-14-07 in E:E in which I match a 1 to
3 letter designations as in "WPI". In column AI:AI is the dates which

After a recent re-install of Office XP, i now get a:
"EnvelopeVisible" object error with my code that previously worked.
If i >File>Send>Sheet in message Body, i get an:
"Excel could not start the email program" error.