Create a new excel workbook from access
 

I need VBA code for -
To open a new excel workbook from access and then insert data or create
a pivot in excel sheet.
I want to pass the name of the file so that its created in excel as
..xls file and the pivot is created in that.

Thanks a lot in advance for your help

Create a new excel workbook from access
 

There's sample code here that may help you get started:

http://www.databasejournal.com/featu...le.php/3563671



ST wrote:
I need VBA code for -
To open a new excel workbook from access and then insert data or create
a pivot in excel sheet.
I want to pass the name of the file so that its created in excel as
.xls file and the pivot is created in that.

Thanks a lot in advance for your help



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html