hello all...
i have sheet with 6 columns abcdef.
in colum f (row 2)i have the formula  =A2&TEXT(B2,"mmm-yy") i use this
for a refrence in another sheet in the book.

Is there a way to have the DataForm command activate when the file is opened
? I tried the following worksheet event, but nothing happens:
Private Sub Worksheet_Activate()
   ActiveSheet.ShowDataForm

I am trying to sort out some files containing many macros, which were
written originally (not by myself) for a previous version of Excel.
Some of the files contain macro code which is not relevant to that
file, because the file has been created from another file, and then

I have a VBA macro (macro1) in "Master.xls" in which I created a button to
run the macro.
The macro runs and does it's thing. When it is done I do a File Save-As
"Test.XLS". I exit Excel and DO NOT save changes to "Master.xls" (I have

I have a listbox that contains four items, AAA, BBB, CCC and DDD (for
example).  I have a textbox that would contain one of those four
values.  What I would like to do is:
If Textbox.value (i.e. BBB) = Listbox.value (i.e. found in or

I have a worksheet that contains numerical data in cells F5 to something
like F20 or similar (depending on the event).
The data is refreshed from an external source (the time interval can be
adjusted by me).

I wish to place the following values into a single row:
148    407
118    10003    169    364
15    222

I got this macro, to delete duplicate data, from this newsgroup last
week.
I am facing an issue with the same as it start checking again from the
column1 once a duplicate is deleted. Can anyone help me to sort out

Problems with the Chartwizard:
- If you select a range with two columns and use it as the source with the
ActiveChart.ChartWizard method, for an xlXYScatter chart, you'll get two
series, while you had one previously (and that was LOGICAL).

I have an excel template which has some userforms in it.  On one of the
userforms are 9 combo boxes, all of which need to display the same data
from another workbook.  Problem is I don't have a clue how to achieve
this, can anyone help?

how can i automatically update the excel sheet if new files are added in a
folder.(that folder contains various files which are entered there in the
folder)

Dim WRDAPP, WRDDOC
    Set WRDAPP = CreateObject("Word.Application")
    Set WRDDOC = WRDAPP.Documents.Open("A:\card.doc")
Knowing file is in location. Why do I get cannot find?

I am looking to insert a picture based on a cell value. The exact application
is to insert the picture of a person based on choosing their name from a
drop-down list. Anybody have any suggestions; VBA or other? Thank you in
advance for the help.

In C++, I am using xlfDocuments to return the count of open workbooks.
I need to make sure that there are no workbooks open.
So i do the following:
bool IsAWorksheetOpen(){

I have an array that is two wide and an undefined length.  The first
column is a name of a variable and the second column is the value of
that variable.  How can i define all the items as there name = value?
i.e array(1,0) = X array(1,1) = 23  make it so that X = 23.  This is