I have student data in Columns A-F on rows in my spreadsheet. What I'd like
to do is be able to use a macro/button to select the data in those cells of a
row and pop it in an email? It can just show up as it does in Excel - I don't
need it to look like anything in particular.

I have a listbox that I am trying to set the rowsource with VBA.  If I set
the rowsource manually in the properties window to mynameedrange, my code
works great.  I'm having trouble with the code setting it with VBA.
Here's what I have:

I know this one should be easy, but I can't make it work.  I'm trying
to dynamically define a range and assign it to a combobox on a user
form as the rowsource.  Here is my code:
dim rngGrpList as Range

I have a windows application that runs constantly and an Outlook Add-in. In
the add-in, I am stripping attachments off of emails and putting them in a
folder on the local machine for the winapp to pick up and process. In the
winapp I am opening excel files programatically, ...

sumif won't work on a closed workbook, will it?
for example
in workbook book1 with price closed:
=SUMIF([Price.xls]Margin!$A$2:$A$70,A12,[Price.xls]Margin!$C$2:$C$70)

I'm hoping someone can provide me with some vba to make quick work of my
task.  I have 2 tables (call them table1 and table2) that are setup like:
Store          State         Sales
1                MO            2,120

Don't know if anyone can help me with this or not.
I have a Userform on my spreadsheet for inputting "comments" into. This form
also has a variety of function buttons on it which work just fine, with the
exception of 2 of those buttons (Post Comments-Button 3, and Update

I have recorded a macro that makes a workbook visible, it selects some
information, copies it, pastes it as values, copies it again to have it ready
for pasting it in another worksheet, and then it hides the workbook. All
works perfectly with the only exception that  it is not ...

When this code is run i get the end if without block if error, but i
don't see what i am doing wrong. It highlights the very first "if"
statement
Private Sub btnSubmit_Click()

I wonder who could help me with this. I've got a spreadsheet called “Blank
Form” saved as a template. I want to attach a macro to a button in the
spreadsheet called “Save It” in a way that when someone clicks on it the Save
window opens up and in File name it writes the content ...

I've got the following function that I would like to make versatile enough
that I can use it within VBA code and as a simple excel worksheet function.  
I've pasted the function here where I'm having trouble, I need to figure out
how to count the elements in the range for both ...

I have create this user form that employees use to enter appointments
we have made. Currently the form has fields to enter values, with drop
down list etc... The next and final part to this project (thank god)
is a second form the user will use to search for an appointment they

It seems that the "Workbooks.Add" method has regressed from 2003 to 2007
when using "HTM" file. Here is the "one line macro" that demonstrates the
same. (The attached HTML open fine from "File/Open" menu or using
the API 'Workbook.Open')

I have a dilema, I have one form that is filled out with basic info that
needs to download into two other forms and then save to a pdf.
I can get the general form, and protect it, but am having problems with the
logistics of the other functions.

I have a form that contains a Multipage control, with 4 pages, and about 5
textboxes, 5 labels and 5 commandbuttons on each page. I am trying to use
"For Each ctl In frmOpenFiles.Controls
       If TypeName(ctl) = "TextBox" Then" to go through the controls on the