bit of a beginner in excel VBA but i am trying to find out if can check to
see if a file is open
as in
IF 'file a is open' THEN

I am automating Excel using VB6 and I am having a problem inserting a row
(copying row) that contains a simple formula (Sum of two columns).  The
inserts is working fine except it is not bringing over the formula.  Any
ideas (see code below)?

I am trying to limit the number of data entry errors from users.  
In cell F2, I have a drop-down box (data|validation|list) with the valid
options.  
In cell D19, I need to have another drop-down box with a list of all valid

I have build an Add-in and capture the Beforesave Event of all Excel
workbooks my users work with. occasionally my users will open excel workbooks
from a database were the files are actually embeded objects. I have to treat
these files differently than the files my user ...

My code searches for a string, and if found, does something, then continues
in the loop; if not found , it just re-enters the loop (without doing
something).  It loops fine through the err handler once, but then it's like
it can't "see" it any more.  Is this clear?  Is the error ...

I have found a macro that looks to refresh itself every second.  A1 is
=now()
I have the open and close times for a particular market.  Lets say it
opens at 7:00 am (location is C19) and closed at 3:30 pm (location is

I have a spreadsheet that I use as a template.  When a user opens the
spreadsheet it runs a macro (using Auto_Open).  This macro does its thing
with the data and then saves the spreadsheet.
The problem is that the macro is saved with the spreadsheet.  Because of the

I am running Sage in the UK and when I export a report the dates are
exported as text.
I then need to change the format to "dd/mm/yy" - select the cell and
then press enter.

I want to use a macro to copy data from the same cell in all worksheets and
then paste it row by row in the active worksheet.
I'm okay for the code to select and copy, I'm currently using an array
(don't know if there is a smarter way).

I have a rather strange issue that I don't recall encountering ever before.
using Excel 2003
I have text in  Column A and a number in Column B, and the formula = A2 & B2
results in an error with #value being displayed

I have cells in my spreadsheet that list other cell addresses (i.e. they
contain text in the format "WorksheetName!CellNumber"... for example
"Worksheet1!C33")
How can I programatically (or with the use of a function) copy the format of

my worksheet have a button.
i press the the button. and then appear a messagebox.
And that time, i want to move the mouse pointer to the button(Enter), in
the messagebox automatically.

I have never used either of the above applications, so am unsure which to
choose.  My problem:
I need a user to give the location of a text file, which then opens and is
used as a reference point for the rest of my macro (I am basically converting

Is it possible have a List Box or Combo Box act as a macro and/or hyperlink
tool, such that when the user highlights one of the choices and clicks on it,
the selected text appears in the LB or CB, and the macro or hyperlink is
executed?

I want to be able to run a macro in a spreadsheet (which is open but
out of focus) when the user re-select Excel as the active application.
I've tried Excel Application Events
Public WithEvents App As Application etc