I've been assigned the task of opening about 200 different s/s, with no
two being the same. They'll all have different numbers of worksheets
(some hidden, some not), different formats, number of columns and rows,
and varying degrees of formulas - some much more complicated than
others.

Ideally, I'd like to be able to open each of them and press a button :)
to have their entire contents copied to a new spreadsheet (different
name) into a single column in "Formula" view
(Tools/Options/View/Formula - I'm using Excel 2000). The column would
have the cell reference number and it's contents such as: A1: Date, A2:
38863, A:3 38862, A4: Total, B1: Amount, B2: 25, B3: 20, B4:
=Sum(B2:B3).

I guess my question is (because re-reading the info I just entered it's
become pretty obvious that VBA is the solution) how do I write the code,
and then, how do I attach it as a button to my toolbar? I have NO
previous VBA experience, and only limited exprerience recording and
running Macros (everyone's got to start somewhere...).


--
pollywog1961
------------------------------------------------------------------------
pollywog1961's Profile: http://www.excelforum.com/member.php...fo&userid=1935
View this thread: http://www.excelforum.com/showthread...hreadid=546486