[dba-Tech] VBA for Excel

Hi Stephen,

What about squirting it into/out of Access and doing your manipulation there
- you could also create the "audit" s/sheet from access.

You wouldn't have to worry about any auto-runs.

Max


-----Original Message-
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Stephen
Sent: 24 May 2009 09:54
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] VBA for Excel

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

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com