[dba-Tech] VBA for Excel

Stephen stephen at bondsoftware.co.nz
Mon May 25 06:40:53 CDT 2009



I developed an Excel Workbook to retrieve, manipulate and
consolidate data from several external CSV files.  The
customer wants the end-result Consolidated sheet printed
out.  So far, so good.

Late in the development cycle they have asked for the
intermediate sheets I am creating as part of the build and
consolidate to be exported out to a separate new Workbook
(for audit purposes and fair enough I suppose).  

I could do this looping through the new sheets I create,
dumping them into the new Workbook, but I wonder whether
instead I could simply do a SaveAs <newname> on the
existing/processing workbook.  

The problem that I see then is that there is  auto_open()
code and any time they open the 'results' workbook with this
in it, this code would run (which would be inappropriate).
Is there any way I can disable this during the SaveAs of the
<newname> file?  I'm reasonably au fait but certainly not
expert in Excel VBA.

Stephen Bond




More information about the dba-Tech mailing list