Office 2003
Excel Macro Security = Medium
I have created a rule in Outlook to move all emails from a certain person
and/or subject from the Inbox to a folder. This is a shared Mailbox, so many

I used Ron's calendar control and it is slick!  I can see in the click-event
that the date is custom formatted to mm/dd/yyyy.  I want to add the day of
the week in front of the date.  Is it as simple as changing this line of the
macro, and if so, what should it say?  Thanks so ...

I have a workbook with VBA code that is protected with a password.
I use the workbook, and when I close it, I get a message box that asks
for the project password!!
How can I get rid of this "behavior"?

How do I program it in VBA in a way that;
1. Msgbox popping up for an input
2. Typing file name into msgbox
3. It saves it into hard drive (i.e. c:\Mydocument\)

I have created a program that generates excel templates which need to be
deleted by anyone logging on to the networked computer. I believe the network
is a Windows 2000 NT Server.
At the moment when the excel templates are created (say in C:\Temp or Shared

Hey guys,
I would like to ask you why I receive "Debug" question on the following
macro?
Sub PrintPivTab()

I want to copy some text from IE and paste it into a worksheet, when I
use the macro recorder it doesn't give me the proper code. If anyone
can get me pointed in the right direction I would greatly appreciate
it. Thanks

Is there anyway to call the Format Cells Dialog from within a Macro so that
you can ask the user what format they want to apply to a cell and then apply
it programatically ?
I have searched in a few places and I cannot find any reference or pointer

I tried to do "Text to Columns" with VBA and it works fine except
while it is executing it, msg box comes up and says " Replace
destination Cells? with Ok and Cancel button". Obviously if I press
"OK" I get the result I want. However How do I make it ignore the msg

I'm developing excel automation add-in and I want some of my functions
to be callable from worksheet but do not appear in "Insert Function"
dialog.
I can see two possibilities:

I get this error while running a report in Excel VBA 2003,
my code is
Dim OraSession As Object
Set OraSession = CreateObject("OracleInProcServer.XOraSession")

What is the "Automation" button in Excel's Add-In dialog box?  What
does it do?  What is it good for and how does it differ or relate to
"Add-Ins?"  I would like to use/try it (to improve my Excel skills),
but I find no documentation as how to use it.

G'day macrosaurs ....
I've had a good look around for the answer to this and can't find it, so I
promise I am not just being lazy in calling for help.  I need to be able to
trap the Control-Break "event" when the user hits those keys to interrupt a

Hey there everybody,
while designing a statistical procedure, I was tempted to use Excel 97, for
convinience of extreme oversight. However, I need to solve 16,000
regressions. Not terribelly hard stuff, though the VBA code I designed does

I have written code in an Excel 2003 file that builds toolbars on the fly.
I was hoping the code would work in Excel 2007, but the toolbars are nowhere
to be found. Where do I begin to make these toolbars appear?  I don't want
to have to build a ribbon toolbar.