Automated Export to Excel: Huge File Size

[LTofsrud]

Hi everyone,

I am trying to automate an existing report that has to be in Excel format
for B2B reasons.

I have it copying over the recordset from Access and formatting the
spreadsheet using VBA and everything looks great... except for one thing.
The originally report where users entered the data by hand average 30 to 35k.
With automation it has ballooned to 3.5MB!!! What the...?!?

Has anyone else experienced this before? The two sheets look identical so I
can't understand how this is happening. Any advice would be greatly
appreciated.

TIA,

Lance
I am exporting a recordset in Access to Excel and VBA to format the
spreadsheet

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?TFRvZnNydWQ=?=,

I advise you to ask this in an excel-specific newsgroup, as you're more likely
to run into Excel experts there... To help speed things up, be sure to mention
the version of Excel, and post the code that's working with Excel so that they
can see exactly how you're manipulating the workbook.

I am trying to automate an existing report that has to be in Excel format
for B2B reasons.

I have it copying over the recordset from Access and formatting the
spreadsheet using VBA and everything looks great... except for one thing.
The originally report where users entered the data by hand average 30 to 35k.
With automation it has ballooned to 3.5MB!!! What the...?!?

Has anyone else experienced this before? The two sheets look identical so I
can't understand how this is happening. Any advice would be greatly
appreciated.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail