Prev: Maltese Font?
Next: CAN YOU PLEASE HELP ME.
From: Teena M. Teena on 17 Oct 2009 17:34
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.

From: Tom van Stiphout on 18 Oct 2009 00:39
On Sat, 17 Oct 2009 14:34:01 -0700, Teena M. <Teena
M.(a)discussions.microsoft.com> 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



>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.
>
From: S.Clark on 19 Oct 2009 12:21
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." wrote:

> 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.
>
 | 
Pages: 1
Prev: Maltese Font?
Next: CAN YOU PLEASE HELP ME.