Access and Excel

  • Thread starter Thread starter John Smith
  • Start date Start date
J

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
 
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
 
Back
Top