Visual Basic Express 2010 & Excel

I think this will be easy to answer but I know nothing about code so hopefully someone can help out.
I have an Excel workbook with 2 sheets (Sheet1, Sheet2, Sheet3).
I need Visual Basic Express 2010 code for a button to copy data from form to specific cells in Excel workbook.
For Example:
Copy data from Form1, Textbox1 to Workbook "Invoices" Sheet1, Range A7.

This is a new project and will be progressing such as:
Adding Access database to Excel Via VBE in order to create drop down menu(s)
Making the program secured by username and password for 30 days
Only able to view and print in pdf, hiding all spreadsheets and documents from Excel and Word
etc - but that more headaches to come, for now I just need to build the excel spreadsheet properly

Thanks
elitegroup2010Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
elitegroup2010Author Commented:
No it didnt work. The Microsoft DAO 3.6 Object Library is not in my references either as NET or COM though
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You need to use the Office/Excel Interops in .NET:

https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel%28v=office.15%29.aspx

Basically, you add the namespace to your project, and then work with the objects as you typically did with the COM objects as shown in the link Rey provided.

This shows how to work with Interops:
http://support.microsoft.com/kb/301982

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The two links I provided show exactly how to use the Interops with .NET to work with Excel. I think my comment should be accepted as a solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.