VBA is just about driving me mad... it seems every week now I come
across something new that will cause it to crash.  This time it is
when I hit the stop/reset button on the VBA IDE.  I have no idea what
is causing it or where to start looking even.  Has anyone else come

Can anyone help me solve this problem please. When I type a month in
cell "A1", say for example "August", how can I get it to change the
"July" in the link below to "August".
=+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73.

I was wondering if there is any way to open xls file without the need of
excel on the computer ?
Jason

I've gone over the simple examples of creating a c# RTD server.  No
problem.
I don't know if I'm tired, but I can't see too clearly how to adapt
this so that excel can communicate with the RTD server to let it know

       I'm facing with a problem can any one help me on the issue
that i'm facing which is explained further.I'm working on an Hr report
which has 30 sheets in in and in a loop i would like to travel up till
the 25th sheet and while i'm travelling i would like to write some

Excel 2003
I have been using ADO to query Access Databases (which contain only of
ODBC-links) for ages. Now I try to setup the same configuration (here
Firebird database linked to an Access 2002 mdb) in another company. Running

I'm new to this process and I have previous typed the same question but
haven't seen my question on the internet, so here goes again, probably my
fault.
I am using another person's formula. They have used the following brackets {

I have the following simple code:-
Range("E20").Select
   Selection.Copy
   Cells.Find(What:="TECHNOLOGIES", After:=ActiveCell, LookIn:=xlFormulas, _

I finally figured this out with help from some of you. Open a file,
convert hex to decimal numbers, convert to a character (Chr Function),
and write to file. It works great. Problem..... I can't figure how to
do a HEX2DEC conversion within the macro. Just to test all this, I

I can start my external application using the shell command and after about
15s it generates a txt file which I then want to process in Excel.  How do I
make Excel wait for the application to terminate before processes the code
after the shell command.

i have a following code
dim t_string as string
t_string= target.value
target.clearcontents

I've seen that one usually runs Me.Hide inside the OK_Click or
Cancel_Click method, but is it somehow possible to specify a return
value the Show method will return, like MsgBox does for example? Also,
is it possible to specify arguments to UserForm.Show so that the form

Clear data in a FORM row
I have 20 rows of data entry on an Excel FORM.
There is a delete button next to each row that I want to program to "clear"
the row on the FORM

I am trying to figure out how to select the current cell, and copy the
formula down one row.  I am playing with:
For i = 3 To iLastRow + 1
If ActiveCell.Offset(-1, 0).Value <> ActiveCell.Offset(-1, -1).Value Then

Do you know how to load .xla addins when I open an Excel sheet and
there by avoiding references to addins from my Excel sheet?
Lars