Hi! I want to check if a workbook is open. If it is open I want to close it.
The probelm is that if I want to check if it is open and it is not the code
cannot find the sheet at all and thus produces an error. Is there any way I
can check if it is open without getting an error? ...

I have a range of cells that contain data.  Some cells are locked to prevent
the data being changed.  Others are unlocked so that the user may enter
data.  These unlocked cells are highlighted by setting the cell color to
yellow (ColorIndex=19).

I was wondering if you can help me with this:
I need to:
1) identify the last used row in a column (not in the whole worksheet)
2) identify whether a column is blank or not

Excel refuses to accept more argument as per below. For example i
wanted to add "if("January","December") to the formula below but it
would not allow me to do it. Can anyone please help!!!!!!
=IF(I5="MAY","APRIL",IF(I5="JU-NE","MAY",IF(I5="JULY","JUNE",-

for my application i created a form with a textbox on it. With a code the
value of the searched cell will be displayed in the textbox. However i also
want the textbox.backgroundcolor to be the same as the cell color. So
something like TextBox1.backgroundcolor = ActiveCell ...

Would it be wise to use Dim statements to declare the members of an
Enumeration as Long, or would that create issues?
I read in the help files that they are automatically defined as Long data
type, but the one issue I'm having without declaring them first with a Dim

Good afternoon!
I recorded a macro to filter a database to show records where the entry in
column 1 was between two dates thus:
Sub DateFilterOn()

Hi! I have a workbook that I have set as an object by reffering to active
workbook. Then I want to save that workbook but I cannot refer to  active
workbook because another workbook is active. Please help me!
Dim oPosFile As Object

We are currently automating Excel; creating a worksheet into which we are
pasting formula's. This generated sheet is opened by users (on a different
machine) which then causes the formula to be calculated.
This has been working fine up to now, until we changed the version of Excel ...

I'm trying to write the long code, but the line not enough, so I want
complete in second line what I will do please help.
Regards

I have a VB app that controls an Excel template (opens it, runs code
against it, closes it).
I have a statement in the code that uses Evaluate with an Excel
formula that contains named ranges. Normally, the Excel template is

I have a UserForm that the Sales people will be using to calculate the cost
of a product.  The UserForm has many Controls such as CheckBoxes, ComboBoxes,
TextBoxes, Option Buttons, etc. for the Sales person to navigate through.  
When the sales person is done entering a products ...

Hi,
I'm working with Excel 2003 SP3.
I have written some code in the Workbook_Before close event.
At the end of this event, I have written a messagebox where you can respond

I have written a vba routine which automates Internet Explorer and
causes a web page to output a report in Excel. The web page creates a
new instance of Excel each time it produces the report.
My questions are, firstly, how do I get vba to 'see' the workbook in

My C# application allows the user to open a file with excel. It is
implemented like this:
                   Process.Start(excel.exe,FileName);
It seems to work fine, it starts Excel, which opens FileName and allows the