I need to do a macro to retrieve data from web and populate a sheet.
After some searches, I found that webquery could be the answer.
So, from Data->Import External Data->New Query, I browse to the page
with interested data, select the table I need and import data. It looks

Does anyone have an example macro to write out a range of cells to a text file?
Or an example macro to print out a range of cells to a text file?
Thank You,
-Bryan

I am connecting to an Oracle 9i database through ADO. I loop through the
rows and columns in Excel and pass those parameters to a query which returns
a single value and places it in the appropriate cell. This works fine, but
is awful slow and I have lots and lots of cells to fill.

I have a spreadsheet with data in columns A - J.  Column D contains a listbox
with a Yes/No selection.
If a cell in column D value is 'No' I want to copy the data from cell A of
the same row to Sheet 2 column B.  As the user moves down the data then each

My Pivot Table data set has changed.  On refresh, the new pivot items are
added to the drop down box; the ones which no longer exist are not removed.  
Is there a way to refresh the list to show only items that currently exist?
Thanks in advance!

I have a column B which contains an indicator like AB, AC, AD, AC AA, etc.
In the firsts column, I want to add line with the different value in cell
"A1" (for each different indicator). I tried this but doesn't word.
Dim C As New Collection

Somebody will try to read criticism into my question but none was
intended.
I'm just very interested to know what kind of applications for Excel
programming actually exist in the world outside of these groups. I'm

Dear Friends,
I have the following codes to copy specific data from one sheet to
another
Private Sub CommandButton1_Click()

hello everyone as iam new to VB i have a small query which iam trying
to solve.
I have designed a form with three check boxes and one texbox which is
connected to a column in a table.

See code below.  I load the departments collection with string values
(For example 007).  When I print out the values in a message box they
are string values (For example 007).  But when I execute the statement:
    Sheets("Expenses").Range("E3") = CStr(departments(i))

Greetings all,
I have VBA code in the Workbook.BeforePrint procedure that sets the
print area and other items, and it works well.  It seems that these
settings are used for the current Application.ActivePrinter only.  I

While writing a macro i found a problem which I can't solve.
On the worksheet is a hyperlink containing a datevalue, this has to change
on a dailybase but while writing the macro it writes down the date in the
macro and it won't change the next time i use the macro.

Please can someone help.  I have a few workbooks that has been protected via
Save as\Tools\General options\Password to open.
I want to record/edit a macro to open and enter the passwords for all the
workbooks, but when I record the macro, it ignore the fact that I am typing

How can I manipulate the date in the header for a date 5 days from now
or five days from anytime a sheet is printed. (With a Macro):confused
--
PBANK

I have a source workbook which creates 25 to 30 worksheets, each one's name
ends with "P1"
I want to move these sheets to an existing destination workbook, through a
vba sub residing in the source workbook