Just trying to open a Word file from Excel. The code below compiles
OK, and gets as far as opening Word, but then a dialog box pops open
with this:
Run-time error '-2147417851 (80010105)':

Is it possible to clear the data without clearing the formulas?
I have an area of the sheet which is mostly data which needs to be cleared
before updating. A few cells have formulas attached.
Rich

Does someone knows how prevent the dialogue box for saving when I leave
an excel sheet opened in internet explorer ?
The use of "ThisWorkbook.Saved = True" in the event "Before_close" has
no effect with internet explorer

I have a data table in xl2007 that is a ListObject.  What I would like
to be able to do is know which ListRow has been selected. In other
words, if I manually select a cell in a ListObject is there a way to
programatically know which ListRow that is? Banging my head for a bit

Can I have two worksheet_change procedures within the same worksheet code
window? If so, how do I differentiate between the two procedures without
there being a conflict? Upon enacting one of the worksheet_change events, I
have the message that there has been an ambiguous naming ...

I develop electronic form templates in Word, however, I currently have the
opportunity to develop a shipping document in Excel.  I want to insert a
dropdown in cell A1 that contains a single list of the companys plants.  Once
the plant has been selected from the dropdown, the ...

I currently use an Excel sheet to keep track of my stores business daily.  At
the bottom of the page, the sheet keeps track of the days totals for me and
below that I have a space for the monthly total.  Every morning, I open the
previous days sheet and clear the information ...

I know I can input an autofilter such as:
            AutoFilterMode = False
           .Range("A1:D1").AutoFilter
           .Range("A1:D1").AutoFilter Field:=2, Criteria1:=">=35", _

I'm probably an intermediate Excel user and new to this list. I feel
like I'm not even close to using Excel as efficiently as I could. I'm
not afraid of coding macros.
What do you think of this book? Is there a better one?

Hi. newb here.
I have created a userform to add new entries into two different sheets, but
with the exact same type of information (dept, status, project name, etc).
Depending on what type of project it is determines which sheet it goes to.

I need to copy cells from one worksheet to
another [same workbook], based on two conditions. The conditions are simple,
e.g. ISBLANK($A30) and $C30="OPEN", etc. The original column has 200 entries.
Only 50 of them may be copied in consecutive cells in a column on the new

I need to copy cells from one worksheet to
another [same workbook], based on two conditions. The conditions are simple,
e.g. ISBLANK($A30) and $C30="OPEN", etc. The original column has 200 entries.
Only 50 of them may be copied in consecutive cells in a column on the new

I want to take the value of a cell and use it as the address for a hyperlink.
I created Day1 as a variable and to pull the address from the excel document
using Set Day1 = ActiveSheet.Range("M184").  I run into problems once i try
to use Day1 in the href tag in ...

I am looking for the VBA to identify if a workbook is already open and, if
not, to open it, otherwise to open the workbook window.
I have:-
            i)  Worksbooks.Open("Filename.xls")

Currently, Iam doing a very tedious and time consuming job. Please help me
out on this.
I have a workbook having several worksheets like 50+ having the same layout
i.e., Heading1, Heading2, Heading3 .... and may add more with the same