I need to run a Macro named UpdateData upon open of the file.
This code is not working.  I placed the below code in ThisWorkbook.
I am able to manually run UpdateData, but it does not run
automatically when I open the file.

Does anyone know how to open a hyperlink without using your mouse?
I've tried a couple of macros but I can't get them to work.  I am
inexperienced with Macros (especially the VBE ones)  Any help would be
MUCH appreciated as it would save me a great deal of time.

Is there a macro to close a workbook after you have imported the information
from that book?  This workbooks name will change on a daily basis.  I don't
want to close the workbook that has just had the information imputed into it.
ie:  book 1 is always open.  I want to imput info ...

Can anyone please tell me how to open the built in "Find" command in
Excel, with a macro
Thanks in advanc
Axel

i have a macro using Application.FileSearch in excell and was working
perfectly. only when we installed windows XP the file search is generating
run time error 1004 as "can't move focus to the control as it is invisible,
not enabled, or of a type that does not accept focus"

I have 200 rows of data and it is inputed daily with the latest data showing
up on the last row.  If I wanted to sort this data by contract and still get
a good graph how would this be done?

Hello and help.
I am getting frequent service desk calls regarding a heavily macro'd Excel
file freezing when it is being opened, and its all because the "Trust access
to Visual Basic Project" setting is not ticked.

This is what I am wanting to do:  When the worksheet is opened, I have
the form =Today() in a hidden cell.  If that date contains the month
of January, I want a specific drop down list to appear in another cell
(H4).  If it contains February, another list should appear in that

Howdie,
For whatever reason excel is "not happy" with the data in column K.  If
I merely press F2 (edit mode) and then enter, it fixes the problem and
Excel is happy! Clearly I dont want to press F2 on each cell....

Based on input from the User, a macro takes data from several worksheets and
inputs the data to a form which then is further updated by the user.  The
screen flickers as the program copies and pastes data.
Is there some way to mask the flicker by using a "splash screen" (if I am

Hi. I'm setting cell background color
Cells(ctr, 4).Interior.Color = RGB(0, 191, 255)
Is there some possibility to write the color definition in different way, eg.
'alice blue' or '#F0F8FF'?

Hi everyone. Could You give me a tip?
In Excel menu->Data->Groups And Conspects->Group option is located. How can
I achieve the same effect from VBA code?
Greetings. P.

I trying to do UK postcode validation.

good however it fails if a postcode of, for example,  xxxx 4at.
Does anyone have a better solution?

In Microsoft Excel --> File --> Properties --> Summary.
There are plenty of fields: Title, Subject, Author, Manager, Company,
Category etc.
I need to change the values (for example set Titel: New Documentation ).

can anyone help with this,
i have series of data segregated like this
example:
richard