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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell Otpions in office environment 0
Autonumber field in Excel that behaves the same as Access 0
Mail Merge Directory Conditional Page Break 0
Transfering data to office Application 1
How do I clear a form? 0
Displaying Data Forms in Excel 2016 for Mac 0
Linking data in MS Word into Excel 5
Copy previous record into form field 0

Top