Remove borders when ms access 2007 performs an export to excel?

[Teena M.]

Hi,
I have ms access macros that export tables to several different excel
workbooks, but it sometimes inserts borders around some or all of the data in
excel when the export command executes. Is there a way to stop ms access
from doing that? It messes up the clean formatting that I have set up in the
worksheet. I don't want the borders in automatically adds to the data in
the spreadsheet.

Thanks for your time.

 

[Tom van Stiphout]

On Sat, 17 Oct 2009 14:34:01 -0700, Teena M. <Teena
(e-mail address removed)> wrote:

No.
But you can go in after the fact and use Automation to clean up the
workbook to your heart's content. Automation is a big topic, but if
you google (or bing) for "CreateObject("Excel.Application")" you
should find plenty of hits to get you started.

-Tom.
Microsoft Access MVP

 

[S.Clark]

What export method are you using. Most people complain that they can't get
borders, so you're a first. (for me, anyway.)

 

[Teena M.]

I export via an MS Access macro using the TransferSpreadsheet command.

 

[Teena M.]

Thanks, I currently have some excel vb code to do that. Would be nice if
you could turn that off though - would save some steps between pulling the
the data and posting the spreadsheet to the sharepoint site that uses excel
services web parts.