Access field to Excel cell

J

John Smith

Hi!

Hi everyone!

1st - I have a "Invoice Frame" made with Excel.
2nd, I have a form build with access call "Invoice_Information"

Is it possible to transfert the data from my Access Form
(Invoice_Information) to specific Excel Cell?

For exemple:
In my Access Form, I have a TextField Name "SubTotal". When I push my
command button, I would like to data in the field "SubTotal" transfert to my
Excel Sheet in the cell F22
In my Access Form, I have a TextField Name "Quantity". When I push my
command button, I would like to data in the field "Quantity" transfert to my
Excel Sheet in the cell C16
In my Access Form, I have a TextField Name "UnitPrice". When I push my
command button, I would like to data in the field "UnitPrice" transfert to
my Excel Sheet in the cell E16


Thanks for your Help!

JS
 
Top