ATTN: SteveT

  • Thread starter Thread starter Bob Barnes
  • Start date Start date
B

Bob Barnes

Your "Export to Excel" code (from 8/5/03) works great.

Sorry I took so long to test it.

One other question - if it can be done from Access.
When I send the data to the different RangeNames in
Excel, I want to Erase all cells in the RangeNames.
In Lotus 1-2-3, it was {BLANK TheRangeName}.

Since I will be sending the data from Access, can
I "BLANK" a series of RangeNames in Excel prior to
the Exporting to Excel?

TIA - Bob
 
Bob,

If you have a reference set to the Excel Libraries, use the Object Browser
you can quickly check to see methods and properties available for use. In
the VB IDE, select View/Object Browser or F2

It shows the Range object exposes a Clear method.

If you move your cursor and click on Clear(), then press F1 you'll be taken
to the help on that item which shows:
Worksheets("Sheet1").Range("A1:G37").Clear

Steve
 
Steve - You're the Man.

Looks like we'll do some nice stuff with Access & Excel
& Excel Charts.

Thanks again - Bob
 
Back
Top