I have a DBF file with more than 65535 records. I'd like to read it with
XL2003. I know that XL2003 reads only the first 65535 records when opening
the file. My question is that is there any way via VBA to access records over
65535, e.g. into another sheet?

I've copied some information - actually filtered data - from a source
worksheet (src or "ACTIVE"). Below I write that to a newly created
destination worksheet (dst).
Afterwards I need to copy a row with header information from src to dst.

When recording a macro that creates or defines a range name for a cell, I can
programantically get to the cell I want, but the recorded macro adds a fixed
reference (see example below) that I'd like to control without using a
combination of numeric and string variables.  I'd like ...

What code do I need to run a macro when a file is opened?  The sub name is
PNL.  Also, this file is password protected.  Will that affect anything?
Thanks
Adam Bush

  I am querying data from a SQL server and would like the query to
reference data in the spreadsheet.  I'm not sure how to compose the SQL
query.  Here is what I have so far which, of course, does not work.  I get
syntax errors.

Here's my Macro code (in part). All variables are DIMmed, their type is
indicated by the three letter prefix of the name.
           strSearchItem = rngOuterCell.Value
           Sheets("Earnings Balance 2003 Q4 Page 2").Select

I'm trying to setup a command/macro in an Excel VBA file that would allow me
to send email from my Excel file. When I press on the command button the VBA
syntax page opens than Excel freezes. I use the following in order to go and
get Outlook. Is this right? Any idea why Excel ...

I am wondering if there is a macro that can be written that will delete a row
and also any reference to any cells in that row from froumulas on the sheet.
For example: A1=B1+B2+B3 i then delete row 2 and get A1=B1+#REF+B3, i would
like to get A1=B1+B3.  Is something like this ...

suppose i hav two sheets as follows...
SHEET 1
    ID     location    country
1    211

One of the requirement we have is to convert text files(any delimited)
into excel format. Our scenario is we use ETL tool to extract data
from database and output as flat file. Then we use mv command in unix
to convert text file into excel.

I have two columns, say column C and D with unlimited rows. The text
or quantity starts in each row either from column C or Column D, but
not both. I will need to highlight the starting cell with green by
manually fill it with green to indicate that I need this row. Here is

Hi, I have a problem with a Do Until loop, it doesn't stop unless I
Ctrl Break out of it, here's the loop:
Dim productRow As String
Dim foundRowNum As Integer

How can debug code in workbook open or activate event
Clara

suppose i hav two sheets as follows...
SHEET 1
    ID    location    country
1    211

suppose i hav two sheets as follows...
SHEET 1
    ID    location    country
1    211