I have a menu from an Add-In, when all workbooks are closed and all the other
menus are disabled mine remains enabled.
How can I disabled it so if someone clicks it no error message is generated?
Just as the built-in ones.

I'm a reasonably experienced programmer, but not with VBA.
I have a copy of a workbook which downloads some information from a website.
In the VBA code, there are references to DOMDocument ... e.g.
Dim oDom as New DOMDocument

  Here is my problem - I have 5 workbooks in a folder, each with 11
columns. Could anyone please help me with this - I want to take value
from C1, G1 & I1 and compare it with C2, G2 & I2 and down. If it finds
a match then I need to increment a counter. Once it goes through the

Guys
Can anyone advise how can i enable the paste and paste special option
in the right click menu. I ran some macros and these options got
disabled. Kindly Help

Guys
Can anyone advise how can i enable the paste and paste special option
in the right click menu. I ran some macros and these options got
disabled. Kindly Help

how do i add a 0 in front of an existing range of numbers, I have a phone
system that has a lot of speed dials, the numbers will only work if there is
a 0 at the start of each number. Wat too many to do one at a time.
Can anyone help with this one?

If I create a new workbook, I can assign it to an object variable...
Dim wB as Workbook
Set wB = Workbooks.Add
How can I open an existing workbook and assign it?

I was trying to incorporate the keydown event to my userform.  I
wanted to initiate the Closing when ESC button is pressed.  The code
is given below.
'***********************************************************

 I have a some of workbooks in a folder, which I created using a
macro (from text files). The coulmns and data types are the same
across these workbooks. Column C has a 15 digit number, I need to
extract the first 2 digits from the column and insert it in another

I need some help in making this line of code search just the left 3
characters of column 'M' starting with cell 2-5000.'T' represents
CbxDept.text and column 'M' holds an alphanumeric number that is automaticlly
created so the first 2 to 3 characters are letters. This line is ...

I have an aplication to retrieve data from Access query or local table
Are there any example that I can use to pass parameter to the query to get
report?
Your information is great appreciated,

We need to ensure that a hot key will only activate from a given range (in
this case any cell in Column B).  The code below shows 2 attempts (1 attempt
is commented out).  Any help on this would be greatly appreciated!
ActiveCell.Select

Can someone help me with the code to save an excel worksheet every
fifteen minutes? I will need some sort of a sleep command - what can I
use in excel? What is the syntax?
Thanks a bunch

Are text boxes and labels the only controls that will display text on
a Form?
If you use a label is there any way it can have vertical scroll bars?
Can a text box display text at the start of text, rather then the end?

I use Scheduled Tasks to open, update and close several workbooks each
day. Sometimes at the end of the day there will be an Excel instance
or two showing in the Processes tab of Task Manager. Is there a way I
can find out which workbook is associated with the open instance, or