Exporting from access 2003 to excel 2003 margins

U

Ultimate

When exporting from access 2003 to excel 2003 how can I maintain the same
margins in Excel used in Access?
 
D

Douglas J. Steele

Margins in what sense? Tables don't have margins associated with them:
that's a concept from printing (and you shouldn't be printing tables)
 
U

Ultimate

When I select analyze with Excel it shows the default margins of .75 for
right and left. I am running this with a report. If I run the word option
it brings across the correct margins. I have setup my default template in
Excel to use the margins I need but for some reason when access opens excel
or saves a report to analyze in excel it ignores this opening template. Any
thoughts? Thankyou
 
D

Douglas J. Steele

I don't know for certain, but I suspect that Access is building the
spreadsheet itself, before it even opens Excel, so your default template
isn't be used (just as if I sent you a spreadsheet, it wouldn't be used)
 
Top