The following macro run until the language inside the control panel has not
been set to english. The problem I have is that "Shell Cmdl$, vbNormalFocus"
show a box but the macro run during that time. If the language is not set to
english before the macro start, Shell Cmdl will be ...

I created a simple add-in that contains one module (module1) and that module1
contains a simple macro (macro1). I posted that add-in to a file folder on my
desktop and then added it to my Excel Application. So, if I look in the VB
Editor I can see the new .xla as a separate ...

I have an add-in that i load at EXCEL startup and modify all the time. When I
open VBA, its modules usually aren't displays as it is for any modules of
workbooks.  How can I ensure they are displayed and in the same place as when
I save the add-in?

I want Excel to background colour a cell, Red, Amber or Green using
conditional formatting dependent upon
the data in it compared to the data in the cell immediately left of it.
e.g. if the data is equal, or lower value = red

I am new at creating formula in Excel.  I am trying to create a specific
timesheet.  The employee can work a maximum of 70 hours in 7 days.  I have
created this formula, which works for the pass 6 days but when I use it for 7
days, I have too many argument. I also have to create ...

The below code (supplied by Ron de Bruin) is working fine, except for
the following:
When in Design Mode I see the Full month Calendar (Sunday - Saturday),
but

For a cell, how can I set up an user-defined formula that can convert a
text value into MD5?
I looked at this website on VBA script for MD5 encryption, but I don't
know where to go from here:

Good Morning.
Found this code in the archives and it works great except that it also
copies the text in the header row.  It works perfectly in that it only
captures text and not anything in empty rows in the print area, but is

I am still to work out an effective solution to this:
I have a list of dates in a (mmmm yy) format in Sheet1 Range(B17:B28)
At the end of a macro in another sheet I want to place Now() in a
(mmmm yy) format in the Cell NEXT to the MATCHING Value in Column C.

I'm looking for some code to perform the same group of operations on each
worksheet in a workbook.  It seems to be a very simple operation, but I can't
seem to get it to work.  I have tried the following:
Sub Timesheet_Format()

I would like to modify the "Regional and Language Options"/"Standards and
Formats" from "french canadian" to "english canadian" using vba. I tried to
modify "LOCALE_IDEFAULTLANGUAGE" value but it doesn't work. I have pasted my
program. Does anyone know how to make it work.

Struggling here and maybe being a bit thick, however had a look at Tom
Ogilvys resonse to a similar question on the 16 August 2006, tried to use the
same principals to no avail.
I have a number of PC's with large number of files that I am trying to tidy

I have an excel timesheet that I want to do a simple task - count if an
employee ever works 7 days in a row.
Any Ideas?
Thanks,

I made autofilter by tow fields and I get 131 filtered rows.
Rows 2058-2102 and 3758-3842.
I want to over on all rows and get data for it.
When I do it I success to over only on the 45 first sequential rows.

Excel XP & Win XP
I have a variable number of columns after Column B hidden.  With the active
cell, B4, how can I reference the next visible cell in row 4?
Thanks for your time.  Otto