I often export crystal reports into Excel to manipulate/format the data. I
use macros to format the report to make it quicker. I find, though, with
this one particular macro, that I have to go in and change the index number
of the Crystal Report Viewer (CrystalReportViewer[1].xls, ....[2].xls, etc).
How can I make the macro run without having to change the number every time?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle