First part of the code runs a "Make Table" query.
I need to tag some code on to the bottom to open the excel workbook which
contains the pivot that links back to the table created in the first part of
the code.
Quote:
> >I would like to open an existing excel workbook on a share on a network =
> >server using VBA.
> >Path therefore \\server1\workbook.xls
> >Easy I'm sure.
> >Thanks
> >Darren Salmon
> if it is just a need to open the file, and use of a button would
> woek, just put the files path and name in the hyperlink property of
> the button
> ----------------
> Richard "ManxMan" Killey
> www.comeandread.com/access
> visit my site for tips
Open Excel workbook