I have saved an Outlook email message as an .msg file.  Need an Excel
macro that when run from an Excel worksheet would open that message.
(Also would saving the message as an .html file or .txt file work
better from within the macro?)

I need to add text from a Userform Textbox to a worksheet.  Sometimes the
textbox may conatin a few sentences.  I would like my code to put the textbox
text into the merged cells, wrap the text to fit, and automatically adjust
the row height.  

I am designing a system that I want to look like it is not an Excel
spreadsheet. I would therefore like the UserForms to fill the screen. I can
do this manually but if somebody else has a different screen resolution it
doesn't fit right.

I have the following code:
Sub HideAroundSelection()
   Dim intRows As Integer
   Dim intCols As Integer

hi, don't know what's wrong with this function. it shall take the value of a
cell and via select case look, whats in it and write into the active cell a
certain text.
Function PreTimeSlotsConv18(PreSlot18)

I have a column in Excel consisting of 1's and 0's. I need to
calculate the average size of consecutive cells (groups of cells)
containing 1's.
For example, the average size of consecutive cells containing the

Hey all,
I have a chart that is linked to a data page within an XL workbook.
There is a main data page where I can have 5 or 6 column of data.
There is another data page called "Map1 Data" where I can select two

Let's say I have a column with the number 1-100.  I want to scan thru
each number until I hit the number 70.  Is there a graphical way to do
this or must I know how the VBA syntax and type it in the code?

Can someone please help me create a macro to search an Excel worksheet(in
column B) for a cell value("42285") and return a statement("European Trade")
in column "E". The data can always change and the rows of data can be up to
3,000 rows.

I have an IF statement in a macro.  If one branch is selected, I would
like to halt (not end) macro execution and open up the VB editor
window.  What code would I use to accomplish this?...TIA, Ron

I have a macro that generates user files, populates shared directories with
them, and I use a Ron de Bruin routine to send an Outlook message to inform
each user of the file existence.  I would prefer to send the user a hyperlink
to the file, but my attempts just send plain text. ...

I have a Inputbox i would like to use to set the AutoFilter criteria1. Then
display the results of that filter on the active worksheet. This is what i
have so far...
Sub Sort()

All,
I have a Macro that throws error 1004 on the ShowAllData method.  This
Macro will work on 2000 but not 2003.  Below is the code.  Any help
would be greatly appreciated.  I copied the start of the macro down to

I have a formula, ='G:\Salaries\[01a Salaries              
Apr07.xls]Data'!smithj, that pulls data from a separate workbook and works
fine.
But I would like to make this formula copyable across rows and columns. I

I'm not sure I'm doing this right.  I used this to open the other workbook
in another procedure and it worked fine.  Now I'm getting an out of range
message.  Also, am I identifying the two different workbook correctly in
determining the LusedRow?