Ok MS Excel experts the challenge is set!,
Say you have a worksheet where you have to post the results
for 5 ongoing rounds of tennis,
You have 5 columns representing each round and with these cells

I downloaded your example of Real Time Data Server for Excel 2003 at
http://support.microsoft.com/default.aspx?scid=kb;en-us;327215
and I compiled it.
The code is working fine, and data are correctly real-time updated by

I have an excel sheet, which collects a particular data for different people
and different fields.
It essentially looks like this:
Fields    A    B    C    D

I know it's off-topic, but I saw a reference to Open Office in another
thread and wondered... does OO's spreadsheet app have an equivalent
functionalty to Excel / VBA ?
Richard

The code below is my poor attempt of entering data into one cell depending
on data in another cell:
   Range("E40").Select
    If ActiveCell > 0 Then

I have a macro that i have made that saves to a temp file.  I want to
set the macro to automatically save to this file regardless if the file
already exists.
I have had a play with it and search on here and couldnt find the

Hello, Today I have taught myself a bit of VBA in order to create a
macro I need, but I am having trouble at the final hurdle. I am
assuming I have missed something very basic and someone will have
solved it in 5 minutes!

I am making an order form template for a customer and I have the template
protected and am using the validation setting if they try to use anything but
the current date plus one, i.e. today or tomorrow. But I need Excel to stop
and make them enter the date if they leave it blank. ...

Win local format is "dd/mm/yy"
in VBA
Cells(1, 1) = "08/02/2006"
in Excel sheet display

i have got a new problem this time. I have managed to populate the data
and all in the Combo box and its doing first letter select. but the
trouble is earlier in the list box (form type) when i used to select an
option i used to set the data in another cell.

i am new to excel and i have made this macro in VB. using it i am
populating a dropdown list in the excel sheet.
now this list has some 1200 entries of names. i want a the user to be
able to reach a particular name by just entering the first letter of

I want to connect to a Oracle database using macro.Please tell me what
connection string shall i use for the connection?
Thanks,
Ashish

I need a formula which:
if cell A1= the month (say 9 for September) and A2 = the year (say 2006)
it will return the date of the 2nd Thursday of the month.

Sorry if this is a FAQ...
I am currently in a bind.  The organisation I am working for has thousands
of excel sheets scattered around the business.  Unfortunately around 10% of
them include VBA that uses ADO to connect to a database that is being

Can anyone think of a way to make a Hyperlink (1 Hyperlink, not daisy chained
Hyperlinks) open multiple files?