Sub Mail_workbook_KI()
   Dim OutApp As Outlook.Application
   Dim OutMail As Outlook.MailItem
   Dayrep = InputBox("Enter no. day of  report.", Default:="0")

I'm still in trouble with my count problem. The problem was this:
i have numbers 1 and 0 in column a, i would need to know how many 0 ar
between ones. how could i find it out? this 1 and o sequence is ver
long

Is it possible to have the text format in a comment box to automatically be
uppercase?
Thanks in advance for any help
regards

I have 2 tables and i need to get the unmatches between the 2 tables
(fast way because its a long tables ~35000 rows)
thanks for help.

I have set up a worksheet, using the increment macro, which enables me
to send purchase orders via e-mail. Every time i go into the work
sheet, i run the macro and the invoice number increases by one giving
me a unique order number each time. I then save the file as that order

I would like to know how can i call a store procedure(programmaticly)
from Excel
I want to Call a Store procedure and also pass parameters to it and
some of them are dates.

I have a real-time system pumping out DDE feeds from a manufacturing process
into Excel. Calculations are done on the input (up to 40000 rows) and this
analysis is used to feed back to production managers. Originally, this was a
single feed into a single Excel workbook. However, I ...

I would like to use C# to code against excel workbooks instead of VBA.
I am aware of the existence of Visual Studio Tools for Office but it doesn't fit
my needs.
Visual Studio tools for office creates a DLL that is accessed by the workbook.

hi, sorry that I need help in creating the following:
column B of Ws2 contains the IDs(may have repetition).
When it runs, it will go to Ws1:column A to look for the same ID.
Search for the cells with color 'blue' on the whole row below the ID in

I'm reducing a 6000 row data set by four fold.  I wanted to use the following
macro to delete every three rows, but the String function doesn't seem to
work in a macro to generate a valid row range.  Suggestions?
Sub Macro1()

I create reports using an SQL to external data. The report then copies
particular data to division tabs and saves as a separate file. The trouble
is when we open the new spreadsheet there is a link to that External data
and if someone tries to refresh the data, they see my ...

I've two excel worksheets.
worsheetA has names of people and their father's name.
Name     Father's Name
A           AsDad

Alright, so here is my situation. I've tried to get this to work for a
while now...and just can't seem to figure it out.
Let's say you have columns A, B, C with data in them. Column D is a
boolean value...true/false, 0/1, whatever.

I have 1 sheet per tenant with their information and X amount of
tenants. The 4 cells that the macro looks at in each sheet are
different dates. For example Lease End Date is one of them. So 1st part
of the If is if the date of the lease end is today or past today make

i want to develop after the binding excel files.
but, how to make grouping the excel files like .vbg in vb6.0?
there is VBAProject in default in excel.
i want to bind the excel files to one project group.