VBA code to open new workbook from access

  • Thread starter Thread starter Tewari
  • Start date Start date
T

Tewari

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
 
Tewari said:
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
Click to expand...


Hi Tewari,

because you want manipulate Excel from Access, I think the best place to ask
is a NG about Access, because you need Access VBA, not Excel VBA...

Maybe you can ask on:

microsoft.public.access

or

microsoft.public.access.externaldata

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Back
Top