Hello Excel experts,
Couple of questions about Internet Explorer and Excel.
Whats the vba code to check if IE is running and if so, how many browser
windows are open? I want to close all windows but one. If Internet

I have a pivot table on sheet1 that I can change the query parameters
using the PivotCache.CommandText property. But if I copy that pivot
table onto a new worksheet, or copy the entire worksheet, I can no
longer set the PivotCache.CommandText for either pivot tables. If I

I have a list of 700 items on sheet2. The order of the column is like
partno,description, priceper unit.
In sheet1, i want a drop down list showing the items from sheet2. When i
choose the item, i want all the 3 columns to appear on my sheet1. So far i

can anybody tell me whether and if yes how it is possible to re-name a style
in VBA? I want the style-definition to stay unchanged and just change the
name.
Thanks in advance,

Is there a way to set chart text to an absolute position on a chart? I have
text pointing to a cell (which is different length for each spreadsheet) and
when I run a macro the text box that gets created is in a different position
each time.  Is it possible to left justify the ...

I use the following code to create a toolbar:

So I come into work this morning and the Sys Admin tech is running update
scripts on my machine!  One of the biggest changes is upgrading from Office
XP to Office 2003 (SP2).  I use lots of macros in Word and Excel.  Should I
hold my breath every time I launch one waiting for ...

I have a combobox on a userform that is linked to a named range t
provide a list for users to select.  The form works well in feedin
data from the form to a row in the worksheet.  My problem is that
can't get the userform to feed data to the worksheet when the use

I am working with OnKey with Enter & ~.  My procedure works great.  
The procedure reviews the sheet name and processes code if that particular
sheet is the ActiveSheet (i.e. if Sheet X is the activesheet), then procedure
is processed.

Can anyone help me with code that can put a formula in the first empty cell
in a row?  Basically, I want to replace the B3 in the following formula so
that it will put the formula in the first empty cell in row 3.  I'm trying to
make the following formula dynamic.

Does anyone know of a floating bar Gantt program I can add to Personal.xls,
used to track start, stop, percent complete?  Something like the stacked bar
charts on the web.  Don't need cost.  Would be nice if it looks pretty.  Or,
does Excel have this feature imbedded somewhere?  ...

I want to generate a series of small text files, each from the contents of
six cells in one row. I do not want "assistance" from Excel adding quotes or
delimiters. Pasting the contents into Notepad works but it is labor
intensive. How can I do this?

I have to create a range name during an import from an SQL server data base.
During the next time the data import is done. The existing name range has to
be deleted and the same range name is given for the new data imported. This,
if done manually, excel does it correct. But if ...

Hoping someone can help me. I'm trying to make a macro which will
prompt for user input (URL & link description), and create a hyperlink
from the input. I would like the final hyperlink created in the cell
selected by the user before activating the macro

Does anybody know how to use functions in inglis in portuguese excel?
Tks