Data Manipulation In Simple Files

[bills2]

Hello,

Getting started on wanting to do some conditional movement of cell
contents in simple Excel files.

I belive I'm going to want do it with macros. Is there a good content,
readable book for VBA or is the Excel X for Mac macro help file any
good? I've not loaded it yet.

Thanks.

Bills2

 

[JE McGimpsey]

Getting started on wanting to do some conditional movement of cell
contents in simple Excel files.

I belive I'm going to want do it with macros. Is there a good content,
readable book for VBA or is the Excel X for Mac macro help file any
good? I've not loaded it yet.

The Excel v.X Help file is pretty good - while it's not as comprehensive
as, say WinXL2000's, Help has improved significantly from XL98 to XL01
to XL v.X. You'll want to load it if you intend to do anything more than
dabble in macros.

If you're familiar with programming, recording macros and using Help may
be all you need. Note that the macro recorder relies on using
Selections/Activations rather than working directly with objects, so the
code usually needs to be cleaned up significantly.

One book I thoroughly recommend is John Walkenbach's "Excel 2000 Power
Programming with VBA". It's written for WinXL, but 90% is compatible
with XL v.X. He's updated it since the 2000 edition, but the updates
aren't applicable to MacXL (Note that all versions of VBA for MacXL are
5.0, which is equivalent to WinXL97, so there may be VBA6 methods that
require a workaround).

And for continued help, post back here or in the
microsoft.public.excel.programming newsgroup.