Click here to Skip to main content
13,301,619 members (70,914 online)
Rate this:
Please Sign up or sign in to vote.
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.
Posted 16-Nov-12 4:26am
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.
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,
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Take a look at some of these links[^].
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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?


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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.171207.1 | Last Updated 26 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100