I have a workbook with a fair amount of code written into it. I emailed
myself a copy of the workbook home on the weekend to work on it and kept
getting an error with one of the macros at home. I am (was) using the SAME
version of Excel - 2002 SP3 until I got completely ...

Can this be done in version 20002 (XP)?

I have been making some good progress with creating charts summarising data
by use of pivot table and charts.  These are generated from the raw data by a
macro that can be applied to many input data sets.
One problem I have not overcome relates to grouping of data so that I show

I have excell 2002, in the explantion of function AND it says, that Logical1,
logical2, upto logical 30, how ever mine is available for only logical5,
(upto 5 logical). Can anybody help me how to make it upto 10 logical
Frank

what is the steps of inserting a .swf flash file in worksheet, I searched in
the net, but I didn't finf the proper answer..
I recieved some excel (.xls)  by email where I found flash objects in these
files (note: they displaied not as Icon)

I have 132 different files that need to have the same text: "FORWARDED
TO PM DD-MM-YYYY" in the comment section in each of the file's
property box.  I tried to record a macro, but nothing happens in the
property comment box. As I enter the information in each file, I have

Suppose I want to have cells A1 through B3 assigned the following
values:
2,4,8
2,  8,11

I hope someone can help me with this.
I have a column of "encrypted" data (in excel), which needs to be converted.
The data in each cell is "encrypted" by following this simple rule:
A = 1

I use the following code to call the Browse Dialog to select a file.  Problem
is, the dialog box doesn't show any Excel files.  Can you help?
   With Application.FileDialog(msoFileDialogFolderPicker)
       .Show

Is there anyway to edit MP3 tags with an excel spreadsheet. I would
greatly appreciate any help I have hundreds of affirmations that I
recorded, all the filenames are unique but the recorder named all the
titles "1", I need to change the tag title to the filename any ideas?

I used the following code to open a file called 'Copreco Daily Submission
Reading' and import the ensuing record into the Daily Reading Master Log.
Question:  I need to change the code, (and I dont know how), such that
rather than looking for the 'Copreco Daily Submission Reading' ...

Trying to import a txt file that comes out like this:
------------------------------------------------
19:57 The Meadows Race 1
No.  Dog                  Price

How to close the application without saving the changes when user press
"Ctrl" and "Break" button to interrupt the macro during code running?

I have many notepad files that i pick through manually and copy/paste info
out to excel. The notepad file content is logically structured ('bananas =
yellow' in file1, 'bananas = green' in file2 etc. sort of thing). Is it
possible for an excel macro to retrieve external file ...

I tried to use a workbook today that was previously working great.
It have macros and many formulas.
I found that the simple formulas were not working for some reason.
When i close the workbook, and re-open it the formulas have then calculated their result.