i'm sure it's been asked before, but i am trying to display a form while i build
a report, but all that's visible is he form caption. it works good enough if i
put the message in the caption, but why does the form show a white background
and no label when it is displayed?

I have some historical data with some missing values for a certain
dates, such as holiday.
I need to replace all the missing value with previous date's data so
that I can do some analysis on it.

Hi, HELP!!!  how to write code to change all cells with "zero" value into
transparent, "not blank",
I got the following from the Excel macro recorder, but it does not work, for
me :-)  

I have an Excel application that contains a number of buttons that have code
behind them which opens various documents (word docs, powerpoint
presentations and excel workbooks).  The issue that I have is that when the
application is promoted to Internet Explorer I can only open ...

Like the title says....
I want to change the text on a worksheet button when I activate the sheet.  
I know how to do it in a dialog box but don't have a clue where to start.
In short, I have a list of projects in a column and have a button above the

How to import a data from a excel workbook without opening the book.
lets say book name "mybook" location is:"C:\Documents and
Settings\BahadiAkcan\My Documents"
using above file can I make a match or vlookup function in a code?

One of my Administrator types is dumping information from AD so some
mid-level manager can justify his position and salary (too sarcastic??  ;-)..
anyway.. AD dumps very verbose information into his cells.
Example:  In cell A2 you have...

Thought this would be simple - its not been today.
I have a workbook with several worksheets and need VBA code to copy the
contents of worksheet "A" to worksheet "B".  Both worksheets "A" and
"B" exist before the macros are executed.

I'm trying to generate numbers for bingo cards - each row as 1 card - columns
A-E for the "B" numbers, columns F-J for the "I" numbers and so forth.  How
do I get the numbers for each Bingo letter -"B", "I" not to repeat?

How do you tell what are methods, properties, objects for an object
like "ActiveWorkbook"? I can look it up in the Object Browser and see
what it's "parent" is, but not what it's "children" are. Is there a
reference source that works like the OB in reverse?

We have Excel 2003 templates and we need to automatically generate excel
2003 xls files based on our SQL server database tables' data. Since we need
to generate the xls files at out web server side, I assume we cannot use
excel automation based on the license agreement.

I'm struggling with the following problem.
I have an excel sheet that exists of two columns, name and e-mail.
Now, I have to print the entire sheet, but it is about 2500 rows long.
Is there a possibility to let excel print it twice per page?

I want to import multiple ranges from multiple workbooks without opening
them. To do this I use the proceedure from J Walkenbach, nested into For Next
loops...
arg = "'" & path & "[" & filename & "]" & sheet & "'!" & Ref

I have a list of text data in excel (circa 5,000 rows of text) and I
want to search through each cell and count the number of times a
certain phrase occures.  For example:
Search "ilk" from the following lis, only looking in col A: (where "-"

I have a template that contains cells for number of hours worked in
several rows and columns. I have many copies of this workbook, one for
each employee. I would like to be able to add the cell C3 (for example)
across all of the workbooks that I select...basically merging them all.