Using Excel from Access

  • Thread starter Thread starter Anthony de Fex
  • Start date Start date
A

Anthony de Fex

Hello people,

I would like to request some relevent code on how to
functionally use Excel fromAccess with ease.

I have a procedure that opens Excel from Access populating
a spread sheet with data from an recordset and Excel is
opened for me to see the result. What I have works fine at
first. Continues to work fine after that if I repeat the
operation after closing the worksheet and leaving Excel
open. The procedure ceases to work if I close Excel
completely before running the procedure. I have to close
the Access application and open it again to repeat the
whole process.

Thanks in advance

Anthony
 
There's a built-in macro for "Transfer Spreadsheet". That should be all you
need, no?

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Back
Top