I'm trying to make a sub PrintAttendance (student).
On sheet "Attendance Letter", I want to copy the dates and hours (skipping
days absent) of a selected student.  On sheet "Attendance",  the student's
names are located A33:A150, their attendance hours X33:IV150 (each row a

I am wondering how to specify a font color for a string in VBA. For
example, using the following,
aString="Hello World!"
bString="Adios World"

I have a list of macros and modules on a PC at work, I will leave this
work and want to copy these macros to my flash memoey and then delete
them from the hard disk completly, any help?
Thank you in advance

Can anyone please amend this formula for me.
=IF(SUM(NOW()-E:E)>2,"YES","")
I want the above formula to be functional only if G:G has null value in it.
Please somebody guide me with this.

Just got RTM excel 2007.
Looks like there is no way to enable macros on a xslm file if it has a
password on it.
To recreate:

I need to apply Diagonal Borders to cells B15:B25 in an X
configuration. Based off of the values in C15:C25. If C15:C25 are
Blank no borders, If they are not blank Borders...lol. I have no idea
what I am doing and any help would be greatly appreciated!!!

I have this code and it works good. But how can i get it to exit the macro if
<> vbyes
Thanks Mike
Set FD = Application.FileDialog(msoFileDialogOpen)

I've got a program that I've created in Excel using VBA.  I'm creating some
calculations from sheets that are imported from elsewhere.  I'm needing to
create a sum formula on the worksheet.  The column and row reference for
where this formula will be placed will differ by ...

Hello folks-
I'm going to be trying to perform a task that I'm not sure if it's possible,
so i'm not looking for someone to write it for me, I just wanted to know if
something similar had already been written that I could get some perspective

New Computer
Vista Premium
Using Microsoft Wireless Laser Mouse 6000
Office 2000 Premium

I need to create a word doc using a word template with merge fields in it.  
I would like to have a button in excel that launches the word template and
populates it with data that is stored in various sheets of my excel workbook.
Is this fairly straight forward and does anyone ...

I would like to add a cell to an existing range in a macro.  I am new to
programming ranges and need some direction on this.

I could really use some help with a macro.  It has been several years
since I did any macro programming and I feel completely lost.
I have recently volunteered my services to the local waterboard to
help them with their books.  They are really a mess.  One Excel file

Hey guys,
I have 2 xls files from one of my web quizzes (both exported from mysql in
excel format), and i'm trying to merge them in one file.
1st file example:

I have a spreadsheet where the users input their loginname and the file is
saved automatically using the loginname. Everything seems to work fine except
that when I save the file through File>save command both prompts (see below)
keeps on appearing in a loop.