Changing Embedded Excell Sheet Cell Value, Access 2010

[albasel]

Good day everybody

I would like to embed a blank worksheet in access
form. I want to do a macro to change the cells value when I click on a button,
but I don't know how to do it
Can anybody help me in that?

THANKS

 

[Mihail]

Can you explain what you are trying to do ?

 

[albasel]

I am trying to embed an Excel sheet to a form to display some data from a table the user should fill the other column, playing with the data and cut & paste for some rows, applying some function for a hole column...etc. It means that since the user is familiar with Excel so it is butter to use excel sheet better than other choice. Do you agree with me??

Thanks Mihail

 

[Mihail]

No, but is only my opinion.

Access and Excel work very different.
If the job can be done in Excel then why you need Access ?!?

On the other hand, if you need a DB, Excel don't help much.

Here is something that, maybe, can help you:
http://bytes.com/topic/access/answe...stomized-export-data-access-excel#post3711321

But, again, my opinion: try to avoid to mix this applications.