Programming in Excel 2007

Question

3.00/5 (2 votes)

See more:

Dear Experts,

I have a project, I will have one Excel 2010 Sheet which has a button that in order to import data from given .dat file or .txt file. The data from those files will be copied to the specified cells in excel sheet.

I have a basic on Excel and VBA, but I do not know how to start with the project.

Looking forward some helps from experts.
-Khoa

Posted 16-Nov-12 3:26am

khoa pham van

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Nov-12 15:01pm

Do you have a particular question? "I don't know how to start..." is not informative enough.
--SA

khoa pham van 17-Nov-12 7:52am

Thank SA,

That is where can I start to learn to use VBA in excel from the basic, and how I can copy from the give file (.dat/.txt file) in to specified cells in excel. It's like tutorial for me to use VBA in excel.

Thank you,
-Khoa.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PraveenKumarReddyChinta · Answer 1 · 2012-11-25T20:54:00

In Excel 2007 in order to view the code or to start the project one has to do some basic steps.

Select Excel options from Excel Toolbor (present at top left of the excel) and then select popular tab and select show developer tab in ribbon.

This will provide you a developer tab in excel sheet.

Select that and click Visual basic there you can find the code for your project.

Place appropriate debbuger in the code and analyze what is happening there.

And raise issues if you get any in this process?

Cheers!

Richard MacCutchan · Answer 2 · 2012-11-25T22:51:00

Solution 2

Take a look at some of these links[^].

Posted 25-Nov-12 22:51pm

Richard MacCutchan