I am using a form that has a calendar in it. Does anyone know how to get it
to show todays date when the form opens verses the date i built the form? Not
a huge problem just very annoying.

Here is what needs to be done:
I get a "flat" file (as an excel spreadsheet) twice a month with
billing data for about 50 customers totaling about 10,000 rows.
So, for example, you might see 20 rows of Customer A along with type

I am working on code to extract data from a website.  I am using
CreateObject("InternetExplorer.Application") to start IE.  The code is far
from working perfectly but when I moved the code from an XP computer to a
Vista computer I can’t get past the “Do Until .readystate = 4”  ...

I have several groups of textboxes on my form - all surrounded by frames.
For validation I have a exit_event for each textbox.
But when I tab thru my textboxes the exit_event dosn't start on the last
textbox i a frame. and that goes for all the frames.

I have a worksheet that calcultes rates interactively.  I now want to run it
in a batch mode using another worksheet. This requires the new worksheet to
send an array to my existing worksheet wait for it to calculate it and then
copy the results back into another array from my ...

I have a workbook with each sheet labeled as someone's name. I am
looking for vba/macro to email a worksheet and use the worksheet name
as the recipient.
Any suggestions...?

I have built a Year to date report for my department that I send out on a
monthly basis.  The main file pulls data from other documents to compile
everything.  Because I know the name of every file it will pull from (its not
hard with you watched Sesame Street and learned your ...

I don't know much about VBA and Excel 2007 but am working my way
through it slowly.
Basically, I have two columns. A contains several rows of data, and B
is currently empty. Where A is not empty, I want to put a "1" in

What will be the vba code to display all the "name" (text) of the named
ranges and its reference range it refers to.
I am trying to create some thing like this
For each rname in Activeworkbook.names.count

This is probably a really easy thing to fix, but I am seriously struggling.
ISSUE AT HAND
What I need is to have a worksheet (call it totals) that contains values
from a multitude of other worksheets (call each of them company). This has

I was wondering if someone could post a simple bit of VBA that would run a
basic "SELECT" query on a database using ADO and put the values in a
spreadsheet. This would be a great help.

Can somebody correct this code:
Selection.AutoFill Destination:=Range(Cells(1, 4).Address, Cells(LastRow,
3).Address)
The above one gives a lot of errors.

Hello, I've been asked by a friend if it's possible to disable a users
ability to edit a text box but still be able to view it without making it
grey'd out and the font bleak and hard to read.
I'd normally just use a label but my friend has already made the controls

I need a formula where if Cell (C8) =1 then Change that cell and another cell
to RED
IF (C8=1) then Cell (C8 & D2)=RED
What would the correct formula be?

In a particular column in my spreadsheet I have set up conditional formats to
change the background colour and font colour if certain words are inserted.
The conditional Formatting option on the tool bar gives me a maximum range
of three.