I have written an  Excel VBA Add-in function that is used in
myWorkbook.xls. The function
opens Word and uses a data in one of the myWorkbook.xls worksheets as
the database for filling in a Mail Merge fields in the Word document.

I am reading a text code (12 characters) taking the middle four
characters and need to re-output them to a certain place in the
spreadsheet. This has to be done programatically, since other
calculations are used and decisions made whether the code is needed or

I have a procedure that formats Worksheet1 when something happens in a
certain cell.  Worksheet1 is titled: APPLES.  The procedure I have for this
works great.
Working part of the procedure I have now looks like this:

I have recently had a problem with date formats in ComboBoxes Joel solved the
problem with this:  string_date = format(mydate,"mm-dd-yy").  Continuing with
the form I now want to add a ComboBox to select a time from a range of cells.
I thought I could modify the code above to  ...

does it make sense to do a find within a find to determine some value?
i have a formula that uses index/match, but with almost 100k formulas, the calc is too long.
so basically in code, i find a value from ws1 column d (1), on ws2 column e, to get the value in column f(745).
then i ...

I have a workbook with sheets numbered 1-31 for each day of the month.
How can I program this to open on the sheet for the current day?

In my workbook_open routine, I have "Application.AskToUpdateLinks =
False", and I'm getting the result I want.  its not prompting for the
dialogue to update the links.  However, the workbook contains links to
other sheets that are not opened yet, so I'm getting the dialogue that

I am using a macro to add data to a worksheet.  I want to print the
sheet afterwards, but only enough pages to print all of the data plus
an additional 40 rows or so, for additional written input.  How can I
do this?

I would like to add a custom button to an Excel toolbar (Excel 2003)
that could switch between activated and deactivated mode, that is to
say, the same behaviour as Bold, Align Left, Align Center, etc.
buttons, that remain pressed when the functionality is active.

FACT:
I have written Module which prints Pay Slips for the Employees based
on the Work Sheet data. I have designed pay slips for A3 size paper,
where 6 pay slips are printed per page. I have data for 5000

I have added a new toolbar to a sheet and I want to have the buttons show if
they were last depressed.  I tried to use the toolbars.Toolbarbuttons.pushed
= True command but it gives me a type mismatch error. Any ideas on how to use
the command?

I have a set of tabs in a workbook template. I would like to have some of the
exsisting tabs automatically rename according to specific cells on another
sheet.
example:

I have a sheet on which I import data from an external source. After
importing data, I need something to remove complete rows that match a
specific criteria.
For example:

Hello.  Would anyone know if it's possible to have a user use their windows
domain login to log into an asp page that has an excel file link in which it
will open the excel file and somehow show and hide only portions of the
excel worksheet based on their windows domain ...

I'm trying to develop a multi-stage macro that will access a group of files,
and look at the last saved date. If that date is more recent than the file
the macro is calling from, I want to open, and then copy a portion of the
second file into the first.