Hi,  I have  UPC code software that will only allow data to be imported
into it's database via ascii (either fixed field or delimited).  Is
there a way to get data out of excel for direct importation.
I was able with relative ease to get data into excel via ascii for

I am trying to remove an infuriating formatting glitch from a table I
am copying from Excel to Word.
In Excel it looks like a normal table.  There is no sign of any funny
formatting.

I am currently evaluating Office 2007 (Trial mode of the release
version of Office Standard) for application in our office. We are still
using Office 97. Office 2007 does of course have very many improvements
which starts to convince me that an upgrade is (finally) becoming very

I need help on the following matter. Suppose i have two column A and B. Now
when i insert some text in the A1 cell i want the data automatically set up
in the B1 Cell. Fox example if i type Linux in the A1 cell "Open Source"
will be automatically inserted in the B1 cell but if i ...

Quite new to excel hope someone can help
I woul like to count the total number or runners starting a different
sites using a number on different routes to get to various point.
I need to count totals and subtotals using the various routes?

Hi Debra,
I browsed your website and found this new data entry
worksheet(http://contextures.com/xlForm02.html) which was very good and
i showed my boss.He liked the idea of it and thus asked me to work on

Hello experts
This pivot table has been created automatically in Excel 2007 : see the
following link
http://dl-1.free.fr/52616e646f6d495687b5f6522854b42d0ab1c5c335e8e7d2b3d67f4e6bf6
721d/Pivottable2007template.xlsx

I'm trying to copy a sheet in a Notes email by macro using VBA with
Excel.
I manage to create the memo, fill the "send to" field and the subject.
I tried this command .FieldSetText("Body", MyWorksheet) but it requires

Is there a way to change default settings for options that are not included
in Tools/Options?
For instance, I would like to default Page Setup to print gridlines.
Normally, this setting is Off, and has to be changed by hand. Is there a way

Using Win XP Pro and Office Professional 2003.
When calculating a large macro driven linked workbook on the network
server - the calculation is very slow.
When I sign on with my roaming profile and calculate the same workbook -

I thought you could Sumif on a whole range, ie if A1 to A10 was your
criteria range, and B1 to D10 was the range from which to sumif.
However it only seems to sum what is in B1 to B10. Is that right?
I know I could use an array formula, but that might be a bit complex

I currently have a sheet with 2 columns of data as follows...
Coulmn A       Column B
    1                    0
    1                    0

I have an Excel spreadsheet that uses a LOOKUP (array) function.  I have
since made added rows to the array, or range of data, that is referenced by
the LOOKUP function.   So now I need to redefine the range but I can't
remember how to find the range that is named in the formula. ...

i have three colum and i want save these in a text file without space between
colum.

is it possible or a reference to allow me to extract data from a html
file...  example, i needed my vba code to return me all href and src attribs
values from a few selected tags.  do i have to clearly write a code from
scratch?  someone in my office said to look up on DOM, ...