Excel doesn't like those [] in the filename.

Is this built into CR (a bad choice!) or is this a filename that you're creating
(a bad choice that can be fixed easily by you???).

When I have a generic macro that does this kind of thing, I'll write it so that
it works against the activesheet (or activeworkbook). I won't use the sheet
name/workbook name at all.

If this doesn't help, you may want to post part of the code that causes the
trouble.

Richard Champlin wrote:

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

--

Dave Peterson