Access and Excel

[John Smith]

Hi!

Is there a way to export data in a Excel Sheet telling Access to export
"Filed1" in cell "A32" for exemple..?? If yes, How can I do that in VBA?

Thanks

Jean-Seb

 

[Douglas J. Steele]

See whether what's in http://www.mvps.org/access/modules/mdl0006.htm at "The
Access Web" is what you're looking for.

 

[Anonymous]

I was unable to make it work...??

The fact is that I have a "Invoice frame" made with Excel and I need to
transfert certain data the the Excel sheet...

I have created a module with the "fIsAppRunning" function and the I have
created a TextBox name "TEST" in access. When I click the button, I have
put the code "Sample Excel Automation" in the OnClick event procedure of my
button.

My question is How do I make my "Invoice Frame" open? It's always in the
same directory c:\Program Files\MyApp

Thanks!

JS