Re: Transfer multiple sheets into 1 table
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 13 Sep 2007 20:21:41 -0600
On Thu, 13 Sep 2007 15:38:07 -0700, PatK <PatK@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Sorry to jump into the middle of this, but this looks like an answer for a
problem I have. However, my success is less so. I get a runtime error right
off the bat when I get to:
Dim xlApp As Excel.Application
Do I have to, somehow, have some sort of library linked to access to make
that type of declaration?
Yes. Open the VBA editor and select Tools... References from the menu. Scroll
down and find the Excel library and check it.
John W. Vinson [MVP]
.
- References:
- Transfer multiple sheets into 1 table
- From: Mario
- RE: Transfer multiple sheets into 1 table
- From: gokop
- RE: Transfer multiple sheets into 1 table
- From: PatK
- Transfer multiple sheets into 1 table
- Prev by Date: Re: On Open event does not fire when doing DoCmd.OpenReport in nor
- Next by Date: Stepping through Recordset on Timer Interval
- Previous by thread: RE: Transfer multiple sheets into 1 table
- Next by thread: Re: Transfer multiple sheets into 1 table
- Index(es):
Relevant Pages
|
