Can someone tell me how to exclude the header or titles from the
results of an ODBC query against a MySQL DB.
Here is my code in case someone else would like to use it.
Sub get_oem_data(RowIndex, LastRowOfData, Program)

Hello;
Book1.xls and Book2.xls, each has few events.
For editing purposes, if I open Book1 (which has Application.EnableEvents =
True in its ThisWorkbook Open event module), and then open Book2 (which has

How can I call a subroutine that is in another workbook, without using
a menu option?

All:
I have a VB.NET application that reads an Excel Template Spreadsheet to get
a specific cell's formatting (border, font, size, etc).  I want to copy the
cell's formatting to another cell.  I am using VB.NET and here is the code I

I have a workbook with many named worksheets.
The sheets are selected from a ListBox which shows their names.
Is it possible, programmatically, to cause the newly selected sheet's tab to
show the sheet name and the previously selected sheet's tab to revert to the

I have written down a function which checks for "expiration" and other
like statements from another sheet within the same workbook. It
calculates that fine if I calculate that cell be cell. However, if I
calculate for the whole workbook, the calculation bar stops at 0%. When

I have the following
Rows("1:" & x).Select
But now I am trying to find the syntax for selecting rows based on two
variables.

I HAVE TWO DATES IN TWO CELLS,150 DAYS APART.HOW CAN I HAVE ONE DATE CHANGE
RED AFTER 150 DAYS ARE UP

I have an excel sheet containing data from which I need to prepare a pivot
table. I want to prepare a pivot table that not only works for this sheet but
is global (the only thing that would be different between the sheet would be
the size of the data, header row remaining the same)

I have an Excel 2000 list from which I want to run a SQL statement to select
unique values (ie. with SELECT DISTINCT ). My question is, how can I fill a
listbox with the resulting result list?
I want to achieve this without pasting the unique values on a worksheet.

I want to check the column B2 to B265. If observations in that column are
smaller than A2 then I want to sum them up. The sum is then placed in C.
Please help me out!
SUM.IF($B$2:$B$265;<A2;$C$2:$C$265)

Hello! I try to perform a very simple task using Bloomberg and Execl. I have
an Excel spreadsheet that contains a list of bank names, their ISIN codes and
their Bloomberg tickers. I then have a macro that I (am trying to) use to
extract ratings for these banks from BBL into Excel ...

I am using the ExecuteExcel4Macro to extract data from multiple workbooks
without having to open them first. It works very well until the routine
encounters a wb that is password protected. When this happens; the routine
prompts for a workbook password; is there a way around this? ...

All of this explanation assumes that the UDF will only look at one row so by
range I mean a specified number of columns in the same row that are all
clumped together (no breaks in the range).
I need a UDF that can be dragged down to start in cell D2 that will look at

I recently added the following code to a spreadsheet to add a right click
menu to run one of my forms/macros.  The problem that I'm having is that it's
adding this to every spreadsheet and also adds each time so there are
multiple instances of the same right click menu item.  I ...