I am in the middle of writing a macro that will read in an xml file ,
use an xslt to transform the data and then display the data in a row in
excel.
In order to transform the data i need to open an HTML page and read the

I've looked and looked in the archives but I'm not able to find
something this simple and I can't get anything that I've tried to
work.
When a cell in B1 is not empty, i.e., filled, I need the cell in A1 to

I am using the code below to populate the TextBoxes of my UserForm. My
problem is, that "TextBox3.Text = rng(1, 4).Text" refers to a hidden column
so nothing appears in the TextBox3. Is there away around this? While I need
the data in column 4, I do not need it to show on the ...

How can I make the code below refer to the current cell that is active?
Set rng = Range("A200")

I have on a sheet with several graphs and I would like to execute the
procedure below automatically.
In advance thank you for the assistance
Yves

This is so simple I'm pulling my hair out. How do you add values to a
list box. I have a named column I would like to use.

I need a macro or some such app that will automatically create a 3 of 9
barcode in a worksheet from data in a particular cell. When data in the cell
is changed, the barcode changes automatically.
Does anyone know of any free code on the web that will accomplish this?

I'm using SQL Server 2005.
I would like to allow remote (unidentified) users to only see Views in
the Excel ODBC Connection window.
At the moment, when a user opens the Excel ODBC connection window, it

I need to be able to position the vertical and horizontal scroll bars in a
Fame object from VBA.  I have searched the internet for an API or code o do
this without success.  The only frame routine (scroll) doesn't seem to do
this.  Any help would be appreciated.

We have a budgeting process which will kick off in some time and would
like to know if the following is possible in excel. Let me explain the
existing structure prior to the output required. The following
structure is visible via a pivot table and hence the original data is

I am scanning many files and wish to automate the search for use of
non-standard Reference Libraries and controls (eg ActiveX).  Any
suggestions?
Thanks in advance

          I am not sure if this is the correct group or not to ask
this question , If not , I apologize in advance.
          I have a Question regarding addition of WorkSheets of one
Excel Application into the other Master Excel Application. If anybody

Is there a way that when the value in a cell changes that I can input a row
over the changed value and subtotal the previous information?  If the value
in cell 1 was 020 and continued until cell 5.  A new value is entered in cell
6 030.  I want the row to be inserted over the 030 ...

I have created a little macro that:
1) Goes to a specific sheet;
2) Unhides a certain range of cells;
This small macro works well for me.

What worksheet event will allow me to trap changes to comments?